Oracle

  SQL*Net more data to client event wait In Oracle We generally got the wait “SQL*Net more data to client” in our performance reports. Wait event:SQL*Net data to clientSQL*Net more …

  ORA-04030: out of process memory when trying to allocate 4152 bytes (8475.kgghte,8475.kgghte) ErrorIn our case, we are getting the error in alert log during normal production timing:Mon Jan 07 …

  ORA-31641: unable to create dump file Expdp error During the EXPDP backup we are getting the following error on executing the command ErrorC:Usersoracle>expdp full=y directory=dbdumpExport: Release 18.0.0.0.0 – Production …

  Found Log Switch Gap status in archive dest status We are planning to switch-over the database from primary to secondary in Data guard environment. When we are checking the …

  Memory Paging cause Oracle database performance issue ErrorOn checking the operating system, heavy paging is notice which degrade the performance of the Oracle Database. On unix base systemvmstat and …

  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: …

  RMAN-06429: TARGET database is not compatible with this version of RMAN ErrorWhile connecting with RMAN Command window getting the following errors: RMAN-06438: error executing package DBMS_RCVMAN in TARGET databaseRMAN-00571: …

  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 …