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: schema health check

Re: schema health check

From: Imran Rahim <i_rahim_at_hotmail.com>
Date: 21 Aug 2003 01:13:54 -0700
Message-ID: <e7519cfe.0308210013.2eb61163@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 Received on Thu Aug 21 2003 - 03:13:54 CDT

Original text of this message

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