001tuning
Two Ways to Count a Full Table Scan
Follow table scan rows gotten through Oracle, GDB and RICO2. Compare row-by-row and block accounting, deleted row flags and the effect of SQL*Plus ARRAYSIZE.
13 MIN READRead the field notes ↗
BROWSE THE FIELD NOTES
tuning
29 field notes / page 1 of 3
002tuning
What to do with 5GB of trace files?
Parse it 🙂 Simple, right? But for sure we are not going to use tkprof for 14 000 trace files, are we? We don’t have Diagnostic Pack and we just started a complete database tracing for an hour or two, because t
5 MIN READRead the field notes ↗
003tuning
When AWR is not enough, a.k.a. Why your app is not cloud-ready. #SMARTDB
In my previous post I described a case of "enq: TX – row lock contention" that was actually a network latency problem. More and more those kinds of problems (it seems like history happens all over again) caused
10 MIN READRead the field notes ↗
004tuning
The curious case of enq: TX – row lock contention
So we had a doubtful pleasure of migrating a few databases from Oracle Exadata X3-2 to Oracle Exadata X7-2 Cloud at Customer. Why doubtful? Well, this a material for a whole different story with a lot of beer –
6 MIN READRead the field notes ↗
005tuning
ODBV3 and ASM
At Trivadis Performance Days 2018 (awesome event by the way) I promised to deliver ODBV3 with support for ASM – and here it is! 🙂 https://github.com/ora600pl/odbv To use it, you have to have access to a user a
2 MIN READRead the field notes ↗
006tuning
ODBV3 – more comfortable usage
It has been crazy few months – organizing POUG2018 took a lot of energy but it was satisfying as hell! 😀 This weekend I had some time to prepare a new version of ODBV for Trivadis Performance Days 2018 where I
3 MIN READRead the field notes ↗
007tuning
Visualize your STATSPACK reports with Python Plotly
If you work as a consultant, getting remote access to your customer is sometimes a nightmare! Even when you’ll get one, there a times when you just want to get your job done and finish this nightmare. For examp
2 MIN READRead the field notes ↗
008tuning
Direct path insert and IOTs
(Please tell me that I’m not the only one who thinks "Index Organized Table" instead of "Internet Of Things" when hearing IOT…) This post is inspired by Connor McDonald and his blog post from a year ago about d
13 MIN READRead the field notes ↗
009tuning
rollback internals
While researching redo log internals for V00D00 we had to face the fact, that we know shit about real transactional behavior. When I say "real", I mean – under the hood. Even with a very simple stuff like COMMI
9 MIN READRead the field notes ↗
010tuning
How Oracle stores numbers internally
Before you proceed, please check out this short article written by Tanel Poder: https://blog.tanelpoder.com/2010/09/02/which-number-takes-more-space-in-an-oracle-row/ In the documentation, you can find the foll
3 MIN READRead the field notes ↗
011tuning
OTN Appreciation Day : pragma UDF
Joining the OTN Appreciation Day 🙂 I really like the new pragma UDF feature for PL/SQL – it makes me believe that context switches will be less painful in the future 🙂 I wrote a little bit more about it here:
1 MIN READRead the field notes ↗
012tuning
Using DTrace to understand why PL/SQL packages can be faster than stored procedures (kgiPinObject)
I know – everyone knows, that PL/SQL packages are faster than stored procedures. If you’ll ask anyone at the training or in your dev team "what is better" – you’ll (almost) always hear: PL/SQL packages. But why
7 MIN READRead the field notes ↗