Book Cover
Author Burleson, Donald Keith

Title Unix for Oracle DBAs : pocket reference / Donald K. Burleson
Published Beijing ; Farnham : O'Reilly, 2001


Description 1 online resource (v, 104 pages)
Contents Unix for Oracle DBAs Pocket Reference; 1.1.2. Conventions Used in This Book; 1.1.3. Long Code Lines; 1.2. Understanding Unix; 1.2.2. Case Sensitivity; 1.2.3. Safety; 1.2.4. Linkability; 1.2.5. Shells; 1.3. Building Unix Commands; 1.3.2. Build a Complex Unix Command from Scratch; A script to find all files containing a specific string; 1.4. Unix Server Environment; 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 Script1.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.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.2. Display Server Device Values in AIX1.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.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.2. Display Values for Semaphores; 1.8.3. Count Used Semaphores
1.8.4. Determine the Semaphore Sets Held by an Instance1.8.5. Remove a Held Semaphore After a Crash; 1.9. System Log Messages; 1.9.2. Show Server Log in AIX; 1.10. Server Monitoring; 1.10.2. Use sar; sar -w (memory switching and swapping activity); sar -b (buffer activity report); 1.10.3. Use sadc; 1.10.4. Use vmstat; 1.10.5. Automate vmstat Collection; get_vmstat.ksh; 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 get_iostat.ksh1.11. File Management; 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; Find the systemwide default file permissions; Set default permissions for your session; 1.11.12. Change File Ownership
Summary The Unix for Oracle DBAs Pocket Reference puts within easy reach the commands that Oracle database administrators need most when operating in a Unix environment. If you are an Oracle DBA moving to Unix from another environment such as Windows NT or IBM Mainframe, you know that these commands are far different from those covered in most beginning Unix books. To jump start your learning process, Don Burleson has gathered together in this succinct book the Unix commands he most often uses when managing Oracle databases. You'll be able to reach into your pocket for the answer when you need to know how to:<li type="disc">Display all Unix components related to Oracle, identify the top CPU consumers on your server, and even kill processes when necessary<li type="disc">Stack Unix commands into powerful scripts that can perform vital DBA functions<li type="disc">Monitor Unix filesystems, and automatically manage your trace files, dump files, and archived redo log files<li type="disc">Use essential server monitoring commands such as top, sar, and vmstatAnd there's much more between these covers. If you need to get up to speed with Oracle on Unix, and quickly, this book is for you
Notes Includes index
Copyright © O'Reilly Media, Incorporated 2001
Print version record
Subject UNIX (Computer file)
Oracle (Computer file)
Oracle (Computer file)
UNIX (Computer file)
Relational databases.
Database management -- Handbooks, manuals, etc.
Relational databases.
Genre/Form Electronic books
Form Electronic book
LC no. 2001273261
ISBN 9780596000660