Re: Oracle BG processes and SQL visibility in 10.2.0.2

From: Luso Joe <lusoman_at_hotmail.com>
Date: Sat, 30 Sep 2006 15:44:47 -0700
Message-ID: <mnsth2hbbjj7jl4jqpb6gl4va850c0tb1v@4ax.com>

On Sat, 30 Sep 2006 21:23:47 GMT, Mladen Gogala <mgogala.spam-me-not_at_verizon.net> wrote:

>On Sat, 30 Sep 2006 13:32:30 -0700, Luso Joe wrote:
>
>> If you are interested in what the job queue process is doing, just
>> turn on 10046 tracing. Assuming you are on Unix, one way to do this it
>> to get the PID for the process using ps, the use the following
>> statements in SQL*Plus.
>
>That precludes the use of any fancy session monitors like top sessions,
>tora or alike. Yes, I know that, but that isn't the answer.

Sorry, I thought from your original post you wanted to see wht SQL was being executed by the job process. Received on Sat Sep 30 2006 - 17:44:47 CDT