Unix for Oracle DBAs Pocket Reference

Spis treści ebooka

• Unix for Oracle DBAs Pocket Reference
  • SPECIAL OFFER: Upgrade this ebook with OReilly
  • A Note Regarding Supplemental Files
  • 1. Unix for Oracle DBAs Pocket Reference
    • 1.1. Introduction
      • 1.1.1. Acknowledgments
      • 1.1.2. Conventions Used in This Book
      • 1.1.3. Long Code Lines
    • 1.2. Understanding Unix
      • 1.2.1. History
      • 1.2.2. Case Sensitivity
      • 1.2.3. Safety
      • 1.2.4. Linkability
      • 1.2.5. Shells
    • 1.3. Building Unix Commands
      • 1.3.1. Decompose a Complex Unix Command
      • 1.3.2. Build a Complex Unix Command from Scratch
        • 1.3.2.1. A script to kill all Oracle processes
        • 1.3.2.2. A script to find all files containing a specific string
    • 1.4. Unix Server Environment
      • 1.4.1. Set a Standard Unix Prompt
      • 1.4.2. Create Useful Unix Aliases for Oracle
      • 1.4.3. Place a SQL*Plus Script in a Unix Shell Wrapper
      • 1.4.4. Submit a Task to Run in the Background
      • 1.4.5. Watch the Execution of a Background Process
      • 1.4.6. Ensure That Proper Parameters Are Passed to an Oracle Shell Script
      • 1.4.7. Ensure That Only the Oracle User Can Run a Script
      • 1.4.8. Validate an Oracle SID Passed to a Unix Script
      • 1.4.9. Loop Between Unix Servers
      • 1.4.10. Execute a SQL*Plus Script on All Databases
      • 1.4.11. Send Unix Files via Internet Mail
      • 1.4.12. Change a String in All Files in a Directory
    • 1.5. Process Management
      • 1.5.1. Display Unix Processes
      • 1.5.2. Display Top CPU Consumers
      • 1.5.3. Show Number of Active Oracle Dedicated Connection Users
      • 1.5.4. Kill Processes
      • 1.5.5. Pin the Oracle SGA in Memory
    • 1.6. Server Values
      • 1.6.1. Display Server Device Values in HP-UX
      • 1.6.2. Display Server Device Values in AIX
      • 1.6.3. Display System Kernel Parameters in HP-UX
      • 1.6.4. Display System Kernel Parameters in AIX
    • 1.7. Memory and CPU Management
      • 1.7.1. Display RAM Size in DEC Unix
      • 1.7.2. Display RAM Size in HP-UX
      • 1.7.3. Display RAM Size in Solaris
      • 1.7.4. Display RAM Size in AIX
      • 1.7.5. Use svmon in AIX
      • 1.7.6. Display Allocated Memory Segments
      • 1.7.7. Manually Deallocate a Memory Segment
      • 1.7.8. Display the Number of CPUs
      • 1.7.9. Display the number of CPUs in Solaris
    • 1.8. Semaphore Management
      • 1.8.1. Change Kernel Parameters
      • 1.8.2. Display Values for Semaphores
      • 1.8.3. Count Used Semaphores
      • 1.8.4. Determine the Semaphore Sets Held by an Instance
      • 1.8.5. Remove a Held Semaphore After a Crash
    • 1.9. System Log Messages
      • 1.9.1. Show Server Log in HP-UX
      • 1.9.2. Show Server Log in AIX
    • 1.10. Server Monitoring
      • 1.10.1. Use top
      • 1.10.2. Use sar
        • 1.10.2.1. sar -u (CPU report)
        • 1.10.2.2. sar -w (memory switching and swapping activity)
        • 1.10.2.3. sar -b (buffer activity report)
      • 1.10.3. Use sadc
      • 1.10.4. Use vmstat
      • 1.10.5. Automate vmstat Collection
        • 1.10.5.1. cr_vmstat_tab.sql
        • 1.10.5.2. get_vmstat.ksh
        • 1.10.5.3. Sample vmstat report
      • 1.10.6. Display Swap Usage in AIX
      • 1.10.7. Display Swap Usage in HP-UX
      • 1.10.8. Show Server Load Averages
      • 1.10.9. Use iostat
      • 1.10.10. Automate iostat Collection
        • 1.10.10.1. cr_iostat_tab.sql
        • 1.10.10.2. get_iostat.ksh
    • 1.11. File Management
      • 1.11.1. List Recently Touched Files
      • 1.11.2. List Recently Changed Files
      • 1.11.3. Delete Unchanged Files
      • 1.11.4. Display File Sizes in 512-Byte Blocks
      • 1.11.5. Locate Files That Contain Certain Strings
      • 1.11.6. Find Recently Created Files
      • 1.11.7. Find Large Files on a Server
      • 1.11.8. Delete Files in Bulk
      • 1.11.9. Delete Old Trace and Audit Files
      • 1.11.10. Allocate an Empty File
      • 1.11.11. Change Default File Permissions
        • 1.11.11.1. Understand Unix file permissions
        • 1.11.11.2. Find the systemwide default file permissions
        • 1.11.11.3. Set default permissions for your session
      • 1.11.12. Change File Ownership
      • 1.11.13. Change File Permissions
    • 1.12. Disk Management
      • 1.12.1. List Logical Volumes in HP-UX
      • 1.12.2. Display Unix Mount Points
        • 1.12.2.1. Display mount points in HP-UX
        • 1.12.2.2. Display mount points in AIX and Solaris
      • 1.12.3. Manage Dialect Differences for Filesystems
      • 1.12.4. Show Mount Points for a Physical Disk in AIX
    • 1.13. Miscellaneous Shell Scripts
      • 1.13.1. Create a Soft Link for a File
      • 1.13.2. Make a Tape Backup Using tar
      • 1.13.3. Copy tnsnames.ora to All Unix Servers
      • 1.13.4. Test for a Dead Net8 Listener
      • 1.13.5. Exit a Script When the Database Is Not Running
      • 1.13.6. Detect When Oracle Is Not Accepting Connections
      • 1.13.7. Mail ORA-600 Errors from the Alert Log to the DBA
      • 1.13.8. Schedule Tasks with cron
        • 1.13.8.1. View currently scheduled jobs
        • 1.13.8.2. Schedule a new job
  • Index
  • SPECIAL OFFER: Upgrade this ebook with OReilly

pokaż cały spis treści

ukryj recenzje