RMAN – V$BACKUP_ASYNC_IO

SELECT TYPE,TO_CHAR(OPEN_TIME,’dd/mm/yyyy hh:mi’),TO_CHAR(CLOSE_TIME,’dd/mm/yyyy hh:mi’), SHORT_WAITS,LONG_WAITS,IO_COUNT,LONG_WAITS/IO_COUNT,effective_bytes_per_second, FILENAME
FROM V$BACKUP_ASYNC_IO

You can check the RMAN CHANNEL PERFORMANCE using this query

Advertisements

One Response

  1. This Rman script in not running i am getting following error
    SP2-0552: Bind variable “MI” not declared.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: