 
      
    | You are here | joze-senegacnik.blogspot.com | ||
| | | | | oracle-randolf.blogspot.com | |
| | | | | Why attend this workshop? As a developer you hope that a relational database keeps the promise of SQL working in principle like a black box ... | |
| | | | | 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 | |
| | | | | I like very much Tanel Poder snapper and Carlos Sierra SQLTXPLAIN. They represent valuable performance diagnostic tools. Unfortunately I am still waiting to find a customer site where I will be allowed or granted necessary privileges to install and to use them. There are client sites where I have been asked to tune queries without... | |
| | | | | 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... | ||