27 oracle dba scripts for Oracle Database for Administration and Monitoring

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) …

27 oracle dba scripts for Oracle Database for Administration and Monitoring Read More »