Tag Archives: Top useful scripts for Monitoring Oracle Database

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 »