Critical importance of data visualization
photo by David Blackwell. Not sure if you can imagine or have ever experienced a meeting where you bring in
Read More
Making Technology Bulletproof
Author: Kyle Hailey
12c PDBs & Delphix: like chocolate & Peanut Butter
Oracle 12c introduces the new Pluggable Database (PDB) functionality into the Oracle database. What’s the advantage of PDBs? PDBs
Read MoreEM 12c Snap Clone
Oracle OEM 12c introduces a new feature that enables the creation of Oracle database thin clones by leveraging file system
Read MoreMetrics vs Statistics
Here are the tuning metrics tables (SQL stats are not in “metric” tables per say) (*DBA_HIST_…_HISTORY views are sort of
Read MoreWait Metrics vs Wait Events
Here is a quick table comparison of different types of metrics views The first line of the table is the
Read MoreEnqueue – PK, FK or Bitmap Index problem?
If one is seeing waits for enq: TX – row lock contention then there could be a lot of reasons. One
Read MoreOracle I/O latency monitoring
One thing that I have found sorely missing in the performance pages of Enterprise Manager is latency values for various
Read MoreCURSOR_SHARING : a picture is worth a 1000 words
Anyone who has been around Oracle performance over the years knows the grief that hard parsing SQL queries can cause
Read MoreFinding the slowest SQL execution of the same query
When running the same query multiple times, several questions come to mind: Does the query always execute in the same
Read MoreOracle CPU Time
Image from Bertrand Drouvot UPDATE: thanks to a discussion in the comments it’s come to my attention that there should
Read MoreWhere to begin with Oracle and SQL
Seeing more and more questions on “where do I start with Oracle if I want to be a DBA?” My
Read MoreTCP Trace Analysis for NFS
How do we know where latency comes from when there is a disparity in reported I/O latency on the I/O
Read MoreOracle time units in V$ views
Oracle has a crazy mix of units of time in various v$ views seconds centi-seconds milliseconds microseconds Some are straight
Read MoreLatency heatmaps in D3 and Highcharts
See Brendan Gregg’s blog on how important and cool heatmaps can be for showing latency information and how average latency hides what
Read More