You are going to do this prior to every sql call! Why? I might see a
reason once when you logon, but prior to every sql call is going to hurt
scalability. Doesn't look like you are using bind variables either.
Jim
"Anil Asher" <anilasher_at_hotmail.com> wrote in message
news:d24b10ea.0112071529.50cc84a0_at_posting.google.com...
> Please help me resolve an on going debate about how much load the
> following SQL will cause if it were to called prior to every SQL call
>
> select * from dba_objects where OWNER = 'SOMEONE'
> AND OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY')
> AND STATUS = 'VALID'
> AND to_date(TIMESTAMP,'YYYY-MM-DD:HH24:MI:SS') >
> (select logon_time FROM v$sessio where audsid = userenv('SESSIONID'))
>
> The purpose of the SQL is to determine if any Functions, Packages or
> Procedures have been re-compiled after this connection was
> established.
>
> Also, if anyone knows of an environment variable (or equally efficient
> object) which could provide us with the last compile time, please let
> me know.
>
> Thanks in advacne for your help.
> Anil
Received on Fri Dec 07 2001 - 19:14:25 CST
