Explore >> Select a destination
|
You are here 
|
mwidlake.wordpress.com | ||
| | | | |
alexzeng.wordpress.com
|
|
| | | | | Outline is the oldest way to fix SQL plan. It based on hints like use_nl etc. It's a road map. It still can be used in 11.2 although oracle said it's deprecated. Finally, it is free. SQL profile is trying to impact CBO by adding cost estimation hints. You need pay extra money to use... | |
| | | | |
nenadnoveljic.com
|
|
| | | | | A frequently executed SQL causes problems with the initial incremental statistics calculation. | |
| | | | |
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.... | |
| | | | |
sarahgoodreau.com
|
|
| | | Visit the post for more. | ||
