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 lock that can be very […]