Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: schema health check
"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 Received on Thu Aug 21 2003 - 03:13:54 CDT