Explore >> Select a destination
|
You are here 
|
dbamarco.wordpress.com | ||
| | | | |
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.... | |
| | | | |
jhdba.wordpress.com
|
|
| | | | | Update July 2014 - I have added a parallel post to this which may help when trying to manage the growth of the SYSAUX tablespace https://jhdba.wordpress.com/2014/07/09/tidying-up-sysaux-removing-old-snapshots-which-you-didnt-know-existed/ Whenever statistics in the dictionary are modified, old versions of statistics are saved automatically for future restoring. The old statistics are purged automatically at regular intervals based on... | |
| | | | |
alexzeng.wordpress.com
|
|
| | | | | I am reading Expert Oracle Practices by Oracle Database Administration from the Oak Table. I'd like to summary and share what I learned. This chapter PL/SQL and the CBO by Jo?e Senega?nik is pretty interesting. It tells how to use oracle extensible optimizer to set the selectivity and the cost of PL/SQL functions. This will... | |
| | | | |
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... | ||
