Re: What characterizes sessionid=0?

AUDSID = 0 is for DBMS_JOBS that are run in the background. May be there are some other events doing the same that I am not aware of.

amar
www.amar-padhi.com

On 08/04/2009 12:11 AM, Christoph wrote:
> We have a need to characterize work performed in an Oracle database
> (specifically, E-Business Suite installations)
> for sessions that use SESSIONID = 0, where that session ID is acquired
> by the following:
>
> SELECT SYS_CONTEXT ('USERENV', 'SESSIONID') FROM DUAL;
>
> To further explain: this SESSIONID value is joined to V$SESSION.AUDSID
> for the retrieval of information related
> to the current session such as MODULE, ACTION, CLIENT_INFO, and the like.
>
> We acquire this information during the execution of a Database-level
> BEFORE LOGOFF trigger and we use details
> related to the sessions logging off to characterize the work that was
> performed during each session.
>
> We seem to have noted Oracle uses this AUDSID = 0 for internal
> (maintenance?) activity, but we're not sure.
>
> Is anyone aware of documentation that classifies which user(s) use
> SESSIONID = 0 and for what purposes?
>
> Thanks,
> Christoph

--
http://www.freelists.org/webpage/oracle-l