Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production
PL/SQL Release 188.8.131.52.0 - Production
"CORE 184.108.40.206.0 Production"
TNS for IBM/AIX RISC System/6000: Version 220.127.116.11.0 - Production
NLSRTL Version 18.104.22.168.0 - Production
select * from dba_outstanding_alerts;
Metrics "Database Time Spent Waiting (%)" is at 100 for event class "Concurrency"
Metrics "Database Time Spent Waiting (%)" is at 100 for event class "Other"
Session 551 is blocking 2 other sessions
Session 501 is blocking 2 other sessions
Session 501 is from program M001 so seems to be MMON
MMON => Managebility Monitor is the enabling process for many of the self-monitoring and self-tuning capabilities,
MMON captures statistics which are used by ADDM.
Having select * from dba_advisor_tasks it seems i am missing snapshots for the last 3 days.
My assumption is that this situation is a deadlock of MMON,
i resolved the issue by startup force, but when we have moved to production I don't want to be doing startup force.
How would I resolve this issue since I am not able to kill system sessions, and without resolving this deadlock some processes can't be run,
but I don't want to do startup force.....