Tag: IOUG

Fernandez discusses the shortfalls in the Query optimization, the theory behind it, and possible solutions and takeaways.

Rice shares some of the issues with RMAN that he stumbled upon during implementation and daily usage.

Rice shares some of the issues with RMAN that he stumbled upon during implementation and daily usage.

Rice shares some of the issues with RMAN that he stumbled upon during implementation and daily usage.

Rice shares some of the issues with RMAN that he stumbled upon during implementation and daily usage.

Rice shares some of the issues with RMAN that he stumbled upon during implementation and daily usage.

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.

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.

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.

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.”