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: Ed Stevens <nospam_at_noway.nohow>
Date: Wed, 27 Aug 2003 08:23:17 -0500
Message-ID: <h3cpkvgaoffdge44miqnilpepmi18naq3o@4ax.com>


On 27 Aug 2003 02:55:37 -0700, i_rahim_at_hotmail.com (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.

It's all explained in exhaustive detail in the referenced thread. Go to groups.google.com and read it. Received on Wed Aug 27 2003 - 08:23:17 CDT

Original text of this message

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