Performance Management. Objectives. After completing this lesson, you should be able to do the following: Use Enterprise Manager to monitor performance Tune SQL by using the SQL Tuning Advisor Tune SQL by using the SQL Access Advisor Use Automatic Shared Memory Management (ASSM)
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
> Tuning Adv
Invalid ObjSQL Tuning Advisor: Overview
Comprehensive SQL tuning
Automatic Tuning Optimizer
Detect stale or missing
Tune SQL plan
Add missing index
Run access advisor
SQL Tuning Advisor
select count(*) from x where object_id < 340
select count(*) from x where object_id < 220
Each statement causes a hard parse.
Bind variable candidates
Invalid ObjManaging MemoryComponents
Click Enable to enable Automatic Shared Memory Management.