18.104.22.168 Flashback Data Archive Support for DDLs
Oracle Database 11g Release 2 (11.2) users can now use most DDL commands on tables that are being tracked with Flashback Data Archive. This includes:
Add, Drop, Rename, Modify Column
Drop, Truncate Partition
Rename, Truncate Table
Add, Drop, Rename, Modify Constraint
For more complex DDL (for example, upgrades and split table), the Disassociate and Associate PL/SQL procedures can be used to temporarily disable Total Recall on specified tables. The Associate procedure enforces schema integrity after association; the base table and history table schemas must be the same.
This feature makes it much easier to use the Total Recall option with complex applications that require the ability to modify the schema.
22.214.171.124 Instance Caging
Instance Caging allows the DBA to limit the CPU usage of an Oracle instance by setting the
CPU_COUNT initialization parameter and enabling CPU resource management.
With Instance Caging, users can partition CPU resources among multiple instances running on a server to ensure predictable performance.