 |
|
Oracle Tips by Burleson |
Oracle 10g An Illustration of SQLAccess Advisor
Procedures
When the execution is complete, you can review
the results of the analysis by looking at various SQLAccess Advisor
dictionary views.
SELECT rec_id,
total_pre_cost, total_post_cost
dba_advisor_sqla_rec_sum
SEE
CODE DEPOT
Use the create_task_script procedure to view
the SQL script corresponding to the recommendations.
DBMS_ADVISOR.CREATE_TASK_SCRIPT (:task_n, 'MY_DIR', 'script.sql');
The examples above are merely a sampling of
statements for performing an SQLAccess Advisor tuning session. There
is quite lot of flexibility in setting up and executing the tuning
sessions.
In addition to the package procedure shown
above, the Oracle Enterprise Manager (OEM) can be used to implement
the SQLAccess Advisor. The SQLAccess Advisor Wizard is a built-in
GUI in the OEM. It has comprehensive facilities to create tasks,
create workloads, and analyze at a very rapid speed.
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
