Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN question(s)
There's a slight error in this script: change 10485760 to 1048576.
Sorry 'bout that.
On 9/17/07, Jared Still <jkstill_at_gmail.com> wrote:
>
>
> I've pasted a script at the end of this post to get you started with it,
> if you
> would like to use it.
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>
> --------------------------------------------------
>
> -- rman_io_stats.sql
> -- aggregation of compatible stats
> -- from the v$backup_async_io and v$backup_sync_io views
> --
>
> alter session set nls_date_format = 'mm/dd/yy hh24:mi:ss';
>
> col device_type format a10 head 'DEVICE|TYPE'
> col type format a15
> col filename format a40 head 'FILENAME' TRUNC
> col buffer_size format 99,999,999,999 head 'BUFFER SIZE'
> col buffer_count format 9999 head 'BFFR|CNT'
> col open_time format a18 head 'OPEN TIME'
> col close_time format a18 head 'CLOSE TIME'
> col elapsed_time format 999,999 head 'ELAPSED|SECONDS'
> col set_stamp format 9999999999 head 'SET STAMP'
> col set_count format 99999 head 'SET |COUNT'
>
> col megabytes format 99,999,999.0 head 'MEGABYTES'
> col total_megabytes format 99,999,999.0 head 'TOTAL|MEGABYTES'
> col effective_bytes_per_second format 999,999,999 head 'EFF BYTES|PER
> SECOND'
> col io_count format 999,999,999 head 'IO COUNT'
>
>
> set line 200
>
> break on set_stamp skip 1 on set_count
>
> --spool rio.txt
>
> SELECT
> set_stamp
> , set_count
> , open_time
> --, close_time
> , device_type
> , type
> , filename
> , buffer_size
> , buffer_count
> , bytes / 10485760 megabytes
> , total_bytes / 10485760 total_megabytes
> , effective_bytes_per_second
> , io_count
> , elapsed_time/100 elapsed_time -- stored in centiseconds
> FROM v$backup_async_io -- disk
> union
> SELECT
> set_stamp
> , set_count
> , open_time
> --, close_time
> , device_type
> , type
> , filename
> , buffer_size
> , buffer_count
> , bytes / 10485760 megabytes
> , total_bytes / 10485760 total_megabytes
> , effective_bytes_per_second
> , io_count
> , elapsed_time/100 elapsed_time -- stored in centiseconds
> FROM v$backup_sync_io -- tape, probably. could be disk
> ORDER BY 1,2,3
> /
>
> --spool off
> --ed rio.txt
>
>
>
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 18 2007 - 17:17:00 CDT