DBAToolZ

Lightweight Oracle DBA Tools

 

SQLDIR

SQLDIR — One stop sqlplus script management utility for Oracle:

  • Sql scripts reside on OS file system (UNIX, WINDOWS)
  • They are organized into categories using special tags embedded into each script (very simple like html)
  • SQLDIR parser scans them into searchable repository
  • Access scripts right from sqlplus using user friendly menu (character based for hardcore telnet users)
  • True tool for hardcore Oracle DBA that relies on sqlplus rather then GUI tools because sqlplus is always there
  • Parser is written in C making it very fast
  • Organize just about any sqlplus script (adhoc reporting …)
  • New scripts are easily added to repository and automatically parsed for description tag and category tag (set up a cron job and all new scripts will be at the tip of your finger momentarily)
  • Repository is saved as sqlplus script which makes it portable take it anywhere and have it up and running in seconds perfect for all you road warriors out there … I should know – I was in consulting for years.

Download SQLDIR (C SOURCE Code is included)

Vitaliy Mogilevskiy - Solving ORACLE problems since 1996.

View Vitaliy Mogilevskiy's profile on LinkedIn

What you will find here is what works for me day in day out - 24x7x365 - simple ORACLE DBA Tools written using components that are available on every Unix platform with an ORACLE database -- sqlplus and KSH.

Do you have DBA questions? Head over to Ask DBA.

RSS DBA Forums


Recent Comments

  • Paul: I’m getting an error: Connect failed because target host or object does not exists. How to solve it?
  • Mack: Years after posting this, people, me included, are still praising it. Clear and gets the job done. Pity Oracle...
  • huakun: thanks,非常感谢
  • yuga: mine is windows7 64 bit
  • yuga: in my system oracle odbc dirver not showing ,i have installed oracle 10g and jdk 7 but not showing dirver plz...

Categories

Blogroll


Archives