sample_io

[Guy Hammond]

Hello,   I'm having a problem using the sample_io stored procedure to gather per-object I/O statistics from one of my databases. I run the script $ORACLE_HOME/rdbms/admin/catio.sql as SYS, which completes successfully, then I attempt EXECUTE sample_io(5, 10); where 5 is the sample time, and 10 is the pause between samples. However, the stored procedure fails to execute with the error:   ORA-06502: PL/SQL: numeric or value error: raw variable length too long ORA-06512: at "SYS.SAMPLE_IO", line 21   Looking at the source,   SQL> select text from dba_source where line=21 and name='SAMPLE_IO';   TEXT ---------------------------------------------------------------------------- �� tail_of_lru := hextoraw('4000000000');����� -- init to very large value �� tail_of_lru := hextoraw('4000000000');����� -- init to very large value   What should these values be? Or is the problem something else?   Thanks,   g.