• Home
  • Services
  • About
  • Training
  • GoldenGate
  • Resources
  • Log In
  • Log Out
  1. Home
  2. Knowledge Base
  3. Scripts
  4. Monitoring
Searching...

Monitoring

  • Script – Monitor Flashback Logs

    PROMPT How Far Back Can We Flashback To (Time)? PROMPT select to_char(oldest_flashback_time,'dd-mon-yyyy hh24:mi:ss') "Oldest Flashback Time" from v$flashback_database_log; PROMPT PROMPT...
  • Script – Temporary tablespace usage

    — Listing of temp segments.— SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used, D.mb_total –...
  • Monitor long running operations using v$session_longops

    SELECT SID, SERIAL#, opname, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) COMPLETE FROM V$SESSION_LONGOPS WHERE TOTALWORK != 0 AND SOFAR != TOTALWORK order by...
  • Monitor Data Guard Log Shipping

    Note: This query needs to be run on the Primary database. SET PAGESIZE 124 COL DB_NAME FORMAT A8 COL HOSTNAME...
  • Identify active transactions in undo and rollback segments

    col o format a10 col u format a10 select osuser o, username u, sid, segment_name s, substr(sa.sql_text,1,200) txt from v$session...
Next
© Copyright Gavin Soorma.
  • Home
  • Services
  • About
  • Training
  • GoldenGate
  • Resources
  • Log In
  • Log Out