They are the best collection, I also refer Jeffrey Hunter from idevelopment scripts for general queries which are useful on regular basis. http://www.idevelopment.info/cgi/ORACLE_dba_scripts.cgi -NB On Wed, Dec 11, 2013 at 9:52 PM, David Ramírez Reyes <dramirezr@xxxxxxxxx>wrote: > Interesting, I haven't even heard about any of them, where can I get them? > > Regards > > David Ramírez Reyes > > > > > On 11 December 2013 10:20, 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 >> > > -- Thanks & Regards, Nassyam Basha. www.oracle-ckpt.com