Copy password file from primary to standby in RAC Environment Errors:–PRODDB – Primary databaseError: ORA-16810: multiple errors or warnings detected for the database –DRDB – Physical standby databaseError: ORA-01017:…
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…