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

From: Marco Muracchioli <reply.on_at_group.please>
Date: Wed, 17 Jul 2002 16:43:12 GMT
Message-ID: <A8hZ8.77388$Jj7.1999540@news1.tin.it>

Hi Sybrand,

we found this situation while logging with a trigger all the insert done in a table.
The trigger get almost all informations about v$session, and the result is something like this:

+------------+----------+--------------+ | SCHEMANAME | USER | PROGRAM NAME | +------------+----------+--------------+

| TRYSCHEMA  | APPUSR   | SQL Plus ... |
| (null)     | APPUSR   | SQL Plus ... |
| (null)     | APPUSR   | SQL Plus ... |
| (null)     | APPUSR   | SQL Plus ... |

+------------+----------+--------------+

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?

Thanks,
Marco Muracchioli

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> ha scritto nel messaggio news:ujaisbkfbfqvd7_at_corp.supernews.com...
>
> "Ugo" <ribecai_at_dsdata.it> wrote in message
> news:290411d1.0207170155.4fc0dbae_at_posting.google.com...
> > Why and When the "SCHEMANAME" col in V$SESSION can be NULL ???
> > Thanks in advance
> >
> > Ugo Ribecai
>
>
> Likely background processes like DBWR and others.
> TYPE='USER' is your friend.
>
> Regards
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>
Received on Wed Jul 17 2002 - 11:43:12 CDT