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

Home -> Community -> Usenet -> c.d.o.server -> Re: System Tables with the Highest IO

Re: System Tables with the Highest IO

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 07 May 2003 22:12:07 +0800
Message-ID: <3EB91437.26FF@yahoo.com>


michael ngong wrote:
>
> Checking the tables with the highest IO and it turned out the system
> tablespace had the highest io.On a drill down the culprits were
> ind$,obj$ user$ system tables .
> I am looking into a way to address this so far no concrete steps
> arrived at.
> Ideas,clues tips will be appreciated
>
> Michael Tubuo Ngong

Parsing can lead to high usage of the dictionary, and whilst this is certainly not a good thing, it typically shouldn't lead to a lot of disk I/O (because of the dictionary cache).

Check your parse counts and your shared pool size.

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"
Received on Wed May 07 2003 - 09:12:07 CDT

Original text of this message

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