Re: sqlplus db survey

Go to www.stewartmc.com/oracle/orasnap/ and download orasnap.

It's free, it produces nice looking HTML output which is very readable,

and
it makes over 100 checks of an Oracle database instance.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 8/30/00, 1:59:01 PM, tony barratt_at_my-deja.com wrote regarding sqlplus  

db survey:

> Hi List,
> Got another question for you Oracle guru types.
> I'n trying to do some comprehensive fault management stuff, for unix
> and VMS boxen and I notice that it's a good idea when monitoring thing
 s
> to have to hand a survey of each machine, like number of physical
> disks, amount of RAM, processors, OS version. Lots of info, so that
> when a fault is detected, you can make a quick informed plan to fix it
 .
> Likewise I think that I've got some good run-time health stuff from th
 e
> Internet and elsewhere, too-much-chaining room-to-grow eksetawah.
> But I don't have a db survey, like, ah well i dunno really, I'm just
> learnin about this Oracle stuff.
> Size of db, number and name of tables indexes, time of last analysis,
> measure of complexity etc..
> If any of you good people can provide an URL for some useful stuff, as
 

> outlined above or explain why I'm barking at the wrong end of the stic
 k
> I'd be most pleased.
 

> TIA
 
> Tony

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Aug 30 2000 - 22:58:20 CDT