Performance

Data Access using Java Stored Procedures in Oracle Database

Recently I had to troubleshoot a problem related to Java stored procedures in Oracle Database. SQL…
SQLDeveloper’s “mystats.sql” equivalent

It just occurred to me that I haven’t blogged about SQLDeveloper yet, something I really need…
Little things worth knowing: keeping enq: TM enqueue at bay during direct path inserts

Direct path inserts are commonly found in processing where data are shifted from one source to…
Making some more sense of direct path reads during primary key lookups

After having published my first article of 2019 I have received feedback I felt like including.…
Using colplot to visualise performance data

Back in 2011 I wrote a blog post about colplot but at that time focused on…
New Events for Data Guard and Synchronous Redo Transport in 12c (2)

After the baseline has been established in the first part of this series it’s time to…
New Events for Data Guard and Synchronous Redo Transport in 12c (1)

I may have said it before but I consider presenting and teaching a great way to…
TABLE ACCESS INMEMORY FULL – but there may be more

While preparing to teach a class this week I have had the time to look into the…
Little things worth knowing: automatic generation of extended statistics in 12c Part II

In my last post I demonstrated an example how to use a PL/SQL package to monitor…
Little things worth knowing: automatic generation of extended statistics in 12c

When you are migrating to Oracle 12c I hope you might this post useful. I came across…