Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: schema health check
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
![]() |
![]() |