Database Administration (MOSC)

MOSC Banner

SYS statement is coming in all DBs

edited Jun 16, 2012 7:38PM in Database Administration (MOSC) 2 comments
Hi

  We are continuously monitoring the following statment is coming in all databases from SYS user

select /*+ rule */ distinct w.inst_id,w.sid,s.username,substr(w.
event,:"SYS_B_00",:"SYS_B_01") event,substr(s.machine,:"SYS_B_02
",:"SYS_B_03") machine,substr(w.state,:"SYS_B_04",:"SYS_B_05") s
tate,s.SQL_ID,--q.CHILD_NUMBER CHILD, substr(q.sql_text,:"SYS_B_
06",:"SYS_B_07") "SQL",round(s.LAST_CALL_ET/:"SYS_B_08") "MINS",
s.sql_id from gv$session_wait w,gv$session s,gv$sql q where w.ev
ent like :"SYS_B_09" and w.sid=s.sid and s.SQL_HASH_VALUE=q.HASH

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