Home » RDBMS Server » Server Administration » High Undo tilization by CJQ0 (merged 5) (10.1.0.5)
High Undo tilization by CJQ0 (merged 5) [message #419303] Fri, 21 August 2009 01:29 Go to next message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
My UNDO utilization is very high and most of the undo is eaten by (CJQ0) process, how can I find which JOB in this queue is highly utilizing the UNDO.

Thanks

[Updated on: Fri, 21 August 2009 05:21] by Moderator

Report message to a moderator

Re: High Undo tilization by CJQ0 [message #419307 is a reply to message #419303] Fri, 21 August 2009 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA_SCHEDULER_RUNNING_JOBS
V$SCHEDULER_RUNNING_JOBS
DBA_JOBS_RUNNING

Regards
Michel
Re: High Undo tilization by CJQ0 (merged 4) [message #419314 is a reply to message #419303] Fri, 21 August 2009 02:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How many times will you repeat the same question?
Don't tell me there was a problem with your browser between the first and last topics there was 1 hour.

Regards
Michel
Re: High Undo tilization by CJQ0 (merged 4) [message #419327 is a reply to message #419303] Fri, 21 August 2009 05:04 Go to previous messageGo to next message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
Hi Micheal,

I am telling you, there was a problem with the browser.
Anyways, I have already checked the JOB details there is no other job running except the routine ones.

This type of issue has popped up first time in this database.

Pls suggest!
Re: High Undo tilization by CJQ0 (merged 5) [message #419357 is a reply to message #419303] Fri, 21 August 2009 08:35 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
How are you determining that the UNDO is being used by this process?
Re: High Undo tilization by CJQ0 (merged 5) [message #419358 is a reply to message #419303] Fri, 21 August 2009 08:39 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>My UNDO utilization is very high
You can't have high UNDO without high REDO; as they are cojoined twins.
What is size of REDO & how often do they switch?
Previous Topic: Error in Alert Log
Next Topic: ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
Goto Forum:
  


Current Time: Sun Dec 11 02:01:53 CST 2016

Total time taken to generate the page: 0.07172 seconds