High db file sequential reads

From: Bellows, Bambi <bbellows_at_usg.com>
Date: Mon, 13 Jun 2005 14:19:01 -0500
Message-ID: <161657AE46CE0740BAC823B28AE90AFC1F291D@CERO-EXBE-01.USG.NET>

Hi Everybody!  

I've been administering a system lately that's used almost exclusively for Oracle Financials and one of the things that Oracle Financials does every well is hide what it's doing. Oh, sure, you can poke around in v$sql but that doesn't really do much for you. So I've been rather dependent on statspack (lovely thing) and from there I can see what's eating up time and analyze the structure and, as needed, apply indexes to the tables. There's not really much more you can do than that as you have no access to the underlying queries, and, even if you did, you sure couldn't change anything, database parameters aside, of course. That being said, these percentages seem out of whack to me... what do you think?  

Top 5 Timed Events

~~~~~~~~~~~~~~~~~~                                                     %
Total
Event                                               Waits    Time (s)

Ela Time

-------------------------------------------- ------------ -----------
--------
db file sequential read                           438,536       2,792
65.14
CPU time                                                        1,284
29.96
db file scattered read                             32,239         165
3.84
log file parallel write                            12,667          14


.32

SQL*Net break/reset to client                       1,384           9


.20

          -------------------------------------------------------------

^LWait Events for DB: PFIN Instance: PFIN Snaps: 3962 -3963 Has anyone successfully gotten db file sequential reads into any kind of sane range for any period of time?  

Thanks folks!
Bambi.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 13 2005 - 15:44:36 CDT