Outer Web | Explore

Explore >> Select a destination

You are here		tonyhasler.wordpress.com The importance of the GLOBAL_STATS statistic on partitioned tables \| Tony's Oracle Tips
\|	\|	nenadnoveljic.com Undocumented Implicit Partition Statistics Gathering - All-round Database Topics	2.7 parsecs away Travel
\|	\|	A boundary condition where subpartition statistics gathering can also trigger partition statistics	2.7 parsecs away Travel
\|	\|	dioncho.wordpress.com Interesting case of the restriction of global hints \| Dion Cho - Oracle Performance Storyteller	2.9 parsecs away Travel
\|	\|	One of my colleagues sent following test case, of which he couldn't control the join order with hints. 1. Create objects - table t1, t2 and t3 2. Now Let's set the join order as T1->T2->T3, using global hints convention. But it seems that Oracle does not work as expected. It really seems that the...	2.9 parsecs away Travel
\|	\|	mauro-pagano.com SQL Diag Repository \| Mauro Pagano's Blog	2.9 parsecs away Travel
\|	\|	Every once in a while I look around the list of new (fixed) views in the instance trying to find useful / interesting things to add to SQLd360 and recently I stumbled into V$SQL_DIAG_REPOSITORY / V$SQL_DIAG_REPOSTIORY_REASON. SQL> desc v$sql_diag_repository Name Null? Type ------------------ -------- ------------- ADDRESS RAW(8) CON_ID NUMBER HASH_VALUE NUMBER SQL_ID VARCHAR2(13) CHILD_NUMBER NUMBER...	2.9 parsecs away Travel
\|	\|	hourim.wordpress.com SQLTXPLAIN under Oracle 12c \| Mohamed Houri's Oracle Notes	14.3 parsecs away Travel
\|		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...	14.3 parsecs away Travel