RE: Aout plan stabilty matching.

Chuan,

If I remember right, you're supposed to turn the outlines on and then run your sikvel or procedure to catch the offensive statement(s).

Regards,
Ed

>
> Hi, All,
> From Oracle Doc: "if the SQL text of the incoming statement
> exactly matches the SQL text in an outline in that category,
> then Oracle considers both texts identical, and Oracle uses
> the outline. Oracle considers any differences a mismatch."
>
> How could I ensure the incoming SQL text exactly match the
> SQL text in an outline? If I fish out an offensive SQL from
> library cache by some scripts in SQL*Plus, is this offensive
> SQL text identical to the incoming SQL text? Supposed this
> SQL text is extracted from stored procedure.
>
> Appreciated your experience.
Received on Tue Sep 10 2002 - 02:57:50 CDT