The CTAS, a.k.a. Processing Data the Jetson’s Way
**Note- This is an article I wrote about 4 years ago that, as far as I know, can only be
Read More
Making Technology Bulletproof
Oracle
EM12c Information Reporting
Information Publisher, (IP) Reporting has been a feature of Enterprise Manager for quite some time now, but I’ve just recently
Read MoreAbstracts, Reviews and Conferences, Oh My!
So yes, I’ve been involved in a number of conferences and in a number of different roles. I started out
Read MoreTuning for Time- CTAS and Views
Inspecting work area usage for memory is an important aspect of my job when I’m performing a tuning exercise. This
Read MoreBeing Friends with Larry Ellison… :)
So I tried to finish out some of my OOW posts, but I ended up talking about this with a
Read More#OOW, Tuesday Followup
Great day today with a second WIT session and all the interviews and General Session for Enterprise Manager 12c. If
Read MoreOracle Open World- Sunday!
The ACE Director briefings are done and now we are onto Sunday sessions. I’ve already had a couple meetings with
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 MoreEM12c Enterprise Monitoring, Part III
This is Part III in a multi-part series, demonstrating how to take EM12c from out of the box to enterprise
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 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 More