RMAN-03002: failure of register command ErrorI am going to register the 12c database in 11g RMAN catalog database and getting the following error: rman target / catalog rcv_user/rcv_passwword@RCVCATRecovery Manager:…
Shared pool tuning due to performance issues In Shared pool area of SGA memory, Oracle keeps the DDL of SQL queries, PL/SQL packages, object information and etc. For understanding…
Tuning Buffer Cache and DBWR process for performance Understand the terminology involved in Buffer CacheBuffer CacheOracle having copies of database blocks for frequent access instead of fetching from disks…
Buffer busy wait in Statspack report Oracle ERROROn fetching the statspack report from Oracle Database, We are getting the Buffer busy wait on top: Avg Total Wait wait Waits Event…
Buffer Busy Waits in Oracle Buffer busy waits is directly related to I/O in statspack report its also directly relate to “db file sequential read” and “db file scattered…