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 …
-
Oracle
Script for move partition stats of previous to next month automatic in Oracle
by tuanlpby tuanlpScript 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 …
-
OraclePerformance Tuning
Read of datafile ‘E:ORADATAORCLTEMP01.DBF’ (fno 201) header failed with ORA-01202
by tuanlpby tuanlpRead 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 …
-
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 …