Arisant RAC Autoconfig (whitepaper)
This whitepaper describes the process for enabling AutoConfig with Oracle 10g RAC and CRS. If this is not done correctly, the advantages of running Oracle RAC are diminished.
Data Warehousing and Business Intelligence – The Complete Story (presentation)
This presentation describes various Oracle technologies used in a warehouse and Business Intelligence projects. It covers useful tips and techniques, which when implemented properly, help you maximize your Oracle IT investments. The presentation covers database features specific to data warehousing, Business Intelligence features (OBIEE) and data loading techniques using PL/SQL and Oracle Data Integrator (ODI).
Data Warehouse – Optimizing Data Loading and Querying (presentation)
This presentation describes various techniques used to manage large scale ETL loads leveraging PL/SQL’s BULK load features. It also covers other data movement techniques such as replication, transportable tablespaces, Change Data Capture (CDC), Oracle Data Pump as well as a number of database features that help you better manage moving large data volumes around your data warehouse. Finally, the presentation discusses query and data access techniques to address performance challenges.
Because Daddy Did Not Buy You an Exadata for Christmas: Data Warehouse Performance on a Budget (presentation)
This presentation covers various techniques that can be used to performance tune large data warehouses. It discusses common performance problems in warehouse environments and covers design techniques, and offers tips and techniques on how to leverage materialized views and query rewrite, design aggregations, and using Oracle Dimension objects to add flexibility to query rewrite.
This in-depth presentation describes the Flashback Data Archive (FDA) feature available in Oracle 11g. The presentation discusses the necessity for FDA and covers the basic use cases that this feature can apply to. It covers architecture, best practices and examples that demonstrate how to setup and use FDA.
This presentation includes powerful tips and techniques that every DBA should be aware of! The presentation offers tips on examining important initialization parameters, running statistics, using AWR and Statspack to produce performance snapshots, leveraging OS level tools such as vmstat, prstat and Windows Performance Monitor, examining ADDM, AWR, ASH reports and tuning related data dictionary views, and leveraging SQL Tuning Advisor.