Bad Sql From SYS

From: Whitaker, William M. <whitakwm_at_westinghouse.com>
Date: Fri, 02 Aug 2002 07:48:22 -0800
Message-ID: <F001.004A9E2D.20020802074822@fatcity.com>

Hi Everyone,

I ran a query looking for bad SQL (high disk I/O or very large number of buffer gets) and found that the userid of some of the SQL is SYS. A sample of the SQL is :

SELECT OWNER, TNAME, ROWNER, RTNAME,
CNAME, CNO, RCNO, ACTION, ENABLED, DEFER, OBJID, PROPERTY , REFTYPE
FROM SYS.EXU8REF
WHERE OWNERID=:1 This SQL was executed does no I/O, but does 378,765 buffers gets per execution and was executed 572 times in one day on our system (8.1.6). Any ideas on what is causing this? Is it a problem? There are other SQL executions that have what I think are unusually high buffer gets also.

Thanks,

Bill Whitaker
Westinghouse
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Whitaker, William M.
  INET: whitakwm_at_westinghouse.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Aug 02 2002 - 10:48:22 CDT