The Value of Cost: Oracle’s Optimizer
When you first begin your journey into Oracle performance tuning, you quickly discover that you’re not just working with databases,
Read More
Making Technology Bulletproof
performance
Troubleshooting ‘resmgr:cpu quantum’ and High CPU in Oracle
After publishing my last post on Oracle Wait Classes, I received a great question on LinkedIn: “How do you identify
Read MoreOracle Internals- Oracle Memory
When describing Oracle features to folks that are new to the platform or coming from other database platforms, I found
Read MoreHammerDB CLI for Oracle on Azure
Disclaimer: I’m not a big fan of benchmark data. I find it doesn’t provide us as much value in the
Read MoreExtended Events with Azure Analysis Services
Its almost standard fare to be using Azure Analysis Services with our customer deployments these days. As our customers evolve
Read MorePower BI 101- Logging and Tracing, Part III
Power BI, like many Microsoft products, is multi-threaded. This can be seen from the logs and even the Task Manager.
Read MorePower BI 101- Logging and Tracing, Part II
So we went over locations and the basics of logging and tracing in Power BI. I now want to know
Read MorePower BI 101 – Log Files and Tracing
Knowing where log files are and how to turn on debugging is an essential part of any technical job and
Read MorePower BI and the Speed(ier) Desktop
I can be an extremely impatient person about anything I think should be faster. I’m diving in deep with Power
Read MorePerformance live discussion on twitter, 12pm PST Tue April 15
Followup: The tweets from the datachat are available at http://www.confio.com/logicalread/oracle-db-performance-80-percent-hardware-dc01/ in chronological order. Confio software is hosting a live
Read MoreOracle SQL*Net Wait Events
Introduction Unfortunately, what Oracle calls “Network Waits” most often have little to do with Network but and almost exclusively
Read MoreOracle : buffer busy wait
Oracle 10 and 11 Buffer Busy Waits usually happen on Oracle 10 and 11 mainly because of insert contention
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 More