A Poor Man's OBIEE EM/BI Management Pack
A low-cost method for monitoring OBIEE 10g systems using built-in JMX, jconsole, and custom scripting for data export and visualization.
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
A low-cost method for monitoring OBIEE 10g systems using built-in JMX, jconsole, and custom scripting for data export and visualization.
SQL queries to analyze and identify performance bottlenecks in Oracle Data Integrator (ODI) batch jobs with many tasks.
A reflection on how uneventful days in system development and support can foster a false sense of security and complacency.
A guide to visualizing Oracle database I/O metrics using gnuplot for more accurate performance analysis than standard GUI tools.
Using awk to split a fixed-width file into separate output files based on content in specific columns.
A developer questions when a software issue is labeled a 'design decision' instead of a bug, using an Oracle and Informatica case study.
A developer solves a TortoiseSVN authentication issue caused by using the svn:// protocol instead of https:// for commits.
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.
Troubleshooting a BI Publisher error when creating Quartz scheduler tables due to insufficient database privileges.
Explores methods for measuring real user response times in OBIEE, comparing simulated tests with actual user activity tracking.
Unix scripts to extract Logical SQL and query performance metrics from OBIEE's NQQuery.log file for testing and analysis.
A presentation on performance testing methodologies and best practices for Oracle Business Intelligence Enterprise Edition (OBIEE).
A developer reflects on delivering their first technical presentation, sharing lessons learned and tips for effective presentation writing.
A technical attendee's review of the 2010 RittmanMead BI Forum, focusing on deep-dive sessions and previews of the upcoming OBIEE 11g.
A technical guide for troubleshooting EBS-BI integrated authentication by validating session cookies directly in the Oracle database.
A developer troubleshoots an ORA-01017 error in Oracle BI Applications (OBIA) despite valid credentials, exploring JDBC driver and case-sensitivity issues.