CODEWITHSUNDEEP
oracle-databaseoracle11g
Sean Nguyen
Sean Nguyen

Reputation: 13118

Recording sql statements performing on a table in Oracle

Is there a way to record sql statements performing on table in Oracle? I need to record those queries for a table in production and hopefully rerun them in my test to make sure I don't mess up table modification.

Thanks,

Sean

Upvotes: 1

Views: 147

Answers (2)

davidsr
davidsr

Reputation: 730

Oracle automatically records any SQL executed against the instance in a table called v$sqlarea

Upvotes: 0

Olaf
Olaf

Reputation: 6289

Oracle Database Replay is exactly the feature you are looking for: http://www.oracle.com/technetwork/articles/sql/11g-replay-099279.html

Upvotes: 4

Related Questions