 |
|
ss
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
Dimension Level
Column
Owner Name
Name
Name
Inferred
-------- ---------- -------------------- -------------- -----
TELE_DBA TEST_DIM PARENT_ID STATEMENT_ID N
The database dimension attribute report should
be reviewed to ensure that the proper attributes are ascribed to the
proper levels.
Monitoring Stored Outlines
Outlines provide a method for forcing the
cost-based optimizer to consistently use the same optimization for a
specific SQL statement. The DBA needs to be aware of which outlines
are currently stored in the database and whether it has been used.
The views used to monitor the outlines are dba_outlines and
dba_outline_hints. Note that to create an outline, the plan_table must
be located in either a publicly available schema or in your own
schema. In Oracle9i, the OEM tool has been extended to allow for
outline editing.
There are also new DBMS packages provided for
this purpose. The views relationship is shown in Figure 7.7. An
example report using the dba_outlines and dba_outline_hints views is
shown below, with example output from the script following.
Mike has
priced his collection of scripts at $49.95, less than a dime per
script. You can download them immediately at this link:
|
