Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Performance Problems

Performance Problems

From: Ebadi, Abdul <Abdul.Ebadi_at_Level3.com>
Date: Thu, 23 Mar 2006 10:19:51 -0700
Message-ID: <1E75D5C235242D4998C2277351948FA601859C78@idc1exc0003.corp.global.level3.com>


We have a large datawarehouse database on Oracle and are encountering strange performance problems. A query such as "select count(*) from dba_data_files;" will run in a few seconds or as long as 15 minutes depending on when this is run. We've narrowed it down to where it is not even directly related to load on the DB. A few days ago, I ran this query right after we started the DB (no activity in the DB at all) and it took 6 minutes! The waits we were seeing were "db file sequential read" and "buffer busy wait" for this query. Keep in mind our DB is ~27TB with ~30,000 datafiles!

Oracle 9.2.0.4 on Solaris 10.

Any help will be appreciated.

Thanks!

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 23 2006 - 11:19:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US