Most of the times you want/need to squeeze the most out of your Database. One simple way of doing this is by using Native compilation (Available from version 9). To illustrate this I will create a … [Read more...] about Increase Database performance using Native PL/SQL compilation
Although ZFS is designed to be easy to use, it requires some knowledge of how ZFS works to avoid some of the pitfalls. The following scenario is based on real events, but for this example will be as … [Read more...] about Why you need to think before extending your ZFS pool
Most of you DBAs already know how to use Statspack (AWR), but in the beginning, or if you don't do it often enough, it can be hard to know what to check for on a regular basis. Remember to separate … [Read more...] about What to look for in the AWR and/or Statspack Output
I'm wrapping up a few scripts for an upcoming performance investigation at a customers. And find the SQL queries is(can be at least) a Key part of finding DB performance issues. These are all … [Read more...] about Find TOP SQL Statements
This is a short list of parameters that i always glance at before doing any major performance and tuning diagnostics. This is paramaters that i found the hard way and some parameters i've gotten from … [Read more...] about Most important Oracle Initialization Parameters?
Just found Maria Colgans Oracle Open World presentations (https://blogs.oracle.com/optimizer/). She was one of my top 5 presenters during #oow13 so i gladly uploaded the pdfs here to find them later … [Read more...] about 12c Optimizer – Maria Colgan
The Title is stolen from One of Connor Mcdonnalds (http://connormcdonald.wordpress.com) Sessions from 2013 Oracle Open World. Always a pleasure to listen to Connors slide race :) So, if you … [Read more...] about SQL Tuning 101