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.
A technical analysis of how an expired database password caused Informatica to spawn excessive connections, crashing an Oracle server.
A technical attendee's review of the 2010 RittmanMead BI Forum, focusing on deep-dive sessions and previews of the upcoming OBIEE 11g.
A developer troubleshoots an ORA-01017 error in Oracle BI Applications (OBIA) despite valid credentials, exploring JDBC driver and case-sensitivity issues.
A developer's troubleshooting note on fixing Oracle's ORA-00845 error by resizing /dev/shm after reading the alert log.
How to resolve ORA-13757 error when deleting an active SQL Tuning Set in Oracle, including diagnostic queries and cleanup steps.
Oracle's performance recommendations for OBIA 7.9.6, focusing on ETL improvements and hardware sizing.
Analysis of Oracle's fragmented online support ecosystem, comparing official blogs, forums, and communities to the effective Oracle-L mailing list.
Explains how to set Client ID in OBIEE database connections to trace problematic SQL queries back to specific users for troubleshooting.
Fixing a specific Oracle OBIEE SELinux error: 'libnnz10.so: cannot restore segment prot after reloc: Permission denied'.
A critical analysis of the CAF migration tool for Oracle BI, discussing its risks and unsupported status in production environments.
Discusses the state of the OBIEE (Oracle Business Intelligence) community forum, moderation ideas, and hopes for the upcoming OBIEE 11g release.
Oracle's future OBIEE 11g will shift from OC4J/OAS to WebLogic Server as its primary application server.
A guide to diagnosing and fixing the ORA-12154 TNS error when OBIEE fails to connect to an Oracle database.
Analysis of Oracle's October Critical Patch Update, focusing on the OBIEE vulnerability CVE-2009-1990 and its patch details.
Oracle's October Critical Patch Update addresses security vulnerabilities in OBIEE and Oracle Application Server, requiring immediate attention.
