Tag: Database
Implementing Column Independent Oracle Partitioning over Loosely Correlated Columns using Oracle Database 10g Materialized Views Oracle as of Oracle 10gR2 does not provide an efficient method for tables to be simultaneously partitioned by two or more statistically independent columns. Dougherty discusses a proven approach for reducing search space for multi-terabyte tables in such cases.
- Quest Customer Learning Team
- Whitepapers & presentations
- 6/25/13
Implementing Column Independent Oracle Partitioning over Loosely Correlated Columns using Oracle Database 10g Materialized Views Oracle as of Oracle 10gR2 does not provide an efficient method for tables to be simultaneously partitioned by two or more statistically independent columns. Dougherty discusses a proven approach for reducing search space for multi-terabyte tables in such cases.
- Quest Customer Learning Team
- Whitepapers & presentations
- 6/25/13
Implementing Column Independent Oracle Partitioning over Loosely Correlated Columns using Oracle Database 10g Materialized Views Oracle as of Oracle 10gR2 does not provide an efficient method for tables to be simultaneously partitioned by two or more statistically independent columns. Dougherty discusses a proven approach for reducing search space for multi-terabyte tables in such cases.
- Quest Customer Learning Team
- Whitepapers & presentations
- 6/25/13
Nanda lists best practices that stem from both his readings as well as from working for along time as a production support and architect DBA. He summarizes some of those practicesthat cater to “real life.”
- Quest Customer Learning Team
- Whitepapers & presentations
- 6/25/13
Nanda lists best practices that stem from both his readings as well as from working for along time as a production support and architect DBA. He summarizes some of those practicesthat cater to “real life.”
- Quest Customer Learning Team
- Whitepapers & presentations
- 6/25/13
Nanda lists best practices that stem from both his readings as well as from working for along time as a production support and architect DBA. He summarizes some of those practicesthat cater to “real life.”
- Quest Customer Learning Team
- Whitepapers & presentations
- 6/25/13
By Ray Smith Oracle provides risk matrices for all of its products with quarterly Critical Patch Updates (CPU) (recently changed to Security Patch Updates (SPU)). This article provides some guidance about how the Oracle Database Risk Matrix can be interpreted, but the interpretation and implementation decisions rest with the Oracle professional and their corporate security…
- Quest Customer Learning Team
- Blogs
- 6/01/13
Memory serialization control is core to Oracle database operations. When serialization is used, how it works, how we can influence its operation, and how we diagnose problems is one of the most fascinating topics in Oracle internals and performance optimization. But it's a complex situation. To get the upper hand on serialization control this presentation…
- Quest Customer Learning Team
- Whitepapers & presentations
- 5/21/13
Memory serialization control is core to Oracle database operations. When serialization is used, how it works, how we can influence its operation, and how we diagnose problems is one of the most fascinating topics in Oracle internals and performance optimization. But it's a complex situation. To get the upper hand on serialization control this presentation…
- Quest Customer Learning Team
- Whitepapers & presentations
- 5/21/13
Memory serialization control is core to Oracle database operations. When serialization is used, how it works, how we can influence its operation, and how we diagnose problems is one of the most fascinating topics in Oracle internals and performance optimization. But it's a complex situation. To get the upper hand on serialization control this presentation…
- Quest Customer Learning Team
- Whitepapers & presentations
- 5/21/13