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