|
You are here |
antognini.ch | ||
| | | | |
sqlmaria.com
|
|
| | | | | Although there have been a number of significant changes to the Oracle Database in 12c, some of my favorite new features are actually the small enhancements, designed to make your life a little eas... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | There is some confusion about the expression "clean" in Oracle circles, so I thought I'd write a short note to explain the different ways in which the word may be applied to Oracle blocks. There are five terms to consider: clean commit cleanout block cleanout delayed block cleanout delayed logging block cleanout Clean: A block... | |
| | | | |
afatkulin.blogspot.com
|
|
| | | | | 11G's ability to do direct path reads during full table scans without utilizing PQ was covered in a number of places already (see this post ... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | Here's a simple detail about bind peeking (during optimisation) that makes a big difference to "fetch first/next" queries. The optimizer knows about your bind types, and can peek at the bind values - but that doesn't mean it will do something sensible with them. Here's a little model to demonstrate the problem - starting with... | ||