Monthly Archives: December 2012

sql_sql_id.sql 1.7

Here is thing with SQL tuning: at a certain point you encounter an inefficient SQL statement. You look at it with for example Active Session History. So you find out it does a full table scan on a big table. … Continue reading

Posted in Oracle performance tuning | Tagged , , , , | Leave a comment

trace_column.sql 1.1

For a long time, as a DBA, I mostly didn’t have access to tuning tools, like the Diagnostics Pack. Oracle’s Diagnostics Pack is very handy and I’d recommend it to to anyone who has to deal with performance problems in … Continue reading

Posted in Oracle performance tuning | Tagged , , , , | Leave a comment