Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Re: Can view$ be pinned ?

From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
To: sfaroult@xxxxxxxxxxxx
Date: Thu, 2 Dec 2004 10:09:24 +0000

On Thu, 2 Dec 2004 09:52:50 +0100, Stephane Faroult
<sfaroult@xxxxxxxxxxxx> wrote:
>=20
> Frank,
>=20
>   IMHO it is a bad idea to try, in whichever way, to improve on the way S=
YS
> objects work. If Oracle cannot properly take care of its own data, then t=
he
> situation is hopeless. I would rather say that the thing to check is the
> deepreason behind those calls.
>=20
> 1) SELECT SYSDATE FROM DUAL : is it useful? Why not use SYSDATE directly =
in
> the INSERT or UPDATE statements? Is the time component of the date really
> useful in your application? Otherwise I guess that the initialisation
> secti=E0on of a package, assuming of course that sessions don't stay conn=
ected
> overnight, could do.

If I recall correctly; until recently (maybe 9.2) using SYSDATE
directly in triggers etc (maybe all PL/SQL) generated 'select sysdate
from dual' recursively. That is you could have large numbers of such
calls without actually having coded them yourself.


--=20
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l

References:

Re: Can view$ be pinned ?
From: Stephane Faroult

Re: Can view$ be pinned ?

Other related posts: