Home » RDBMS Server » Server Administration » Capture statement with job process, but I can not, need your help! (Oracle 10.2.0.1, Solaris 10)
Capture statement with job process, but I can not, need your help! [message #413243] Tue, 14 July 2009 23:52 Go to next message
trantuananh24hg
Messages: 668
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 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
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.
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 Go to previous message
Michel Cadot
Messages: 64139
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
Previous Topic: how tot install oracle 9i on windows 2003 server 64 bit os
Next Topic: USER_OBJECTS lists BIN$* objects
Goto Forum:
  


Current Time: Thu Dec 08 22:24:40 CST 2016

Total time taken to generate the page: 0.14509 seconds