Category Archives: Troubleshooting

The infamous jdbc closed connection

Sometimes you, as an DBA, is blamed for everything. The database is slow, unavailable, unpatched, and the list goes on and on. Sometimes, in rare situations, you can prove then wrong 😀 Last week we have been called to analyze … Continue reading

Posted in database, Troubleshooting | Tagged , | Leave a comment

db_multiblock_read_count – to be or not to be?

Sometimes you wanna to use things with default options…and sometimes the default is not good enough. We all know that db_file_multiblock_read_count is bumped by default on startup, usually you get 128 blocks per read. Why? From Oracle documentation, this value … Continue reading

Posted in Performance, Troubleshooting | Tagged , , | Leave a comment

Using oradebug – 10053 and 10046 events

Hello There! Hope this article finds you well. Today we will talk about oradebug, this little wonder in oracle, and how to set the 10046 and 10053 events to troubleshoot performance. First of all, what is oradebug? Oradebug is a … Continue reading

Posted in Performance, Troubleshooting | Tagged , , , , | Leave a comment