Re: tracing a shell script that calls dbms_utility.compile_schema
- From: Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx>
- To: hrishys@xxxxxxxxxxx, Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Mar 2010 08:24:09 +0000
Hrishy
you need to look for the pid of the Oracle shadow task that was spawned
either by the listener (if you are using TNS) or by sqlplus (if you are
using the bequeath driver).
Try "ps -ef | grep 2597014" to see if that has a child process. If so,
that's your Oracle session. If not, you need to go through v$session to work
out which session is yours (perhaps by seeing what SQL it is executing).
Regards Nigel
On 17 March 2010 07:49, hrishy <hrishys@xxxxxxxxxxx> wrote:
> 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:
