We often need to monitor the oracle database session for performance reason, check for locks,get location of datafiles, redo files , get the information about db_links .Here are Top oracle dba scripts for Oracle Database for Administrative and Monitoring purpose Script to find the sid of the session you are logged in as select distinct(sid) […]
Database Useful scripts
Latches and Mutex in Oracle database
Introduction To Latch in Oracle Database Latches are low level serialization mechanisms used to protect shared data structures in the Oracle SGA. The implementation of latches is operating system dependent, particularly in regard to whether a process will wait for a latch and for how long. A latch is a type of a lock that […]
