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…
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…
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…
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…
Read of datafile ‘E:ORADATAORCLTEMP01.DBF’ (fno 201) header failed with ORA-01202 During the running the datapatch -verbose command for applying patch on DB, We got the following error:Queryable inventory could…