|
You are here |
sai-oracle.blogspot.com | ||
| | | | |
alexzeng.wordpress.com
|
|
| | | | | 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, Managing the Very Large Database by Tim Gorman, will tell us the key point to manage VLDB. The key feature that makes VLDB possible in oracle is partition. The important... | |
| | | | |
postgresql.verite.pro
|
|
| | | | | To avoid having concurrent transactions interfere with each other,SQL engines implement isolation as a feature.This property corresponds to the I letter in t... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | A recent thread on the OTN database forum asks the question: "... since redo also has past and current information why can't redo logs be used to retrieve that information? Why is undo required when redo already has all that information." The thread has generated some interesting replies - but to a large extent they... | |
| | | | |
tonyhasler.wordpress.com
|
|
| | | When a table is accessed by multiple members of a parallel query server set, the execution plan may show the use of block range granules (PX BLOCK ITERATOR) or partition granules (PX PARTITION [RANGE|LIST|HASH] ITERATOR or PX PARTITION [RANGE|LIST|HASH] ALL). The basic ideas surrounding these concepts are discussed in numerous blogs and books, including my... | ||