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.
491 articles from this blog
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.
A technical guide on monitoring OBIEE systems using JMX, shell scripting, and gnuplot for metrics collection and real-time graphing.
A technical guide on using JMX and jmxsh to monitor and collect performance data from OBIEE (Oracle Business Intelligence) systems.
A technical guide on using gnuplot to visualize OBIEE performance monitoring data captured from JMX metrics.
A technical guide on integrating custom OBIEE performance monitoring graphs into Oracle Application Server (OAS) using Apache configuration.
Troubleshooting a JavaHost hang in OBIEE 10g causing chart server errors, with diagnostic steps and a restart solution.
Diagnosing and resolving intermittent LDAP authentication failures in OBIEE 10g when connecting to Microsoft Active Directory.
