Re: "Depreciated" Parameters In SPFILE

Charles Hooper wrote:

>> Instead of using EXPLAIN PLAN run a couple of selected statements for
>> real and then look at what actually happened. Does fact equal theory?
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org

> 
> All DBMS_XPLANS showed the actual execution plans, except for one,
> which was intentionally created to show the same plan as what appeared
> in the 10053 trace files (which showed the prediction).

I'm not sure you read what I intended. Explain Plans may or may not accurately reflect reality. I am suggesting running a couple of the statements without explain plan and then looking at the metrics of what Oracle actually does. Does it match the explain plan?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org