skip to content
Oracle DBA automation scripts Preview this item
ClosePreview this item

Oracle DBA automation scripts

Author: Rajendra Gutta
Publisher: Indianapolis, IN : Sams, 2002.
Edition/Format:   Print book : EnglishView all editions and formats

This volume provides and explains powerful scripts that automate common database administration tasks, empowering the DBA to spend more time focusing on the critical aspects of their job.


(not yet rated) 0 with reviews - Be the first.

More like this

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...


Document Type: Book
All Authors / Contributors: Rajendra Gutta
ISBN: 0672322684 9780672322686
OCLC Number: 49824965
Notes: Includes index.
Description: xiv, 394 pages : illustrations ; 23 cm + 1 CD-ROM (4 3/4 in.)
Contents: Introduction. 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.Index.
Responsibility: Rajendra Gutta.


User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...


Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data

Primary Entity

<> # Oracle DBA automation scripts
    a schema:CreativeWork, schema:Book ;
   library:oclcnum "49824965" ;
   library:placeOfPublication <> ; # Indianapolis, IN
   library:placeOfPublication <> ;
   schema:about <> ; # Oracle (Computer file)
   schema:about <> ;
   schema:about <> ;
   schema:about <> ; # Relational databases
   schema:about <> ; # Oracle (Computer file)
   schema:about <> ; # Database management
   schema:bookFormat bgn:PrintBook ;
   schema:creator <> ; # Rajendra Gutta
   schema:datePublished "2002" ;
   schema:exampleOfWork <> ;
   schema:inLanguage "en" ;
   schema:name "Oracle DBA automation scripts"@en ;
   schema:productID "49824965" ;
   schema:publication <> ;
   schema:publisher <> ; # Sams
   schema:workExample <> ;
   wdrs:describedby <> ;

Related Entities

<> # Oracle (Computer file)
    a schema:CreativeWork ;
   schema:name "Oracle (Computer file)" ;

<> # Indianapolis, IN
    a schema:Place ;
   schema:name "Indianapolis, IN" ;

<> # Relational databases
    a schema:Intangible ;
   schema:name "Relational databases"@en ;

<> # Oracle (Computer file)
    a schema:CreativeWork ;
   schema:name "Oracle (Computer file)" ;

<> # Database management
    a schema:Intangible ;
   schema:name "Database management"@en ;

<> # Rajendra Gutta
    a schema:Person ;
   schema:familyName "Gutta" ;
   schema:givenName "Rajendra" ;
   schema:name "Rajendra Gutta" ;

    a schema:ProductModel ;
   schema:isbn "0672322684" ;
   schema:isbn "9780672322686" ;

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.