Database Administration (MOSC)

MOSC Banner

question about sys_context

edited May 20, 2020 8:38AM in Database Administration (MOSC) 4 commentsAnswered ✓

I came across a question on another forum that left me scratching my head, thinking "I should know that but have never really looked at it."

Given the query

SQL> select sys_context ('USERENV','SERVICE_NAME') from dual;SYS_CONTEXT('USERENV','SERVICE_NAME')--------------------------------------------------------------------------------SYS$USERS

Exactly what is that telling me?  SYS$USERS is certainly not the service name of the database (at least not in the sense of a service name from the 'service_names' init parm.  A search of both google and MOS on 'SYS$USERS' turned up nothing useful.

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