Skip to Main Content
  • Questions
  • Remote Procedure Call (RPC) Dependency Management - where is remote timestamp stored?

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, MARCIN.

Asked: September 09, 2025 - 9:51 am UTC

Last updated: September 17, 2025 - 3:09 pm UTC

Version: 19c

You Asked

Hi AskTom Team!

According to https://docs.oracle.com/en/database/oracle/oracle-database/19/adfns/schema-object-dependency.html#GUID-B99E885E-900F-4F29-A188-A617A301FDCE :
"Whenever a procedure is compiled, its time stamp is recorded in the data dictionary."

Is it possible to see this recorded timestamp ?


Marcin

and Chris said...

You can see when a procedure was first and most recently compiled with the CREATED & LAST_DDL_TIME columns in *_objects:

create or replace procedure p as
begin
  null;
end;
/

select created, last_ddl_time 
from   user_objects
where  object_name = 'P';

CREATED              LAST_DDL_TIME       
-------------------- --------------------
17-SEP-2025 14:04:58 17-SEP-2025 14:04:58

exec dbms_session.sleep ( 7 );

create or replace procedure p as
begin
  dbms_output.put_line ( 'stuff' );
end;
/

select created, last_ddl_time 
from   user_objects
where  object_name = 'P';

CREATED              LAST_DDL_TIME       
-------------------- --------------------
17-SEP-2025 14:04:58 17-SEP-2025 14:05:05


There doesn't appear to be a documented view that shows the recorded timestamp of remote dependencies however.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library