Hello,
I have an Oracle database still in 11.2.0.4 where I'm trying to analyze some statements shown in output of spreport of statspack.
I previously set the statistics level to 6 but when I run sprepsql and give begine snap is, end snap id and old hash value, I get this
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 4505
Begin Snapshot Id specified: 4505
Enter value for end_snap: 4557
End Snapshot Id specified: 4557
Specify the old (i.e. pre-10g) Hash Value
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for hash_value: 3719866645
Hash Value specified is: 3719866645
declare
*
ERROR at line 1:
ORA-20200: Hash value 3719866645 does not exist in end snapshot
ORA-06512: at line 66
If I check v$sql in effect I don't find any row wit that value (3719866645) in OLD_HASH_VALUE columns
The range of the begin and end snaps specified is from 00:10 to 14:00 of today
Do I have to sort of tune v$sql to retain more....?
How can I manage this kind of error?
Normally I'm able to run the script (on other databases) and get the detailed statistics with explain plan of the involved statement....
Thanks in advance,
Gianluca