Home » RDBMS Server » Server Administration » MMNL trace genration (HPUX: Version 11.2.0.2.0 )
MMNL trace genration [message #555853] Tue, 29 May 2012 07:30
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hi Experts,

we have lot of trace file generated for MMNL. Providing the output, can you please suggest and help in diagnosis the issue.

Trace file /opt/oracle/diag/rdbms/prod/prod/trace/prod_mmnl_18640.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /u01/prod/product/11.2.0/db
System name:    HP-UX
Node name:      ten
Release:        B.11.31
Version:        U
Machine:        ia64
Instance name: prod
Redo thread mounted by this instance: 1
Oracle process number: 23
Unix process pid: 18640, image: oracle@thunder (MMNL)


*** 2012-05-29 08:11:08.020
*** SESSION ID:(675.1) 2012-05-29 08:11:08.020
*** CLIENT ID:() 2012-05-29 08:11:08.020
*** SERVICE NAME:(SYS$BACKGROUND) 2012-05-29 08:11:08.020
*** MODULE NAME:() 2012-05-29 08:11:08.020
*** ACTION NAME:() 2012-05-29 08:11:08.020


*** TRACE FILE RECREATED AFTER BEING REMOVED ***

kgskmetricupd: cg[REPLICAT_GROUP] used_quanta[7662921] greater than threshold[1020000]
kgskmetricupd: cg[CRITICAL_GROUP] used_quanta[7795713] greater than threshold[1020000]
kgskmetricupd: cg[ADHOC_GROUP] used_quanta[152489880] greater than threshold[1020000]

*** 2012-05-29 08:12:08.628
kgskmetricupd: cg[REPLICAT_GROUP] used_quanta[7662928] greater than threshold[1020000]
kgskmetricupd: cg[CRITICAL_GROUP] used_quanta[7795872] greater than threshold[1020000]
kgskmetricupd: cg[ADHOC_GROUP] used_quanta[152648385] greater than threshold[1020000]

*** 2012-05-29 08:13:08.226
kgskmetricupd: cg[REPLICAT_GROUP] used_quanta[7662940] greater than threshold[1020000]
kgskmetricupd: cg[CRITICAL_GROUP] used_quanta[7796153] greater than threshold[1020000]
kgskmetricupd: cg[ADHOC_GROUP] used_quanta[152717817] greater than threshold[1020000]

*** 2012-05-29 08:14:08.832
kgskmetricupd: cg[REPLICAT_GROUP] used_quanta[7662946] greater than threshold[1020000]
kgskmetricupd: cg[CRITICAL_GROUP] used_quanta[7796707] greater than threshold[1020000]
kgskmetricupd: cg[ADHOC_GROUP] used_quanta[152808314] greater than threshold[1020000]

*** 2012-05-29 08:15:08.430
kgskmetricupd: cg[REPLICAT_GROUP] used_quanta[7662948] greater than threshold[1020000]
kgskmetricupd: cg[CRITICAL_GROUP] used_quanta[7797192] greater than threshold[1020000]
kgskmetricupd: cg[ADHOC_GROUP] used_quanta[154124293] greater than threshold[1020000]

*** 2012-05-29 08:16:08.019
kgskmetricupd: cg[REPLICAT_GROUP] used_quanta[7662957] greater than threshold[1020000]
kgskmetricupd: cg[CRITICAL_GROUP] used_quanta[7797948] greater than threshold[1020000]
kgskmetricupd: cg[ADHOC_GROUP] used_quanta[154296388] greater than threshold[1020000]
ten:(prod)/opt/oracle/diag/rdbms/prod/prod/trace >

Previous Topic: Privilege require to gather stats
Next Topic: How can FGA audit the statements of sysdba
Goto Forum:
  


Current Time: Fri Nov 29 02:26:55 CST 2024