Oracle DB Scripts Hints and Tips

Press Ctrl+D to bookmark this page.

The followings are different examples of using the Oracle DB Scripts to do various task.  You can used it as a guide to build your own Oracle Scritps.
Oracle Scripts Books
Oracle Scripts

Oracle DBA Automation Scripts

Oracle Performance Troubleshooting: With Dictionary Internals, SQL & Tuning Scripts (Oracle In-Focus series)

....more Oracle Books
Oracle Script Samples
Display database version information
Recompile invalid database objects
List all Indexes in your database
Show objects currently in use in the database
List all Constraints in your database
List all Snapshots in your database
List all Sequences in your database
List all Clusters in your database
Know about all Synonyms in your Database
Know all about Roles in a Given database
Get for how long the Database is running
Database Startup
Database Creation
Drop database objects
This is an example of Oracle Types
Set user tablespace defaults
Know all about tablespace Quota
Create script which recreates tablespaces
Know all Stats of a Table
Issue of Table Index size
List all Clusters related to a Table
Deallocate unused space from table segments
Calculate distribution statistics about a column
Performs "command" on each column
Execute a job daily at some specific time
Convert hex value to decimal in PL SQL
Send email as message from PL SQL
Zip trace file dynamically
Example to spell out number to words
Use this as settab for creating scripts
Perform variable ANALYZE TABLE operations
Create Application Developer account
Create a new Application Schema Owner account
Create application user/developer/owner roles
Create a new user account
Become another user (local database only)
Display username and database
Resets user password to a default
List users waiting for locks
Display package function arguments
Print ascii table
Display AUDIT SESSION history
Displays Oracle background processes
Display buffer cache (x$bh) usage by object
Display stats for mutliple buffer pools
Describe contents of objects in library cache
List segments which can't extend because of space or extents
Clear the screen
List clusters
Schedule a job to be executed
If you are having problems with your Oracle DB Scripts, you can seek help from the Oracle Database Forum where Oracle Peers from around the Universe group together to discuss about their problems at work.

Have a Oracle Question
Do you have an Oracle Question?

Return to : Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.