| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> sample_io
<span style='font-size:10.0pt;
font-family:Arial'>Hello,
<span style='font-size:10.0pt;
font-family:Arial'>
<span style='font-size:10.0pt;
font-family:Arial'>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 <span
class=SpellE>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:
<span style='font-size:10.0pt;
font-family:Arial'>
<span style='font-size:10.0pt;
font-family:Arial'>ORA-06502: PL/SQL: numeric or value error: raw variable
length too long
<span style='font-size:10.0pt;
font-family:Arial'>ORA-06512: at "SYS.SAMPLE_IO", line 21
<span style='font-size:10.0pt;
font-family:Arial'>
<span style='font-size:10.0pt;
font-family:Arial'>Looking at the source,
<span style='font-size:10.0pt;
font-family:Arial'>
<span style='font-size:10.0pt;
font-family:Arial'>SQL> select text from dba_source
where line=21 and name='SAMPLE_IO';
<span style='font-size:10.0pt;
font-family:Arial'>
<span style='font-size:10.0pt;
font-family:Arial'>TEXT
<span style='font-size:10.0pt;
font-family:Arial'>----------------------------------------------------------------------------
<span style='font-size:10.0pt;
font-family:Arial'> tail_of_<span
class=GramE>lru := hextoraw('4000000000');<span
style='mso-spacerun:yes'> -- init to very large value
<span style='font-size:10.0pt;
font-family:Arial'> tail_of_<span
class=GramE>lru := hextoraw('4000000000');<span
style='mso-spacerun:yes'> -- init to very large value
<span style='font-size:10.0pt;
font-family:Arial'>
<span style='font-size:10.0pt;
font-family:Arial'>What should these values be? Or is the problem something
else?
<span style='font-size:10.0pt;
font-family:Arial'>
<span style='font-size:10.0pt;
font-family:Arial'>Thanks,
<span style='font-size:10.0pt;
font-family:Arial'>
<span
style='font-size:10.0pt;font-family:Arial'>g<font size=2
face=Arial>.
<span style='font-size:10.0pt;
font-family:Arial'>
Received on Wed Jun 13 2001 - 07:01:42 CDT
 |
 |