Monthly Archives: February 2013

My oracle_performance github repository

After seeing Kyle Hailey’s ashmasters¬†GitHub repository (with all kinds of interesting scripts), I thought I might give it a try and start my own repository on GitHub. I blogged about some of my scripts before, but storing these on my … Continue reading

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

More statistics history

After writing about table statistics, I tried my query to retrieve them many times. Soon I found out, I couldn’t find index statistics data. After a while I figured it out. Duh! The table is called WRI$_OPTSTAT_TAB_HISTORY. So I quickly … Continue reading

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

A table statistics history case

Yesterday I got a question by mail to investigate a performance issue. A batchjob that started at 22:08, ran too long. I logged in on the database with Enterprise Manager and investigated the issue with the Oracle Diagnostics Pack. When … Continue reading

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

The best way to gain security awareness, is to learn to hack

One of our managers at my former employer was not amused. You might say he was appalled. I wrote on our company blog a post (in Dutch) about how to use the Java exploit in the Oracle database, recently shown … Continue reading

Posted in Oracle security | Tagged , , , | 1 Comment

Public database links, the often forgotten security leak

A year ago or so I was asked to do a health scan on a database. When I worked for Transfer Solutions we used to have a script for that, that generates quite a large HTML file that we could … Continue reading

Posted in Oracle security | Tagged , , , , | Leave a comment

Table and index statistics history

As a performance tuning DBA I regularely get questions about query performance gone bad. Often you get to hear that everyone was minding their own business and certainly did not change the application code or anything, when suddenly, from one … Continue reading

Posted in Oracle performance tuning | Tagged , , | 1 Comment