No question at this time
DBA Top 10
1 B. Vroman 14500
2 M. Cadot 14200
3 A. Kavsek 6900
4 T. Boles 6100
5 J. Schnackenberg 5800
6 M. Hidayathullah ... 3600
7 G. Lambregts 1100
7 T. P 1100
7 P. Wisse 1100
10 B. Derous 500
10 R. Wauben 500
10 H. Steijntjes 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48226
Total active users1641
Act. users last 24h5
Act. users last hour0
Registered user hits last week344
Registered user hits last month1464
Go up

MMON Process
Next thread: Help with query
Prev thread: Columns Getting Deleted from a table "XXQF_OBJECTIVE_HISTORY"

Message Score Author Date
Hi, the mmon process got suspended and I want t...... Raj thakur Apr 13, 2018, 08:36
v$bgprocess ... Michel Cadot Apr 13, 2018, 12:46
thanks Michel. but how i can found its suspended o...... Raj thakur Apr 13, 2018, 12:48
Hello Raj, not really a reply to the question, ...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Bruno Vroman Apr 13, 2018, 13:02

Follow up by mail Click here


Subject: MMON Process
Author: Raj thakur, India
Date: Apr 13, 2018, 08:36, 99 days ago
Os info: aix
Oracle info: 11g
Message: Hi,

the mmon process got suspended and I want to setup monitoring for mmon process. If it suspended then script should send email to me.

Can you please help me out which view or how I setup its monitoring.

Thanks
Raj
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: MMON Process
Author: Michel Cadot, France
Date: Apr 13, 2018, 12:46, 99 days ago
Message:
v$bgprocess

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: MMON Process
Author: Raj thakur, India
Date: Apr 13, 2018, 12:48, 99 days ago
Message: thanks Michel. but how i can found its suspended or not? with out viewing alter log.

I want to setup a cron job who monitor mmon process. Please suggest.

Thanks
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: MMON Process
Author: Bruno Vroman, Belgium
Date: Apr 13, 2018, 13:02, 99 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hello Raj,

not really a reply to the question, but maybe the following note (and the info it points to) can help:
  Doc ID 761298.1 Troubleshooting ORA-12751 "cpu time or run time policy violation" Errors

And just an idea: you might have a "watchdog" job at OS level looking at the alert logfile for messages like "Suspending MMON action..."

Best regards,

Bruno Vroman.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here