|
You are here |
www.binovarghese.com | ||
| | | | |
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... | |
| | | | |
orastory.wordpress.com
|
|
| | | | | There have been some interesting posts from Marcin Przepiorowski and Kerry Osborne about mapping sql plan management (spm) baselines to a corresponding sql id. The key to sql plan baselines (DBA_SQL_PLAN_BASELINES) is SIGNATURE. And why signature? It's not just another change to the key to identifying sql statements (HASH_VALUE -> (NEW_)HASH_VALUE / OLD_HASH_VALUE -> SQL_ID).... | |
| | | | |
oracletoday.blogspot.com
|
|
| | | | | I have been having some performance problems when using autotrace in some production systems. I finally had time to check out why. I enabled... | |
| | | | |
afatkulin.blogspot.com
|
|
| | | In my previous blog post I've explained a nice little feature introduced to Oracle Text Context indexes in 11G which allows you to do effic... | ||