79736

79736



Computing the Minimum Undo Tablespace Size Using the Undo Advisor

If you must changc the undo tablespace to a fixed size, then usc the Undo Advisor to help determine the minimum rcquircd size. You can also usc the Undo Advisor to set the minimum undo retention period.

To configure the undo tablespace to have a fixed size, Oracle suggests that you first allow enough time after database creation to run a fuli workload, thus allowing the undo tablespace to grow to its minimum required size to handle the workload. Then, you can use the Undo Advisor to determine the best size to configure the undo tablespace to allow for futurę long-running queries and Oracle Flashback operations.



Wyszukiwarka

Podobne podstrony:
Leadership is a potent combination of STRATEGY AND CHARACTER. But if you must be without one, BE WIT
and verify that the Mini Setup Wizard is operating correctly. You must run Sysprep.exe again to rese
ancc va)ue at any othcr temperaturę. We can also compute the resistance by using the temperaturę
History of MySQL We started out with the intention of using the mSQLdatabase system to connect to ou
Using different storage engines on master and slave. It is possible to replicate transactional table
The devices and computers connected to Ethernet must have their own addresses to communicate on the
MR293R190)3 1 REMOTAL Using a fiat screwdriver, raise oover (1) at the ends of the strip. Puli the s
cw0020 Q
dpp37 clean li lis, all the way using one band only, while if you have a lj4-inch bar tliis would be
InnoDB Notes For InnoDB tables, be careful if you modify the column containing the auto-increment va
Using Morę Than one Table The pet table keeps track of which pets you have. If you want to record ot
Setting the Datafile for a Smallfile Tablespace to Automatically Extend This section explains how to
To set a tablespace to automatically cxtcnd: 1.    In EM Express, from the Storage me
Upgrading a Database Using DBUA Complete the following stcps to upgrade a database using DBUA. If yo

więcej podobnych podstron