Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 710
  • Last Modified:

What Is Sys Doing??

Can someone point me to what activity SYS is up to here?

      SELECT NVL(SUM(TIME_WAITED/1000), 0)
FROM SYS.DBA_HIST_ACTIVE_SESS_HISTORY S, SYS.WRH$_SEG_STAT_OBJ SO, SYS.WRM$_SNAPSHOT SN , SYS.OBJ$ OBJ
WHERE SN.SNAP_ID = S.SNAP_ID AND SN.DBID = S.DBID AND SN.BEGIN_INTERVAL_TIME >= (CURRENT_TIMESTAMP - NUMTODSINTERVAL(30, 'day')) AND S.CURRENT_OBJ# = SO.OBJ# AND S.WAIT_CLASS = 'User I/O' AND S.WAIT_TIME = 0 AND SO.DATAOBJ# = :B1 AND OBJ.OBJ# = SO.OBJ# AND OBJ.DATAOBJ# = SO.DATAOBJ#
0
xoxomos
Asked:
xoxomos
1 Solution
 
sdstuberCommented:
looks like it's checking which objects have had significant waits on them.
I'm assuming whatever process reads these results sorts them as well to find long wait times vs short

Probably as part of automatic tuning
0
 
xoxomosAuthor Commented:
Yep, thanks.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now