||Oracle Tips by Burleson
Chapter 4 Oracle Instance Design
last redo log could be added to the standby
database, and the database could be started in just a few minutes.
Note: Oracle standby servers need to be fully
licensed if they are “hot standby” servers that can be used for
queries. Cold standby servers used less than 10 days per year do
not need to be licensed.
The point of this chapter is that the SGA must
be properly designed and that the SGA can change dramatically as the
system is implemented. Hence, you must constantly monitor and
change the Oracle instance to optimize it accord to your current
Next let’s take a look at the proper design for
tablespaces and review the various Oracle physical design options.
shares their personal arsenal of Oracle data dictionary
scripts in this comprehensive download. With decades of
experience using Oracle monitoring scripts and Oracle tuning
scripts, we shares our secrets for navigating the Oracle
Packed with more than 690 ready-to-use Oracle scripts, this is the
definitive collection for every senior Oracle DBA.
would take man-years to develop these scripts from scratch,
making this download the best value in the Oracle industry.