Oracle housekeeping scripts

The idea of this tip is to collect some useful SQL scripts in order to give the DBA a way to view to the status of all his databases. Some of those checks are:

• Security
• Memory efficiency
• Fragmentation
• RBS efficiency
• and more...

These housekeeping scripts provide a daily report on the status of my production databases. The reports are sent via e-mail to the DBA. There are two sections:

1. The Unix c-sh script: The container for the SQL scripts. You can run the scripts on all databases or on a selected subset of databases. You can run them every day or only periodically. These decisions can be coded into the c-sh skeleton.
2. A series of SQL scripts: You can have as many scipts as you want. If you decide to run all the scripts at once on all databases, you can collect all your code in one script. If you want to add some rules in your c-sh script, then you should divide the SQL code into different files. I will show you later some useful scripts, but you can collect your own.

The c-sh container:

The SQL scripts

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle database administrator Understanding SQL string functions What is the difference between a database engineer, architect and administrator? Import on one table from dump file Error during RMAN backup Can I drop a column in SYS schema? STATSPACK tool: transaction vs. execution measurement Should I port from Microsoft Access? How can I find statistics on total memory usage and database connections? Installing multiple Oracle homes Modifying SYS password in a RAC environment

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

For More Information

• Feedback: E-mail the editor with your thoughts about this tip.
• More tips: Hundreds of free Oracle tips and scripts.
• Tip contest: Have an Oracle tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize -- submit your tip today!
• Ask the Experts: Our applications, SQL, database administration, and data warehousing gurus are waiting to answer your toughest questions.
• Forums: Ask your technical Oracle questions--or help out your peers by answering them--in our active forums.
• Best Web Links: Oracle tips, tutorials, and scripts from around the Web.