Explore >> Select a destination
|
You are here 
|
blog.toadworld.com | ||
| | | | |
dioncho.wordpress.com
|
|
| | | | | 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... | |
| | | | |
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).... | |
| | | | |
mauro-pagano.com
|
|
| | | | | 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... | |
| | | | |
www.xt-r.com
|
|
| | | ????????? ???? ????? ?? ?????? ??????, ??? ?????????? ??????????, ??????, ???????, ????? ? ??????? ??????????? ?????? : ???? ????? ????????... | ||
