Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO

user4339084Oct 30 2015 — edited Oct 30 2015

Hello,

I'm in a 11gR2 .In the same host (and Solaris 10 ) where exist different instances under the same $ORACLE_HOME i have to use  V$BACKUP_SYNC_IO or  V$BACKUP_ASYNC_IO depending on the instance i connect

What's determine this behaviors ? I don´t understand hot to enable   Sync or Async .

I've read:

https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmtunin.htm#BRADV89862

With synchronous I/O, it is difficult to identify specific bottlenecks because all synchronous I/O is a bottleneck to the process

if you see data in V$BACKUP_SYNC_IO, then the problem is that you have not enabled asynchronous I/O or you are not using disk I/O slaves.


thnaks to all and regards.

Francesco

This post has been answered by Dude! on Oct 30 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 27 2015
Added on Oct 30 2015
6 comments
1,876 views