Re: Session Stats

>>>>> "Niall" == Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> writes:

 Niall> If the session has been running for a long time (like an app
 Niall> server connection for eg) might it be a numeric overflow. Or
 Niall> maybe it just got the answers before you issued the queries :)

I don't think the precognitive optimizer is available yet - Oracle have been having problems with the dbms_astrology.stats() procedures. Apparently it should be available in 14i (but of course, won't work properly until 16i).

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!