OraFAQ Forum: Server Administration » Capture statement with job process, but I can not, need your help!

Home » RDBMS Server » Server Administration » Capture statement with job process, but I can not, need your help! (Oracle 10.2.0.1, Solaris 10)

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

Capture statement with job process, but I can not, need your help! [message #413243]

Tue, 14 July 2009 23:52

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Dear!

I have got total 4 jobs within only one schema user, 4 jobs was scheduled to run at mid-night.

I am sorry about these following images, because of many columns appears in result if I use sql*plus, so that, I must attach the images here (SQL*Navigator).

Img1: 4 jobs with 1 running

http://i95.photobucket.com/albums/l130/trantuananh24hg/job1.jpg

logvnp@VNP> select next_date, interval
  2  from dba_jobs
  3  where priv_user='CCS_ADMIN';

NEXT_DATE INTERVAL
--------- --------------------
15-JUL-09 trunc(sysdate+1)
16-JUL-09 TRUNC(SYSDATE+1)
15-JUL-09 sysdate+15/1440
15-JUL-09 sysdate+5/1440

logvnp@VNP>

logvnp@VNP>

Then, I saw the process at OS level

http://i95.photobucket.com/albums/l130/trantuananh24hg/job3.jpg

You see, PID 26216 has a sleep state, after it just ran, why? It must run at midnight, how did it appear now?

At the end, I query v$process to confirm

http://i95.photobucket.com/albums/l130/trantuananh24hg/job2.jpg

The J001 process stand at here.

May you clarify me? How would I capture this process into a dump file? Note that, I used dbms_monitor.session_trace_enable to capture, but it did not appear as a dump file (..._ora_PID.trc) in udump.

Thank you very much!

[Updated on: Wed, 15 July 2009 00:05]

Report message to a moderator

Re: Capture statement with job process, but I can not, need your help! [message #413252 is a reply to message #413243]

Wed, 15 July 2009 00:48

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

I am trying to write a trigger which will generate log if dba_jobs_running has got a value (not null).

I will hope to know a reason.

Report message to a moderator

Re: Capture statement with job process, but I can not, need your help! [message #413259 is a reply to message #413243]

Wed, 15 July 2009 00:57

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I am sorry about these following images, because of many columns appears in result if I use sql*plus, so that, I must attach the images here (SQL*Navigator).

You should better use SQL*Plus as there is no image.

Regards
Michel

Report message to a moderator

Previous Topic:	how tot install oracle 9i on windows 2003 server 64 bit os
Next Topic:	USER_OBJECTS lists BIN$* objects

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 08:14:04 CDT 2024