Tag Archives: Database Useful scripts

Top Useful scripts for Oracle Database for Monitoring purpose

Last updated on August 19th, 2016 at 06:40 pmWe often need to monitor the database session for performance reason.Here are Top Useful Scripts ¬†for Oracle ¬†Database for 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 status … Continue reading Top Useful scripts for Oracle Database for Monitoring purpose »

Latches

Last updated on November 14th, 2015 at 02:46 pmINTRODUCTION Latches are low level serialization mechanisms used to protect shared data structures in the 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 very quickly acquired and freed. Latches … Continue reading Latches »