schema health check

From: Imran Rahim <i_rahim_at_hotmail.com>
Date: 20 Aug 2003 08:10:39 -0700
Message-ID: <e7519cfe.0308200710.315afa98@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

Size (in Mb)                                                        
Last Analyzed                                                       

Chained Tables >4%
Indexes in Data Tblspce?
Tables in Index Tblspce?
Segments with over 70% of maxextents used Invalid objects in schema?

Can anyone think of anything else? Received on Wed Aug 20 2003 - 10:10:39 CDT