How much load will this SQL cause

From: Anil Asher <anilasher_at_hotmail.com>
Date: 7 Dec 2001 15:29:45 -0800
Message-ID: <d24b10ea.0112071529.50cc84a0@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 - 17:29:45 CST