|
You are here |
jonathanlewis.wordpress.com | ||
| | | | |
sqlmaria.com
|
|
| | | | | Although there have been a number of significant changes to the Oracle Database in 12c, some of my favorite new features are actually the small enhancements, designed to make your life a little eas... | |
| | | | |
dioncho.wordpress.com
|
|
| | | | | I hit following OTN forum article which was a discussion on typical SQL sharing problem. There are so many reasons why Oracle does not share the same statement. Oracle records the reason in v$sql_shared_cursor view. In my local 10.2.0.1 database, v$sql_shared_cursor has 53 reasons of unshareability. But I have a big complaint on v$sql_shared_cursor view.... | |
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | | | [AI summary] An Oracle DBA explores and demonstrates the performance benefits of Exadata Storage Indexes, specifically highlighting their ability to handle NULL values efficiently through SQL query tests. | |
| | | | |
hourim.wordpress.com
|
|
| | | The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating... | ||