Understand the terminology involved in Buffer Cache Buffer CacheOracle having copies of database blocks for frequent access instead of fetching from disks known as buffer cache in SGA area. It’s …

 Check database is Administrative and policy managed in RAC Administrative: DBA manages each instance of the database by defining specific instances to run on specific nodes in the cluster.Policy: DBA …

 Check session in waiting and how much time from its waiting COLUMN event FORMAT A30COLUMN wait_class FORMAT A15COLUMN sid format 9999select sid, seq#, EVENT, WAIT_CLASS, SECONDS_IN_WAIT from v$session_wait ORDER BY …

 Hard Parses If session execute the SQL statement that not present in the shared pool then Oracle need following steps to placed in memory:1. Allocate memory for the statement from …

  Soft Parses wait in Oracle Soft ParseSession executes a statement that exists in shared pool is refered to Soft Parse. Note: General high “parse call” (> 10/sec.) indicates that …

  Purge the RECYCLEBIN in Oracle RECYCLEBIN feature is enabled by default. It is used for the recover purpose if you table is dropped accidentally. Check the table present in …

  Script for move stats of previous to next month partition in Oracle In one of our customer is facing problems on first of every month due to no data …

  ORA-28000: the account is locked 1. Check the Status of User account in Oraclecol username for a22col account_status for a17col profile for a10Select username, account_status,profile from dba_users where username …