Capture statement with job process, but I can not, need your help! [message #413243] |
Tue, 14 July 2009 23:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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](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](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](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
|
|
|
|
|