| 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
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
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
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
