SQL & PL/SQL

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!

How to find username, sql_text, date in history

ilke_altinpullukMar 14 2012 — edited Mar 15 2012

Hi all,
We use 9i, 10g, 11g databases and I need which query did the user run at last week each version of oracle? What can I do to find these information like following? Thank you

select USERNAME, DATE_TIME, SQL_TEXT from ......

Edited by: ilke_altinpulluk on 14.Mar.2012 01:43

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 12 2012

Added on Mar 14 2012

16 comments

3,568 views