Re: schema health check

From: Ed Stevens <nospam_at_noway.nohow>
Date: Thu, 21 Aug 2003 08:25:19 -0500
Message-ID: <msh9kvkfqsm9h72hp8t352295isvs6v66i@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" Received on Thu Aug 21 2003 - 08:25:19 CDT