Re: Oracle BG processes and SQL visibility in 10.2.0.2

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.

-- 
http://www.mladen-gogala.com