Explore >> Select a destination
|
You are here 
|
hoopercharles.wordpress.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... | |
| | | | |
timurakhmadeev.wordpress.com
|
|
| | | | | 90% databases that I see for the first time have the same issue with UNDO tablespace: it's over sized, yet still causing infamous ORA-1555 errors at times. Here is why. UNDO is over-sized because of a dumb monitoring which treats UNDO tablespace in the same way as normal datafiles, i.e. the monitoring suggests to have... | |
| | | | |
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... | |
| | | | |
carlos-sierra.net
|
|
| | | SQLTXPLAIN, also know as SQLT, is a tool that helps to diagnose SQL statements performing poorly in an Oracle database. This tool is free to download and use. You only need to have access to My Oracle Support (MOS) and search for Document Id: 215187.1. Q: What do you get from this tool? A: In... | ||
