OraFAQ Forum: Server Administration » High Undo tilization by CJQ0 (merged 5)

Home » RDBMS Server » Server Administration » High Undo tilization by CJQ0 (merged 5) (10.1.0.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

High Undo tilization by CJQ0 (merged 5) [message #419303]

Fri, 21 August 2009 01:29

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

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

DBA_SCHEDULER_RUNNING_JOBS
V$SCHEDULER_RUNNING_JOBS
DBA_JOBS_RUNNING

Regards
Michel

Report message to a moderator

Re: High Undo tilization by CJQ0 (merged 4) [message #419314 is a reply to message #419303]

Fri, 21 August 2009 02:44

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: High Undo tilization by CJQ0 (merged 4) [message #419327 is a reply to message #419303]

Fri, 21 August 2009 05:04

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!

Report message to a moderator

Re: High Undo tilization by CJQ0 (merged 5) [message #419357 is a reply to message #419303]

Fri, 21 August 2009 08:35

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?

Report message to a moderator

Re: High Undo tilization by CJQ0 (merged 5) [message #419358 is a reply to message #419303]

Fri, 21 August 2009 08:39

BlackSwan
Messages: 26766
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?

Report message to a moderator

Previous Topic:	Error in Alert Log
Next Topic:	ORA-01652: unable to extend temp segment by 64 in tablespace TEMP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 09 21:14:22 CST 2024