Outer Web | Explore

/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.

You are here		www.binovarghese.com PL/SQL - Implicit Cursors
\|	\|	alexzeng.wordpress.com # Expert Oracle Practices # PL/SQL and the CBO \| Alex Zeng's Blog	3.1 parsecs away Travel
\|	\|	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...	3.1 parsecs away Travel
\|	\|	oracleprof.blogspot.com Oracle Performance and Backup Blog: How to find SQL_ID and PLAN_HASH_VALUE in Oracle SQL Plan Management Baselines	4.3 parsecs away Travel
\|	\|	SQL_ID and/or PLAN_HASH_VALUE are used almost globally across Oracle database to identify query. This is not a case for SPM mechanism using...	4.3 parsecs away Travel
\|	\|	oracletoday.blogspot.com Oracle Today: Performance of Autotrace	3.5 parsecs away Travel
\|	\|	I have been having some performance problems when using autotrace in some production systems. I finally had time to check out why. I enabled...	3.5 parsecs away Travel
\|	\|	sqlmaria.com How to determine which view is the right view to use in Oracle?	15.2 parsecs away Travel
\|		Database views are a handy tool to help obfuscate complex joins from developers and analysts. However, knowing which view to use can be tricky, especially when faced with multiple views with simila...	15.2 parsecs away Travel