In our enviroment, we choose the second. After cached the table, oracle will be very smart to know that it should read the table from memory instead of read from disk.
http://dbakevin.blogspot.ro/2012/02/serious-performance-issue-caused-by-11g.html
Testing DB_FLASHBACK_LOG_DEST in 23ai
-
Pre-23ai, Database Flashback Logs always were created in the
DB_RECOVERY_FILE_DEST location (i.e.. the well-known "Fast Recovery Area"
also known as "FR...
Acum 2 zile
Niciun comentariu:
Trimiteți un comentariu