OraFAQ Forum: Server Administration » job is killed ,but job'stotal

Home » RDBMS Server » Server Administration » job is killed ,but job'stotal_time is growing up (oracle9.2.0)

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

job is killed ,but job'stotal_time is growing up [message #503373]

Fri, 15 April 2011 01:27

jackyclein
Messages: 2
Registered: April 2011
Location: China

Junior Member

dear, I have created a job .The job was running so long time.
I kill the session and os pid which the job created.
I am sure the job was stopped.But the total_time of job is growing up! I don't konw what's the reason.It's urgent.I will be crazy ~~~~~~~~

Report message to a moderator

Re: job is killed ,but job'stotal_time is growing up [message #503388 is a reply to message #503373]

Fri, 15 April 2011 03:51

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

Senior Member
Account Moderator

First avoid words like "urgent", nothing is urgent for us who helps for free.
Then post evidences of your claims that is post what you did and got, you can't see what you see if you don't show us and your interpretation of what you see may be wrong as you don't understand what happens.

Before posting, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Re: job is killed ,but job'stotal_time is growing up [message #503401 is a reply to message #503388]

Fri, 15 April 2011 05:31

ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore

Senior Member

Use dbms_job.remove to remove the job.

Report message to a moderator

Re: job is killed ,but job'stotal_time is growing up [message #503403 is a reply to message #503401]

Fri, 15 April 2011 05:37

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

Senior Member
Account Moderator

dbms_job.remove does not remove a current running job.
Or more exactly, does not remove the current execution of the job.

Regards
Michel

[Updated on: Fri, 15 April 2011 05:38]

Report message to a moderator

Re: job is killed ,but job'stotal_time is growing up [message #503514 is a reply to message #503401]

Sun, 17 April 2011 01:31

jackyclein
Messages: 2
Registered: April 2011
Location: China

Junior Member

Thanks for your message.DBA has join it.
I will record the result and root cause.

[Updated on: Sun, 17 April 2011 01:42]

Report message to a moderator

Previous Topic:	Simulate session blocking problems
Next Topic:	database server session history

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 06:54:49 CST 2024