Re: best DBA script collection

From: Rajesh Aialavajjala <r.aialavajjala_at_gmail.com>
Date: Wed, 11 Dec 2013 12:12:20 -0500
Message-ID: <CAGvtKv4HEtmms68pNjeUira2coPix1LRyPKjbVqxdq7em+SikA_at_mail.gmail.com>

I would add Kerry Osborne's scripts...he has some excellent ones (for example flush.sql) -- I know that there's a zip archive ~3 years old...that cane be found at
http://kerryosborne.oracle-guy.com/papers/my_favorite_scripts_2010.zip

Also - several more are available on his blog...included in posts...

--Rajesh

On Wed, Dec 11, 2013 at 12:00 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:

> many people - though probably not Jeremy - are suprisingly unaware of
> $ORACLE_HOME/rdbms/admin/awr* and associated addm scripts..
>
>
> On Wed, Dec 11, 2013 at 4:20 PM, Jeremy Schneider <
> jeremy.schneider_at_ardentperf.com> wrote:
>
>> I'm curious what's everybody's opinion on the best collection of scripts.
>> I know that lots of DBAs have their own personal/private collection but
>> I'm talking about collections that have been posted publicly.
>>
>> Two that come to mind right away are Tim Halls (oracle-base) and Tanel
>> Poder's (tpt/tanel-poder-troubleshooting seminars). Personally I prefer
>> Tanel's for two reasons:
>> 1) shorter names, this is totally subjective but i prefer short names for
>> quick typing instead of explanatory names
>> 2) slightly more sophisticated login/init scripts, fewer "set linesize"
>> commands in individual scripts (i've modified tanel's login to detect
>> terminal width and set linesize accordingly)
>>
>> What other good script collections are out there in the public that you
>> like? I'm probably missing a bunch of obvious ones.
>>
>> -Jeremy
>>
>> --
>> http://about.me/jeremy_schneider
>>
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 11 2013 - 18:12:20 CET