tracing a shell script that calls dbms_utility.compile_schema
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 17 Mar 2010 07:49:29 +0000 (GMT)
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 ?
Other related posts:
