Re: sample_io

On Jun 13, 2001 at 03:30:47AM, Guy Hammond wrote:
> 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?

DECLARE tail_of_lru as RAW(5) and try to launch it. I think it's a bug.

SQL> SELECT utl_raw.length(HEXTORAW('4000000000')) value FROM dual;

    VALUE

        5

-- 
Vladimir Begun               | The early bird who catches the worm works
http://vbegun.net/           | for someone who comes in late and owns the
http://vbegun.net/wap/       | worm farm.
me_at_vbegun.net                |          -- Travis McGee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vladimir Begun
  INET: jester_at_whale.sunbay.crimea.ua

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).