- Shopping Bag ( 0 items )
Other sellers (Paperback)
-
All (2) from $20.53
-
New (2) from $20.53
| Preface | 3 | |
| List of Illustrations | 9 | |
| Chapter 1 | Oracle Database | 11 |
| 1.1 | Memory Structures | 13 |
| 1.2 | Shared SQL Pool | 15 |
| 1.3 | Dictionary Cache | 15 |
| 1.4 | Redolog Buffers | 16 |
| 1.5 | SMON, PMON, DBWR, LGWR | 16 |
| 1.6 | Redolog Files | 19 |
| 1.7 | Control File | 20 |
| 1.8 | Restaurant Example | 20 |
| 1.9 | Standard_Meal.Ora | 21 |
| 1.10 | Family_Meal.Ora | 23 |
| 1.11 | Instance | 25 |
| 1.12 | Database Creation | 29 |
| 1.13 | Database Startup | 29 |
| 1.14 | Database Shutdown | 30 |
| 1.15 | Alert Logs | 30 |
| Chapter 2 | Tables | 31 |
| 2.1 | Table Size: VSIZE parameter | 32 |
| 2.2 | Index | 39 |
| 2.3 | Primary/Foreign Key | 41 |
| 2.4 | Sizing Indexes (Non-clustered Tables) | 43 |
| 2.5 | Sizing Indexes (Clustered Tables) | 44 |
| Chapter 3 | DBA Routine Monitoring | 48 |
| 3.1 | Resource Utilisation | 48 |
| 3.1.1 | Tablespace: Allocated and Used | 49 |
| 3.1.2 | View Creation | 49 |
| 3.1.3 | Synonym Creation | 50 |
| 3.1.4 | Freespace | 51 |
| 3.2 | Fragmentation | 53 |
| 3.2.1 | Contig_Space | 54 |
| 3.2.2 | Dba_Free_Space | 55 |
| 3.3 | Other Useful Views | 58 |
| 3.3.1 | Dba_Tables | 59 |
| 3.3.2 | Sys.dba_Extents | 62 |
| Chapter 4 | Preventive Measures | 64 |
| 4.1 | Library Cache | 67 |
| 4.2 | Data_Dictionary_Cache | 69 |
| 4.3 | Threaded Server Session Memory | 70 |
| 4.4 | Overall Statistics | 70 |
| 4.5 | Disk I/O Traffic | 72 |
| 4.6 | Latch Statistics | 74 |
| 4.7 | RBS Contention | 74 |
| 4.8 | Redolog Buffer Contention | 75 |
| 4.9 | Sort Memory Contention | 75 |
| 4.10 | Problematic SQL Statements | 77 |
| Chapter 5 | Security in Oracle | 78 |
| 5.1 | User Account | 78 |
| 5.2 | Roles | 81 |
| 5.2.1 | Role Creation | 82 |
| 5.3 | Admin | 83 |
| 5.4 | Profile | 83 |
| 5.5 | Grant | 84 |
| 5.6 | Some Views of Privileges | 86 |
| 5.6.1 | Dba_Sys_Privs | 86 |
| 5.6.2 | Dba_Role_Privs | 87 |
| 5.6.3 | Dba_Tab_Privs | 87 |
| Chapter 6 | Rollback Segments | 88 |
| 6.1 | RBS Creation | 91 |
| 6.2 | Rollback Entries | 92 |
| 6.3 | Details of RBS | 94 |
| 6.4 | Estimation of RBS Size | 95 |
| 6.4.1 | RBS Tablespace Creation | 99 |
| 6.4.2 | RBS with Optimal | 99 |
| 6.5 | Entry Size in RBS | 99 |
| 6.6 | Utlbstat and Utlestat | 100 |
| 6.7 | Data vs RBS | 100 |
| Chapter 7 | Backup And Recovery | 102 |
| 7.1 | OS Backup | 102 |
| 7.2 | Cold Backup | 103 |
| 7.3 | Warm Backup | 103 |
| 7.4 | Export/Import Utility | 106 |
| 7.5 | RBS for Import | 109 |
| 7.6 | Pitfalls in Export/Import | 110 |
| 7.7 | Commands For Export/Import | 111 |
| 7.8 | Comparison of Different Backup Methods | 112 |
| 7.9 | Warm Backup Commands | 112 |
| 7.9.1 | Warm Backup Begin/End | 113 |
| 7.10 | Recovery | 114 |
| 7.11 | Standby Database | 115 |
| 7.12 | Instance Failure | 115 |
| 7.13 | Role of DBA | 116 |
| Chapter 8 | Audit | 117 |
| 8.1 | Session Audit | 117 |
| 8.2 | Object Action Audit | 119 |
| Chapter 9 | Application Tuning | 122 |
| 9.1 | Introduction | 122 |
| 9.2 | Interest Calculation | 123 |
| 9.2.1 | Sort | 123 |
| 9.2.2 | Interchange of columns of Primary Key in Select Statement | 124 |
| 9.2.3 | Function | 125 |
| 9.2.4 | Commit | 125 |
| Index | 126 |
Overview