|
You are here |
connor-mcdonald.com | ||
| | | | |
www.bobbydurrettdba.com
|
|
| | | | | Sunday night we worked with Oracle Support on a performance issue with a query that had been running for over 14 hours even though it ran the previous weekend in five minutes. Oracle Support showe... | |
| | | | |
dohdatabase.com
|
|
| | | | | Oracle Java Virtual Machine allows you to execute Java code directly in the database. This offers some amazing benefits. However, if it is not in use, you can speed up patching and upgrading by removing it. But how do you know whether it is in use? | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | Here's a little detail about Oracle's calculation of user_tables.avg_row_len that I hadn't noticed before - and I really should have noticed it years ago, so maybe I'm the only person who's surprised by it. The figure isn't necessarily telling you about the number of bytes stored in the row. We've seen plenty of oddities relating... | |
| | | | |
www.bobbydurrettdba.com
|
|
| | | We have been discussing query tuning at work and I've come back to an example of the Oracle optimizer choosing the wrong plan due to an error in its calculation of the number of rows returned... | ||