Home > Store

Oracle DBA Automation Scripts

Register your product to gain access to bonus material or receive a coupon.

Oracle DBA Automation Scripts


  • This product currently is not for sale.
Not for Sale


  • Copyright 2001
  • Dimensions: 7-3/8" x 9-1/8"
  • Pages: 408
  • Edition: 1st
  • Book
  • ISBN-10: 0-672-32268-4
  • ISBN-13: 978-0-672-32268-6

Oracle DBA Automation Scripts shows you how to build the scripts that automate the daily operations of Oracle database management. These scripts will work in a variety of environments, including the Windows NT, Sun Solaris 2.x, Sun OS 5.x, HP-UX 11.x, and AIX 4.x operating systems. You'll learn the command differences between these operating systems and how to write scripts to integrate SQL with your OS. Whether you're an aspiring DBA or you have a few years under your belt, you'll be able to use the commands and scripts presented here to install, operate, manage, and tune Oracle databases.


CD Contents

The scripts developed for the book in one convenient downloadable Zip file -- Examples.zip (48 KB)

Sample Content

Online Sample Chapters

Backup and Recovery Scripts

Oracle DBA: Backup and Recovery Scripts

Table of Contents


1. Oracle Software Installation.

General Installation Steps. Oracle Installation on Unix Systems: Example. Getting to Know Your Database. Managing Multiple Oracle Instances in Unix. Semaphores and Shared Memory Segments. Oracle Installation on Windows NT: Example. Post Installation Steps. Getting to Know Your Database. Managing Multiple Instances in Windows NT.

2. Building Blocks.

Writing Scripts in Unix. Writing Scripts in Windows Batch Programming.

3. Backup and Recovery Scripts.

Backup and Recovery under Unix. Hot Backup. Backup and Recovery under Windows NT. Recovery Principles. Backup and Recovery Tools. Sample Files.

4. Space Management Scripts.

Space Reporting Scripts for Unix and Windows NT. Datafile Space Utilization Report. Tablespace Space Utilization Report. Tablespace Freespace Fragmentation Report. Table Segment Space Usage Report. Index Segment Space Usage Report. Rollback and Temp Segment Usage Report. All Object Space Usage Report. Space Management Automation Scripts for Unix. Space Management Automation Scripts for Windows NT.

5. Database Performance Monitoring Scripts.

Database Tuning. Application Tuning. System Tuning.

6. Locking Scripts.

Regular Locks. Deadlock. Types of Locks. Common Locking Problems. Lock Resolution Process.

7. Net8.

Net8 Configuration. Net8 Configuration for Multiple Instances. Configuring Oracle Forms to Connect to Database. Reserving Port for Listener Services. Net8 Server Troubleshooting. Multithreaded Server Configuration. Load Balancing. Network Statistics. Using Net8 Assistant Configuration Tool.

8. Process Monitoring Scripts.

Background Process Checking. Listener Process Checking. Runaway and User Process Checking. Processes and CPU Usage. Process Monitoring Script. Connectivity Checking. Windows NT. Processes and CPU Usage.

9. User Management Scripts.

Default Accounts in the Database. DBA User Authentication and Connection. Creating Users. Auditing.

10. Database Maintenance and Reorganization.

Room for Maintenance. Why Reorganize? Planning Reorganization. Gathering Database Statistics Before Reorganization. Definitions of Fragmentation. Checking Row and Index Fragmentation. Changing Object Storage Parameters. Reorganizing the Whole Database. Manual Database Creation Process. Migrating the Database to a Different OS. Database Cloning. Recreating the Control File. Purging Old Log Files.

11. Database Sizing.

Sizing Tables. Sizing Indexes.

12. Automating Scripts.

Automation in Unix. Automation in Windows NT. Monitoring Messages.

13. Unix, Windows NT, and Oracle.

Administration of Oracle under Sun Solaris 2.x. Administration of Oracle under HP-UX 11.x. Administration of Oracle under AIX 4.x. Sample Output. Administration of Oracle under Windows NT.

14. Unix and Windows NT Commands for DBAs.

Unix Basic Commands. Unix Advanced Commands. Unix Startup and Shutdown Process. Windows NT Batch Programming. ipconfig.



Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership