Re: best DBA script collection
- From: Rajesh Aialavajjala <r.aialavajjala@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Wed, 11 Dec 2013 12:12:20 -0500
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@xxxxxxxxx> 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@xxxxxxxxxxxxxx> 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
>
Other related posts:
