|
You are here |
tonyhasler.wordpress.com | ||
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | Last week I wrote a note about turning a range-partitioned table into a range/list composite partitioned table using features included in 12.2 of Oracle. But my example was really just an outline of the method and bypassed a number of the little extra problems you're likely to see in a real-world system, so in this... | |
| | | | |
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... | |
| | | | |
antognini.ch
|
|
| | | | | ||
| | | | |
jonathanlewis.wordpress.com
|
|
| | | I have mentioned transitive closure in the past, and the commentson this blog item go into some depth about some of the effects of transitive closure. However, arecent incoming link has prompted me to point out a couple of further details about the appearance (or non-appearance) of transitive closure. We start with three (virtually) identical... | ||