Database Useful scripts

Latches and Mutex in Oracle database

Oracle, 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 […]

Latches and Mutex in Oracle database Read More »

27 oracle dba scripts for Oracle Database for Administration and Monitoring

Oracle, Oracle Database

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)

27 oracle dba scripts for Oracle Database for Administration and Monitoring Read More »

Scroll to Top