 |
Coming Soon!
Ram Razdan | home
About Me | My Family | Favorites | Views | Resume | Technical | Photo Album | Other Links | Contact | SSVPS CoE | Notice Board
Technical
Online SQL Tuning Presentation.
work under progress. An audio guide for the presentation is also underway.
work under progress. An audio guide for the presentation is also underway.Ideas and reviews of the draft are welcome.
Useful SQL Scripts ... click to download all in one go.
1. tabs.sql
|
to find and display all names , which match a given pattern , and comments of all tables accessible to the user
|
2. objs.sql
|
extending the above concept to cover all types of objects.
|
3. syns.sql
|
to find and display all synonyms which match a given pattern and the objects referred by the synonyms. Additionally this script prompt to determine if the user would like to validate the synonyms. If yes , it them checks to see if the objects referred by the synonyms exists or not and displays the appropriate status. NOTE requesting synonym validation can take some time, so the default option is always No.
|
4. drops.sql
|
to find and drop multiple objects with names that contain a given string. This scripts prompts for a confirmation before it actually drops the object. It also saves the drop script with a unique filename to allow the user to drop the objects as per his will at a later time.
|
5. dt.sql
|
alter the defatlt date format using convenient shorthands without losing the query in the current SQL*Plus buffer.
|
6. getproc.sql
|
retrieves the code for a stored procedure (procedures/functions/packages) from the database and opens the same in a editor.
|
7. sessinfo.sql
|
to find and display useful information about various database sessions where the username match a given pattern. additionally it also shows the SQL statement being executed by any given session and may optionally be enhanced to show all the locks held by a given session.
|
displays details about all the locks acquired or requested by a given session.
|
|
9.
|
.......more coming soon.........
|
SQL Extended Describe Command - one command to describe any oracle object , be it a table , view,sequence,procedure. Includes neat options to display the query used to construct views,tables and read code of a procedure as stored in the database.