tracing a shell script that calls dbms_utility.compile_schema
From: hrishy <hrishys_at_yahoo.co.uk>
Date: Wed, 17 Mar 2010 07:49:29 +0000 (GMT)
Message-ID: <97149.95136.qm_at_web29004.mail.ird.yahoo.com>
Hi
I have a shell script that i ran around noon yesterday which calls a sql script which contains a line dbms_utility.compile_schema .
The pid of the shell script is something like 1429756
But when i do this
ps -ef|grep 1429756
i get
However for the spid 2597014 i dont see any activity in v$session.
How do i go about tracing this session inside oracle database ?
Date: Wed, 17 Mar 2010 07:49:29 +0000 (GMT)
Message-ID: <97149.95136.qm_at_web29004.mail.ird.yahoo.com>
Hi
I have a shell script that i ran around noon yesterday which calls a sql script which contains a line dbms_utility.compile_schema .
The pid of the shell script is something like 1429756
But when i do this
ps -ef|grep 1429756
i get
oracle 1429756 1 0 Mar 16 - 0:00 sh -- ./script.ksh oracle 2597014 1429756 0 Mar 16 - 0:00 sqlplus oracle 3002442 2297992 0 02:46:02 pts/6 0:00 grep 1429756
However for the spid 2597014 i dont see any activity in v$session.
How do i go about tracing this session inside oracle database ?
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 17 2010 - 02:49:29 CDT