Translate this Page

 

In our finance database (Oracle EBS 11.5.9), I found there is a big snapshot log. I found AP.MLOG$_AP_INVOICE_DISTRIBUT has size more than 21 GB and still growing. The size of the tablespace APD is 26 GB, so that snapshot log has consume more than 80% of tablespace APD.

First of all, I analyze which is the master table that used this snapshot log.

 

SELECT MASTER, log_table, snapshot_id

  FROM dba_snapshot_logs

 WHERE log_table = ‘MLOG$_AP_INVOICE_DISTRIBUT’;

  Continue reading »

© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha