You can define different consumer groups to contain
different groups of users. The DRM allocates CPU and parallelism resources to
consumer groups based on resource plans. A resource plan defines limits for the
amount of a particular computer resource a group of users can use. This allows the
Bind Variables and Shared SQL
As we??™ve mentioned, Oracle??™s shared SQL is a key feature for building high-performance
applications. In an OLTP application, similar SQL statements may be used repeatedly,
but each SQL statement submitted will have different selection criteria contained in the
WHERE clause to identify the different sets of rows on which to operate. Oracle can
share SQL statements, but the statements must be absolutely identical.
To take advantage of this feature for statements that are identical except for specific
values in a WHERE clause, you can use bind variables in your SQL statements. The
values substituted for the bind variables in the SQL statement may be different, but the
statement itself is the same.
Consider an example application for granting raises to employees.
Pages:
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473