Re: about SYSDATE function

Jonathan Lewis wrote:
>
> If you look in standard.sql you will find that
> there is a lot of new date/time functionality
> defined - BUT NOT YET SUPPORTED !
>
> The need to 'select sysdate from dual' is
> to ensure that the server-side date/time
> is returned. The new features will also
> allow you to return client-side date/time.
>
> --
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Practical Oracle 8i: Building Efficient Databases
> Publishers: Addison-Wesley
>
> Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>
> >(off topic) one things that's been touted for 8.1.7.1 and above is that
> >calls to sysdate in PL/SQL no longer generated a nasty 'select sysdate
> >from dual'
> >
> >Yet to be proven or disproven
> >--
> >===========================================
> >Connor McDonald
> >http://www.oracledba.co.uk (mirrored at
> >http://www.oradba.freeserve.co.uk)
> >
> >"Some days you're the pigeon, some days you're the statue"

Found this in the patch note for 8.1.7.1

"This performance regression was introduced with the fix in Bug:616870. With this fix calling SYSDATE from PL/SQL is much slower as SYSDATE is obtained by selecting from DUAL.
This fix restores server side performance by allowing server side PLSQL to use internal calls rather than selecting from DUAL."

Cheers
Connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"