"Imran Rahim" <i_rahim_at_hotmail.com> wrote in message
news:e7519cfe.0308210013.2eb61163_at_posting.google.com...
> "DJ" <nospamplease_at_goaway.com> wrote in message
news:<NrO0b.176$L15.69_at_newsfep4-winn.server.ntli.net>...
> > "Imran Rahim" <i_rahim_at_hotmail.com> wrote in message
> > news:e7519cfe.0308200710.315afa98_at_posting.google.com...
> > > Hi,
> > > I'm writing a small script that can be run against all my schemas to
> > > give me some sort of idea as to the "health" of each schema
> > >
> > > So far I've come up with
> >
> > > Indexes in Data Tblspce?
> > > Tables in Index Tblspce?
> >
> > Why you checking these?
>
> I am checking these because we seperate the disks for indexes and data
> to minimise contention
Then rather than guessing whether you have contention based on object type,
why not check IO activity against files or waits on io related events?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Thu Aug 21 2003 - 10:36:11 CDT
