Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts
INTRODUCTION To LATCH 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 are typically used to prevent more … Continue reading Latches and Mutex
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