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 …