>
>Hi all,
>
>I wonder gathering a document template in order to
>do some db auditing. I was wondering if anyone has
>a good document or a list of issues or good links
>what to put into performance review list.
>
>Thanks in advance,
>
>Joshua
Just happen to be in this type of thing right now. I think that the problem with 'DB
auditing' is the huge gap between what people expect (usually your saying 'Well, do a
full exp/imp to reorganize and set magic_parameter to TRUE and it will fly') and what
I usually end up saying ('who wrote THAT !!! Jesus.'). Which means that for deep
political reasons, if you really want the active, bitter advice to be swallowed by the
customer, you need to sugar-coat it with things which, without being totally useless,
are slightly less important performance-wise but match the expectations better.
Which is why I think that you can do a little bit about storage, volumes, indexing
(average number of indexes per table, people love ratios). Checking whether stats are
up-to-date is definitely useful. Don't forget security. Try the usual
username/password combinations, once you have connected as dbsnmp/dbsnmp check
all_users and try dumb_idiot/dumb_idiot for everybody. Database links are interesting
too. Mention BCHR somewhere, even to sling mud at it, just to make people sure you
have heard of it. A word about SGA parameters.
Then check what really matters : queries high on buffer_gets in V$SQL and wait
statistics, and try to understand why it's that bad. And if you really want to despair
of mankind, dig into DBA_SOURCE.
And review the backup policy. THAT's important !
HTH,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
