Home » RDBMS Server » Enterprise Manager » Queries consuming High CPU in OEM (10.2.0.4.0 ,windows)
Queries consuming High CPU in OEM [message #422842] Sun, 20 September 2009 09:04 Go to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Hi ,

I have a question on CPU utilization.

If database is hang due to high CPU utilization ,how to find
which queries are consuming more resources in terms of CPU
in Oracle Enterprise Manager?

Thanks in advance.


Regards,
Re: Queries consuming High CPU in OEM [message #422854 is a reply to message #422842] Sun, 20 September 2009 19:19 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check Identifying High-Load SQL Statements.
Re: Queries consuming High CPU in OEM [message #422870 is a reply to message #422854] Mon, 21 September 2009 00:03 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Ebrian

Thanks for providing this link.This is the one i was expecting .Since i am new to OEM
im doing some research with the link you provided and if i need anything on this please help me.


Regards

[Updated on: Mon, 21 September 2009 00:13]

Report message to a moderator

Re: Queries consuming High CPU in OEM [message #422874 is a reply to message #422870] Mon, 21 September 2009 00:15 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member


Similarly, can you tell me how to monitor daily and weekend database backups
that is scheduled in OEM ?


Thanks and Regards,
Re: Queries consuming High CPU in OEM [message #422926 is a reply to message #422874] Mon, 21 September 2009 04:38 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check Performing Backup and Recovery.
Re: Queries consuming High CPU in OEM [message #422936 is a reply to message #422926] Mon, 21 September 2009 05:17 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Thanks for the link.It was useful.I followed the document for managing database backup.

Steps i followed:

In the database home page i clicked maintenance tab.inside that page ,
there was a section called manage current backups. when i clicked it ,
im unable to open that page as it is taking more time.

Can you tell why it is taking that much time?? Any idea..


Regards,
Re: Queries consuming High CPU in OEM [message #422939 is a reply to message #422936] Mon, 21 September 2009 05:46 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may want to check the OEM logs in %ORACLE_HOME%\<hostname_sid>\sysman\log and see if they indicate any problems.

[Updated on: Mon, 21 September 2009 05:46]

Report message to a moderator

Re: Queries consuming High CPU in OEM [message #422940 is a reply to message #422936] Mon, 21 September 2009 05:49 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Im able to open the MANAGE CURRENT BACKUP section now.I think there could be a problem with a server .

Thanks..
Re: Queries consuming High CPU in OEM [message #422945 is a reply to message #422940] Mon, 21 September 2009 06:19 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

In MANAGE CURRENT BACKUP page, it lists all the backup details
like completion of the backup,contents ,device type ,status etc.
But im looking for a page where i would like to view the schedule backup like..
at what time backup starts and ends daily/monthly, how long the backup will takes.etc.....


Regards,
Re: Queries consuming High CPU in OEM [message #422946 is a reply to message #422945] Mon, 21 September 2009 06:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Look under Maintenance then Jobs.
Re: Queries consuming High CPU in OEM [message #422947 is a reply to message #422946] Mon, 21 September 2009 06:44 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Thanks ebrian..


How to view archivelog mode of my database and path of archivelog files in OEM ?


Regards,
Re: Queries consuming High CPU in OEM [message #422953 is a reply to message #422947] Mon, 21 September 2009 07:28 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You could check "Archive Logs" and "All Initialization Parameters" under Administration section.
Re: Queries consuming High CPU in OEM [message #422955 is a reply to message #422953] Mon, 21 September 2009 07:50 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Thanks Ebrian,

Under archive logs section i dont see any archive log files generated so far.

In Intialization parameter , i could see only archive log path
and i dont see Archive log mode parameter.

Could you tell what could be the reason for this.


Regards,
Re: Queries consuming High CPU in OEM [message #422959 is a reply to message #422955] Mon, 21 September 2009 08:28 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you perform "alter system archive log current;" in SQL*Plus, do you see an archivelog listed in the Archive Log section ?
Re: Queries consuming High CPU in OEM [message #422963 is a reply to message #422959] Mon, 21 September 2009 08:53 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Yes ebrian. i could see an archive log listed in archive log section
when i perform "alter system archive log current".

But how to find archive log mode of my database? as i dont
find it in INITIALIZATION PARAMETERS and archive log section.


Thanks and Regards
Re: Queries consuming High CPU in OEM [message #422967 is a reply to message #422963] Mon, 21 September 2009 09:17 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I don't know of a specific OEM page that will show whether it is ARCHIVELOG or NOARCHIVELOG.
Re: Queries consuming High CPU in OEM [message #422970 is a reply to message #422967] Mon, 21 September 2009 09:28 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

No problem ebrian.I feel good that you atleast response
to all of my questions and today i learnt something in OEM. (Something is better than nothing)

Thanks a lot...


I want to create an email alert in my OEM.
That should give my DATABASE STATUS every 1 hour to my email.

Could you please tell how to configure it in OEM??


Regards,


Re: Queries consuming High CPU in OEM [message #422972 is a reply to message #422970] Mon, 21 September 2009 09:35 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check Configuring Notifications.
Re: Queries consuming High CPU in OEM [message #422977 is a reply to message #422972] Mon, 21 September 2009 10:10 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member


Thanks for the link .Let me go through the document.Will come back if i need your help.


Thanks a lot Ebrian....

Re: Queries consuming High CPU in OEM [message #423180 is a reply to message #422977] Tue, 22 September 2009 07:41 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


@Mohan10g

Thanks for your feedback.

One more advice; Please start new thread for asking new question. I could see different question in single thread.

Thanks
Previous Topic: How to install Enterprise manager
Next Topic: how to send tablespace alert to mail in oracle 10g
Goto Forum:
  


Current Time: Fri Mar 29 10:25:43 CDT 2024