Robin Moffatt is a Principal DevEx Engineer and seasoned conference speaker with 15+ years of experience presenting at top events like QCon, Devoxx, Kafka Summit, and Strata. He shares insights on developer experience, distributed systems, and cloud technologies through his blog, YouTube, and public talks.
625 articles from this blog
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.
A guide to advanced formatting options for posting source code in WordPress blogs, including syntax highlighting and line control.
Explains the ambiguous GATHER AUTO option in Oracle's DBMS_STATS for gathering database statistics, clarifying its behavior compared to STALE and EMPTY.
Troubleshooting guide for Fedora 14 to 15 upgrade errors, focusing on proxy configuration and post-reboot issues.
A guide to properly labeling time-based axes in Excel by understanding how Excel stores time as fractions of a day.
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.
Troubleshooting an ODI 10g connection error with OCI, identifying the issue as an incorrect ojdbc5.jar driver version.
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.
Explores undocumented command-line parameters for the nqcmd utility in Oracle Business Intelligence, including their potential uses and limitations.
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.
Article on optimizing OBIEE performance by pushing data processing to the database layer instead of the application server.
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.
Guide on resolving the 'OracleXEService should not be installed already' error during Oracle XE 11gR2 beta installation on Windows.
