Skip to Main Content

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!

sql text from statspack tables

Hi,

How can I get sql information from statspack tables stats$sql_text, stats$sql_summarry..?
I tried writting sql but not able to get the proper results, please help.

select b.hash_value hash_value, a.snap_time snap_time, b.module module, b.fetches fetches, b.executions executions,
b.rows_processed rows_processed, b.cpu_time cpu_time, b.elapsed_time elapsed_time from stats$snapshot a,stats$sql_summary b
where a.snap_id=b.snap_id and b.snap_id between 1 and 13

and I need to get the complete stats$sql_text.sql_text in the same query without using any procedure or function..

version is 9.2.0.8.

Thanks
clin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2010
Added on Feb 5 2010
0 comments
461 views