Top useful scripts for Monitoring Oracle Database

We often need to monitor the oracle database session for performance reason, check for locks,get location of datafiles, redo files , get the information about db_links .Here are Top oracle dba 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) […]