Oracle Database 11g The Complete Reference

SQL Performance Analyzer, 771

SQL replay, 502–509

capturing the workload, 503

controlling and starting the replay clients, 507

creating a workload directory, 503

defining filters, 503–504

exporting AWR data, 506, 509

high-level configuration, 502

initializing and running the replay, 507–509

isolation and links, 502–503

overview of, 502

processing the workload, 506

replaying the workload, 506–507

starting the capture, 505

stopping the capture, 505–506

SQL Result Cache

additional uses, 821

database parameter settings, 818–819

DBMS_RESULT_CACHE package, 819–820

dictionary views, 821

how it works, 812–813

overview of, 812

querying, 771

RESULT_CACHE hints, 813–814

table updates and, 815–816

SQL (Structured Query Language)

combining logic (AND and ...