Re: V$SESSION, SCHEMANAME is NULL !!!

On Wed, 17 Jul 2002 16:43:12 GMT, "Marco Muracchioli" <reply.on_at_group.please> wrote:

>At the first moment, we think that those "null schemaname" session depends by
>parallel inserts, but looking at the v$session while a parallel insert is in
>progress, we can se that in "program name" fields appears "oracle80.exe", and
>not SQL Plus as it was a normal single process session.
>
>We can't understand it.
>Can you give us some advice?

it could be this are the parallel query slaves that are started automatically for parallel operations.
Other suggestions are the job queue processors (the process name will look like %snp%' here), or the advanced queue processors I would try to join v$session and v$process (join columns are s.paddr = p.address), v$process also has a programname, and it will show the O/S process id/thread id in the spid column.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jul 17 2002 - 12:08:35 CDT