We 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 […]
Techgoeasy
Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts
