Oracle BI security patches released for versions 12.2.1, 11.1.1.9, and 11.1.1.7, with the latter reaching its final patchset.
Introduction to the #obihackers IRC channel for discussing Oracle Business Intelligence (OBIEE), ODI, and general tech topics in an informal setting.
A historical account of Oracle's poor performance in a 1983 database benchmark and their alleged attempt to have the professor behind it fired.
A database expert reflects on the 2013 Frankfurt Database Days conference, comparing SQL Server and Oracle features like isolation levels and security.
Explains how to instrument OBIEE database connections for improved performance diagnostics and user session tracking.
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.
Oracle releases OBIEE 11g for HP-UX Itanium, surprising the author who doubted it would happen.
Explains the importance of defining CLIENT_ID in OBIEE for user query tracking and troubleshooting database calls.
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.
