/explore
|
You are here 
|
jonathanlewis.wordpress.com | ||
| | | | |
blog.developpez.com
[AI summary] This post explains why Oracle uses separate undo tablespaces for read consistency and rollbacks instead of relying solely on redo logs, discussing the technical challenges of a multi-user environment. |
|
| | | | | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
dincosman.com
The performance issue with an SQL query was resolved by using the /*+ PARALLEL(2) */ hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter.... |
|
| | | | | ||
| | | | |
pankajtanwar.in
An illustrated guide, to help you understand how exactly database indexing works internally! |
|
| | | |||
