Feb '10 Issue 01 - Oracle Tip
|
- The automatic shared memory management feature of Oracle10G simplifies administration of the various memory components that make up the System Global Area (SGA) for an Oracle database. In previous releases, database administrators were required to specify the amount of memory allocated to the buffer cache, shared pool, java pool and large pool. Setting, monitoring and adjusting these parameters was time-consuming and often times guesswork. The process could be described as being more of an “art” than a “science.” Sizing them incorrectly usually led to poor performance and/or out-of-memory conditions.
Supercharge your PL/SQL code with 10G Bulk Collect and FORALL
Both statements implements a form of array processing inside PL/SQL
BULK COLLECT facilitates high-speed retrieval of data
FORALL greatly improves performance of INSERT, UPDATE, and DELETE operations.
The Oracle Database achieves significant performance gains with these statements by greatly reducing the number of context switches between the PL/SQL and SQL statement execution engines.
|
|
|
|
