|
-
It can be as simple as this :
select sql_text, hash_value, first_load_time from V$sqlarea order by first_load_time desc ;
This should give you all latest SQL that ran in the database..
In case you want to dig deep, get the hash value and find in sql_text as
select sql_text fromk v$sql_text where hash_value = &hash_value order by piece;
OCP 8.0, 8i, 9i
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|