Tag Archives: Database Useful scripts

Latches and Mutex in Oracle database

Last updated on February 23rd, 2019 at 07:53 amIntroduction 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 can be … Continue reading Latches and Mutex in Oracle database »

27 Useful scripts for Oracle Database for Administrative and Monitoring purpose

Last updated on February 23rd, 2019 at 06:46 pmWe often need to monitor the database session for performance reason.Here are Top Useful 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) from v$mystat; Script to see all active session select username,osuser,sid,serial#, program,sql_hash_value,module from v$session where username is not null and … Continue reading 27 Useful scripts for Oracle Database for Administrative and Monitoring purpose »