Tag Archives: Performance

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