Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get All sql history in oracle 10g

1977272Jan 29 2014 — edited Jan 29 2014

How to get all select and insert statement from the beginning in the oracle? I tried, "select * from v$sqlarea;" but it's giving only today results, but i need all select and insert statement from the beginning where oracle installed or before particular month. Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2014
Added on Jan 29 2014
9 comments
1,081 views