Fixing OBIEE 11g UPGAST-00055 error by creating the missing Oracle Universal Installer inventory file after a local installation.
Fixing Oracle tnsping error 'Message 3513 not found' on Windows by adjusting the PATH variable order after installing a new Oracle version.
Explains the ambiguous GATHER AUTO option in Oracle's DBMS_STATS for gathering database statistics, clarifying its behavior compared to STALE and EMPTY.
Oracle's Product Assurance team launches a new technical blog focused on OBIEE configuration, tuning, and detailed implementation guidance.
Explains the importance of defining CLIENT_ID in OBIEE for user query tracking and troubleshooting database calls.
Oracle releases OBIEE 11g for HP-UX Itanium, surprising the author who doubted it would happen.
Oracle's July Critical Patch Update addresses a security vulnerability (CVE-2011-2241) in OBIEE versions 10.1.3.4.1 and 11.1.1.3.
A guide to forcing Oracle 11g to use a specific execution plan for a problematic SQL query using SQL Plan Baselines.
Explores issues with DBMS_STATS.COPY_TABLE_STATS in Oracle, focusing on incorrect high/low value propagation for partitioned table statistics.
Argues against using Oracle's automatic optimizer statistics collection in data warehouses, advocating for manual stats management as part of ETL processes.
Analysis of HP's marketing claims against Oracle Exadata, focusing on technical FUD and balanced system design for data warehousing.
Oracle's technical documentation is available in Kindle and iPad-friendly formats, making it easier to read and learn from.
Explains how sampling frequency affects I/O throughput data accuracy in Oracle performance analysis, using a humorous analogy.
Compares I/O measurement methods using Oracle V$SYSSTAT and HP MeasureWare, showing near-identical results graphed with rrdtool.
A technical deep-dive into making Partition Change Tracking (PCT) refresh with partition truncation work correctly for Materialized Views in Oracle 11g.
A guide to visualizing Oracle database I/O metrics using gnuplot for more accurate performance analysis than standard GUI tools.
A developer questions when a software issue is labeled a 'design decision' instead of a bug, using an Oracle and Informatica case study.
Explains why average I/O throughput metrics from AWR snapshots can be misleading for capacity planning, using real database examples.
A developer's solution to Oracle's fragmented OBIEE 11g documentation: an offline, searchable PDF collection.
A technical guide on implementing and testing Oracle Database Resource Manager for CPU allocation and performance monitoring in a data warehouse environment.
