Re: schema health check

Imran Rahim wrote:

> 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.

Reread the sentence before you post:

Here it is again in case you missed it:

You might want to search the archives for some lengthy threads on "Oracle Myths"

Why would you think we would want to rehash this yet again?

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)