Database Administration (MOSC)

MOSC Banner

Background process/internal oracle sessions audit file

edited Sep 12, 2022 12:32AM in Database Administration (MOSC) 5 commentsAnswered

Hi,

In audit file, can we always says that, when there is no client terminal in audit file, it means it was a background/internal oracle process that execute it?

ex:

Fri Sep 10 20:31:26 2022 -03:00
LENGTH : '330'
ACTION :[80] 'SELECT decode(STATUS,'STARTED','2','MOUNTED','3','OPEN','5','0') FROM v$instance'
DATABASE USER:[1] '/'
PRIVILEGE :[6] 'SYSDBA'
CLIENT USER:[6] 'oracle'
CLIENT TERMINAL:[0] ''
STATUS:[1] '0'
DBID:[10] '3666535644'
SESSIONID:[10] '4294967295'
USERHOST:[12] 'srv1'
CLIENT ADDRESS:[0] ''
ACTION NUMBER:[1] '3'

As we see, there is no client terminal, so can we always conclude it was a backgroup/internal oracle process and not a user ie: connecting locally with

Tagged:

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