O'Reilly logo

Oracle Database 11g The Complete Reference by Kevin Loney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required