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: 27 Aug 2003 02:55:37 -0700
Message-ID: <e7519cfe.0308270155.d222698@posting.google.com>


Ed Stevens <nospam_at_noway.nohow> wrote in message news:<msh9kvkfqsm9h72hp8t352295isvs6v66i_at_4ax.com>...
> On 21 Aug 2003 01:13:54 -0700, i_rahim_at_hotmail.com (Imran Rahim)
> wrote:
>
> >"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
>
> Uh oh . . . .
>
> You might want to search the archives for some lengthy threads on
> "Oracle Myths"

Why is this a myth guys? - pls explain. thanks. Received on Wed Aug 27 2003 - 04:55:37 CDT

Original text of this message

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