RE: db file sequential reads

From: Mohan, Ross <Ross.Mohan_at_PictureVision.com>
Date: Thu, 12 Oct 2000 11:46:12 -0400
Message-Id: <10647.119082@fatcity.com>

It is actually good, other things being equal.

You might look at your disk behavior, see if it is lopsided. Get your SA involved, find out disk service queue lengths, service and access times, etc.

hth

Ross

-----Original Message-----
From: Rodney Womack [mailto:rcwomack_at_uswest.net] Sent: Thursday, October 12, 2000 9:21 AM To: Multiple recipients of list ORACLE-L Subject: db file sequential reads

I am getting a lot of waits on my db file sequential reads and I kinda understand that is
indicative of reading the indexes of the tables, but my question is, is it an indication that
there are too many or ineffective indexing going on in the tables? Or can I increase my
buffer cache to offset the wait state from the db file sequential reads?

Thanks

Rodney

--

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

Author: Rodney Womack
  INET: rcwomack_at_uswest.net

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 Thu Oct 12 2000 - 10:46:12 CDT