Solved

What Is Sys Doing??

Posted on 2014-09-17
2
557 Views
Last Modified: 2014-09-17
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
Comment
Question by:xoxomos
2 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
ID: 40328394
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
 

Author Comment

by:xoxomos
ID: 40328423
Yep, thanks.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question