Unix for Oracle DBAs pocket reference
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 ar...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing ; Sebastopol, California :
O'Reilly
[2001]
|
| Edición: | First edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627131806719 |
Tabla de Contenidos:
- 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; 1.3.2.2. 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; 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.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.2. 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; 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
