Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Truncate $mlog table without stop DBMS_jobs
hi,
we run a Oracle8.1.7 database whose content is snapshoted to other three satallite oracle DB. The refreshing period is 5min. We set up DBMS_jobs to execute refreshing automatically.
Last Saturday, we falled into Oracle software bug ORA-12008 error in materialized view refresh path( ORA-00001 ORA-02291 ORA-02292), and automatic refreshing failed. After doing full refreshing, automatic refreshing recovered. But, we found one of $mlog table is much bigger than usual. I want to truncate the table to improve performance.
Someone suggested, before $mlog truncating operation DBMS jobs and other applications should be stopped. Because applications may modify dictionary of snapshotted item. A manual full refreshed should be executed before truncate operation.
As execution time of DBMS_jobs on three satallite DB do not coincide with each other.
Is that possible to do truncation operation without stoppting any application and DBMS_jobs?
Joe Received on Tue Mar 27 2007 - 11:36:54 CDT
![]() |
![]() |