Search This Blog

Total Pageviews

Tuesday, 3 January 2012

Oracle minact-scn master-status in trace file

minact-scn master-status


error message in Trace file " minact-scn master-status "




In On Oracle Version
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production


In my case file location

/****us/oracle/Diag/diag/rdbms/aptdb/aptdb/trace



-rw-r-----. 1 oracle oinstall 125969 Jan 3 09:40 aptdb_mmon_2433.trc <<<<< trace file in



-bash-4.1$ tail -100 aptdb_mmon_2433.trc

*** 2012-01-03 09:30:01.182
minact-scn master-status: grec-scn:0x0000.0029e860 gmin-scn:0x0000.0029e860 gcalc-scn:0x0000.0029e860
minact-scn master-status: grec-scn:0x0000.0029e912 gmin-scn:0x0000.0029e912 gcalc-scn:0x0000.0029e912

*** 2012-01-03 09:40:07.680
minact-scn master-status: grec-scn:0x0000.0029e9b3 gmin-scn:0x0000.0029e9b3 gcalc-scn:0x0000.0029e9b3

*** 2012-01-03 09:45:08.186
minact-scn master-status: grec-scn:0x0000.0029ea76 gmin-scn:0x0000.0029ea76 gcalc-scn:0x0000.0029ea76







metalink note ID...

Minact-Scn Master-Status: Grec-Scn Messages In Trace File [ID 1361567.1]




Cause
Bug 11891463

The issue is similar with BUG 11891463 - MINACT-SCN MASTER-STATUS MESSAGES WRITTEN TO MMON TRACE FILE


solution ...
-----------


SQL> alter system set "_enable_minscn_cr"=false scope=spfile; ----- restart the database ..

System altered.


or


"_smu_debug_mode=134217728"



After setting above parameter the message will not be generated but This will disable min active SCN optimization feature.

"min active scn" introduced in 11g which is supposed to enhance delayed block cleanout operations.
Note : - Disabling min active scn optimization feature will not have any impact on database.

No comments:

Oracle DBA

anuj blog Archive