Books for you

This feature also works on the results of PL/SQL functions.
Oracle Database 11g also includes the ability to cache query result sets on the client,
while automatically keeping the result set consistent with any changes that could
affect it. This feature gives the performance benefits of query result set caching on
the server while eliminating network roundtrips as an added benefit.
How Oracle Uses the Program Global Area
Each server has a Program Global Area (PGA), which is a private memory area that
contains information about the work the server process is performing. There is one
PGA for each server process. The total amount of memory used for all the PGAs is a
function of the number of server processes active as part of the Oracle instance. The
larger the number of users, the higher the number of server processes and the larger
the amount of memory used for their associated PGAs. Using the Multi-Threaded
Server (known as the shared server from Oracle9i on) reduces total memory consumption
for PGAs because it reduces the number of server processes.


Pages:
377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401