Database - RAC/Scalability (MOSC)

MOSC Banner

Uniquness of AUDSID in RAC

edited Feb 10, 2010 3:20AM in Database - RAC/Scalability (MOSC) 9 commentsAnswered
 Hi, I want to use AUDSID to uniquely identify regular user sessions in RAC environment. I understand that AUDSID is not always unique in that
1) AUDSID is the same for all login sessions for sys
2) the parallel query slaves for a query coordinator uses the same AUDSID.
3) Threads of an RMAN backup have the same v$session.audsid.
4) Background processes, internet connections, and submitted job all have AUDSID being 0.

I am not dealing with any of the above. My app is a windows based one using OCI client that one issue DMLs to user tables and views.
My questions are

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center