Expert Oracle RAC Performance Diagnostics and Tuning / / by Murali Vallath
| Expert Oracle RAC Performance Diagnostics and Tuning / / by Murali Vallath |
| Autore | Vallath Murali |
| Edizione | [1st ed. 2014.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 |
| Descrizione fisica | 1 online resource (690 p.) |
| Disciplina | 005.75/85 |
| Collana | Expert's Voice in Oracle |
| Soggetto topico |
Database management
Data structures (Computer science) Database Management Data Structures and Information Theory |
| ISBN |
9781430267102
1430267100 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910300462903321 |
Vallath Murali
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle 10g RAC [[electronic resource] ] : grid, services & clustering / / Murali Vallath
| Oracle 10g RAC [[electronic resource] ] : grid, services & clustering / / Murali Vallath |
| Autore | Vallath Murali |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Amsterdam ; ; Boston, : Elsevier Digital Press, c2006 |
| Descrizione fisica | 1 online resource (699 p.) |
| Disciplina | 005.75/65 |
| Soggetto topico |
Relational databases
Parallel processing (Electronic computers) Electronic data processing - Distributed processing Beowulf clusters (Computer systems) |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-281-00712-9
9786611007126 0-08-049203-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; Oracle® 10g RAC Grid, Services & Clustering; Copyright Page; Table of Contents; About the Author; About the Technical Contributors; About the Technical Reviewers; Acknowledgments; Preface; About This Book; How to Use This Book; Chapter 1. Oracle Grid; 1.1 Electric power grid; 1.2 Computational grids; 1.3 Evolution; 1.4 Enterprise grid computing; 1.5 Globus Toolkit; 1.6 Oracle grid; 1.7 Conclusion; Chapter 2. Real Application Cluster Architecture; 2.1 RAC components; 2.2 Real Application Cluster; 2.3 Background processes in RAC; 2.4 Database files in RAC
2.5 Maintaining read consistency in RAC 2.6 Cache fusion; 2.7 Global Resource Directory; 2.8 Mastering of resources; 2.9 Lock management; 2.10 Multi-instance transaction behavior; 2.11 Recovery; 2.12 Conclusion; Chapter 3. Storage Management; 3.1 Disk fundamentals; 3.2 Data operations; 3.3 SAME; 3.4 Oracle Managed Files; 3.5 Storage options for RAC; 3.6 Automatic storage management (ASM); 3.7 Migration to ASM; 3.8 ASM performance monitoring using EM; 3.9 ASM implementations; 3.10 ASM instance crash; 3.11 ASM disk administration; 3.12 Client connection to an ASM instance; 3.13 Conclusion Chapter 4. Installation and Configuration 4.1 Optimal Flexible Architecture; 4.2 Selecting the clusterware; 4.3 Operating system configuration; 4.4 Network configuration; 4.5 NIC bonding; 4.6 Verify interprocess communication buffer sizes; 4.7 Jumbo frames; 4.8 Remote access setup; 4.9 Configuring the kernel; 4.10 Configuring the hangcheck timer on Linux systems; 4.11 Configuring and synchronizing the system clock; 4.12 Installing Oracle; 4.13 Additional information; 4.14 Conclusion; Chapter 5. Services and Distributed Workload Management; 5.1 Service framework 5.2 Distributed workload management 5.3 Fast Application Notification; 5.4 Conclusion; Chapter 6. Failover and Load-Balancing; 6.1 Failover; 6.2 Load-balancing; 6.3 Conclusion; Chapter 7. Oracle Clusterware Administration Quick Reference; 7.1 Node verification using olsnodes; 7.2 Oracle Control Registry; 7.3 ONS control (onsctl) utility; 7.4 EVMD verification; 7.5 Oracle Clusterware interface; 7.6 Conclusion; Chapter 8. Backup and Recovery; 8.1 Recovery Manager; 8.2 RMAN components; 8.3 Recovery features; 8.4 Configuring RMAN for RAC; 8.5 Backup and recovery strategy; 8.6 Configuring RMAN 8.7 Reporting in RMAN 8.8 Recovery; 8.9 Conclusion; Chapter 9. Performance Tuning; 9.1 Methodology; 9.2 Storage subsystem; 9.3 Automatic Storage Management; 9.4 Cluster interconnect; 9.5 Interconnect transfer rate; 9.6 SQL*Net tuning; 9.7 SQL tuning; 9.8 Sequences and index contention; 9.9 Undo block considerations; 9.10 Load-balancing; 9.11 Resource availability; 9.12 Response time; 9.13 Oracle Wait Interface; 9.14 Server/database statistics; 9.15 Service-level metrics; 9.16 Identifying blockers across instances; 9.17 Identifying hot blocks; 9.18 Monitoring remastering 9.19 Operating system tuning |
| Record Nr. | UNINA-9910451171403321 |
Vallath Murali
|
||
| Amsterdam ; ; Boston, : Elsevier Digital Press, c2006 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle 10g RAC [[electronic resource] ] : grid, services & clustering / / Murali Vallath
| Oracle 10g RAC [[electronic resource] ] : grid, services & clustering / / Murali Vallath |
| Autore | Vallath Murali |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Amsterdam ; ; Boston, : Elsevier Digital Press, c2006 |
| Descrizione fisica | 1 online resource (699 p.) |
| Disciplina | 005.75/65 |
| Soggetto topico |
Relational databases
Parallel processing (Electronic computers) Electronic data processing - Distributed processing Beowulf clusters (Computer systems) |
| ISBN |
1-281-00712-9
9786611007126 0-08-049203-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; Oracle® 10g RAC Grid, Services & Clustering; Copyright Page; Table of Contents; About the Author; About the Technical Contributors; About the Technical Reviewers; Acknowledgments; Preface; About This Book; How to Use This Book; Chapter 1. Oracle Grid; 1.1 Electric power grid; 1.2 Computational grids; 1.3 Evolution; 1.4 Enterprise grid computing; 1.5 Globus Toolkit; 1.6 Oracle grid; 1.7 Conclusion; Chapter 2. Real Application Cluster Architecture; 2.1 RAC components; 2.2 Real Application Cluster; 2.3 Background processes in RAC; 2.4 Database files in RAC
2.5 Maintaining read consistency in RAC 2.6 Cache fusion; 2.7 Global Resource Directory; 2.8 Mastering of resources; 2.9 Lock management; 2.10 Multi-instance transaction behavior; 2.11 Recovery; 2.12 Conclusion; Chapter 3. Storage Management; 3.1 Disk fundamentals; 3.2 Data operations; 3.3 SAME; 3.4 Oracle Managed Files; 3.5 Storage options for RAC; 3.6 Automatic storage management (ASM); 3.7 Migration to ASM; 3.8 ASM performance monitoring using EM; 3.9 ASM implementations; 3.10 ASM instance crash; 3.11 ASM disk administration; 3.12 Client connection to an ASM instance; 3.13 Conclusion Chapter 4. Installation and Configuration 4.1 Optimal Flexible Architecture; 4.2 Selecting the clusterware; 4.3 Operating system configuration; 4.4 Network configuration; 4.5 NIC bonding; 4.6 Verify interprocess communication buffer sizes; 4.7 Jumbo frames; 4.8 Remote access setup; 4.9 Configuring the kernel; 4.10 Configuring the hangcheck timer on Linux systems; 4.11 Configuring and synchronizing the system clock; 4.12 Installing Oracle; 4.13 Additional information; 4.14 Conclusion; Chapter 5. Services and Distributed Workload Management; 5.1 Service framework 5.2 Distributed workload management 5.3 Fast Application Notification; 5.4 Conclusion; Chapter 6. Failover and Load-Balancing; 6.1 Failover; 6.2 Load-balancing; 6.3 Conclusion; Chapter 7. Oracle Clusterware Administration Quick Reference; 7.1 Node verification using olsnodes; 7.2 Oracle Control Registry; 7.3 ONS control (onsctl) utility; 7.4 EVMD verification; 7.5 Oracle Clusterware interface; 7.6 Conclusion; Chapter 8. Backup and Recovery; 8.1 Recovery Manager; 8.2 RMAN components; 8.3 Recovery features; 8.4 Configuring RMAN for RAC; 8.5 Backup and recovery strategy; 8.6 Configuring RMAN 8.7 Reporting in RMAN 8.8 Recovery; 8.9 Conclusion; Chapter 9. Performance Tuning; 9.1 Methodology; 9.2 Storage subsystem; 9.3 Automatic Storage Management; 9.4 Cluster interconnect; 9.5 Interconnect transfer rate; 9.6 SQL*Net tuning; 9.7 SQL tuning; 9.8 Sequences and index contention; 9.9 Undo block considerations; 9.10 Load-balancing; 9.11 Resource availability; 9.12 Response time; 9.13 Oracle Wait Interface; 9.14 Server/database statistics; 9.15 Service-level metrics; 9.16 Identifying blockers across instances; 9.17 Identifying hot blocks; 9.18 Monitoring remastering 9.19 Operating system tuning |
| Record Nr. | UNINA-9910784232403321 |
Vallath Murali
|
||
| Amsterdam ; ; Boston, : Elsevier Digital Press, c2006 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle 10g RAC : grid, services & clustering / / Murali Vallath
| Oracle 10g RAC : grid, services & clustering / / Murali Vallath |
| Autore | Vallath Murali |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Amsterdam ; ; Boston, : Elsevier Digital Press, c2006 |
| Descrizione fisica | 1 online resource (699 p.) |
| Disciplina | 005.75/65 |
| Soggetto topico |
Relational databases
Parallel processing (Electronic computers) Electronic data processing - Distributed processing Beowulf clusters (Computer systems) |
| ISBN |
9786611007126
9781281007124 1281007129 9780080492032 0080492037 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; Oracle® 10g RAC Grid, Services & Clustering; Copyright Page; Table of Contents; About the Author; About the Technical Contributors; About the Technical Reviewers; Acknowledgments; Preface; About This Book; How to Use This Book; Chapter 1. Oracle Grid; 1.1 Electric power grid; 1.2 Computational grids; 1.3 Evolution; 1.4 Enterprise grid computing; 1.5 Globus Toolkit; 1.6 Oracle grid; 1.7 Conclusion; Chapter 2. Real Application Cluster Architecture; 2.1 RAC components; 2.2 Real Application Cluster; 2.3 Background processes in RAC; 2.4 Database files in RAC
2.5 Maintaining read consistency in RAC 2.6 Cache fusion; 2.7 Global Resource Directory; 2.8 Mastering of resources; 2.9 Lock management; 2.10 Multi-instance transaction behavior; 2.11 Recovery; 2.12 Conclusion; Chapter 3. Storage Management; 3.1 Disk fundamentals; 3.2 Data operations; 3.3 SAME; 3.4 Oracle Managed Files; 3.5 Storage options for RAC; 3.6 Automatic storage management (ASM); 3.7 Migration to ASM; 3.8 ASM performance monitoring using EM; 3.9 ASM implementations; 3.10 ASM instance crash; 3.11 ASM disk administration; 3.12 Client connection to an ASM instance; 3.13 Conclusion Chapter 4. Installation and Configuration 4.1 Optimal Flexible Architecture; 4.2 Selecting the clusterware; 4.3 Operating system configuration; 4.4 Network configuration; 4.5 NIC bonding; 4.6 Verify interprocess communication buffer sizes; 4.7 Jumbo frames; 4.8 Remote access setup; 4.9 Configuring the kernel; 4.10 Configuring the hangcheck timer on Linux systems; 4.11 Configuring and synchronizing the system clock; 4.12 Installing Oracle; 4.13 Additional information; 4.14 Conclusion; Chapter 5. Services and Distributed Workload Management; 5.1 Service framework 5.2 Distributed workload management 5.3 Fast Application Notification; 5.4 Conclusion; Chapter 6. Failover and Load-Balancing; 6.1 Failover; 6.2 Load-balancing; 6.3 Conclusion; Chapter 7. Oracle Clusterware Administration Quick Reference; 7.1 Node verification using olsnodes; 7.2 Oracle Control Registry; 7.3 ONS control (onsctl) utility; 7.4 EVMD verification; 7.5 Oracle Clusterware interface; 7.6 Conclusion; Chapter 8. Backup and Recovery; 8.1 Recovery Manager; 8.2 RMAN components; 8.3 Recovery features; 8.4 Configuring RMAN for RAC; 8.5 Backup and recovery strategy; 8.6 Configuring RMAN 8.7 Reporting in RMAN 8.8 Recovery; 8.9 Conclusion; Chapter 9. Performance Tuning; 9.1 Methodology; 9.2 Storage subsystem; 9.3 Automatic Storage Management; 9.4 Cluster interconnect; 9.5 Interconnect transfer rate; 9.6 SQL*Net tuning; 9.7 SQL tuning; 9.8 Sequences and index contention; 9.9 Undo block considerations; 9.10 Load-balancing; 9.11 Resource availability; 9.12 Response time; 9.13 Oracle Wait Interface; 9.14 Server/database statistics; 9.15 Service-level metrics; 9.16 Identifying blockers across instances; 9.17 Identifying hot blocks; 9.18 Monitoring remastering 9.19 Operating system tuning |
| Record Nr. | UNINA-9911087929703321 |
Vallath Murali
|
||
| Amsterdam ; ; Boston, : Elsevier Digital Press, c2006 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle 10g RAC : grid, services & clustering / / Murali Vallath
| Oracle 10g RAC : grid, services & clustering / / Murali Vallath |
| Autore | Vallath Murali |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Amsterdam ; ; Boston, : Elsevier Digital Press, c2006 |
| Descrizione fisica | 1 online resource (699 p.) |
| Disciplina | 005.75/65 |
| Soggetto topico |
Relational databases
Parallel processing (Electronic computers) Electronic data processing - Distributed processing Beowulf clusters (Computer systems) |
| ISBN |
9786611007126
9781281007124 1281007129 9780080492032 0080492037 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; Oracle® 10g RAC Grid, Services & Clustering; Copyright Page; Table of Contents; About the Author; About the Technical Contributors; About the Technical Reviewers; Acknowledgments; Preface; About This Book; How to Use This Book; Chapter 1. Oracle Grid; 1.1 Electric power grid; 1.2 Computational grids; 1.3 Evolution; 1.4 Enterprise grid computing; 1.5 Globus Toolkit; 1.6 Oracle grid; 1.7 Conclusion; Chapter 2. Real Application Cluster Architecture; 2.1 RAC components; 2.2 Real Application Cluster; 2.3 Background processes in RAC; 2.4 Database files in RAC
2.5 Maintaining read consistency in RAC 2.6 Cache fusion; 2.7 Global Resource Directory; 2.8 Mastering of resources; 2.9 Lock management; 2.10 Multi-instance transaction behavior; 2.11 Recovery; 2.12 Conclusion; Chapter 3. Storage Management; 3.1 Disk fundamentals; 3.2 Data operations; 3.3 SAME; 3.4 Oracle Managed Files; 3.5 Storage options for RAC; 3.6 Automatic storage management (ASM); 3.7 Migration to ASM; 3.8 ASM performance monitoring using EM; 3.9 ASM implementations; 3.10 ASM instance crash; 3.11 ASM disk administration; 3.12 Client connection to an ASM instance; 3.13 Conclusion Chapter 4. Installation and Configuration 4.1 Optimal Flexible Architecture; 4.2 Selecting the clusterware; 4.3 Operating system configuration; 4.4 Network configuration; 4.5 NIC bonding; 4.6 Verify interprocess communication buffer sizes; 4.7 Jumbo frames; 4.8 Remote access setup; 4.9 Configuring the kernel; 4.10 Configuring the hangcheck timer on Linux systems; 4.11 Configuring and synchronizing the system clock; 4.12 Installing Oracle; 4.13 Additional information; 4.14 Conclusion; Chapter 5. Services and Distributed Workload Management; 5.1 Service framework 5.2 Distributed workload management 5.3 Fast Application Notification; 5.4 Conclusion; Chapter 6. Failover and Load-Balancing; 6.1 Failover; 6.2 Load-balancing; 6.3 Conclusion; Chapter 7. Oracle Clusterware Administration Quick Reference; 7.1 Node verification using olsnodes; 7.2 Oracle Control Registry; 7.3 ONS control (onsctl) utility; 7.4 EVMD verification; 7.5 Oracle Clusterware interface; 7.6 Conclusion; Chapter 8. Backup and Recovery; 8.1 Recovery Manager; 8.2 RMAN components; 8.3 Recovery features; 8.4 Configuring RMAN for RAC; 8.5 Backup and recovery strategy; 8.6 Configuring RMAN 8.7 Reporting in RMAN 8.8 Recovery; 8.9 Conclusion; Chapter 9. Performance Tuning; 9.1 Methodology; 9.2 Storage subsystem; 9.3 Automatic Storage Management; 9.4 Cluster interconnect; 9.5 Interconnect transfer rate; 9.6 SQL*Net tuning; 9.7 SQL tuning; 9.8 Sequences and index contention; 9.9 Undo block considerations; 9.10 Load-balancing; 9.11 Resource availability; 9.12 Response time; 9.13 Oracle Wait Interface; 9.14 Server/database statistics; 9.15 Service-level metrics; 9.16 Identifying blockers across instances; 9.17 Identifying hot blocks; 9.18 Monitoring remastering 9.19 Operating system tuning |
| Record Nr. | UNINA-9911138459103321 |
Vallath Murali
|
||
| Amsterdam ; ; Boston, : Elsevier Digital Press, c2006 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||