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.
617 articles from this blog
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.
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.
Analysis of potentially unreliable connection pool counters in OBIEE Systems Management, showing negative and accumulating values.
A developer shares their experience learning and using two powerful IT tools: rrdtool for data graphing and screen for terminal multiplexing.
A technical guide on modifying LDAP server settings in an OBIEE Repository (RPD) using UDML commands and scripts.
Explains how to instrument OBIEE to pass user and session details to Oracle Database for enhanced query tracing and performance troubleshooting.
A technical deep-dive into making Partition Change Tracking (PCT) refresh with partition truncation work correctly for Materialized Views in Oracle 11g.
Explains Oracle 11g's incremental global statistics for partitioned data warehouses, covering benefits and a major storage overhead issue.
