Oracle | KU$

Oracle KU$_DPAPPLY Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Script for applying Data Pump/MetadataAPI patches in Oracle Cloud environments.

AUTHID DEFINER

Dependencies 2

Only Standard

Documented No

First Available 23ai

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dpapply.sql

The SQL script contains a drop at the end.

Subprograms

ELAPSEDTIME	RESTORE_INITTIME
INITTIME	SAVE_INITTIME

ELAPSEDTIME (new 23ai)

Used in the elapsedtime query to return teh results of the execution of the current script file

Note the elapsed time shown in the demo at right does not correspond with any reality: the file named did not exist. ku$_dpapply.elapsedtime(filename IN VARCHAR2) RETURN VARCHAR2;

SELECT ku$_dpapply.elapsedtime('ETTEST.TXT');

      

      KU$_DPAPPLY.ELAPSEDTIME('ETTEST.TXT')

      -------------------------------------

      ETTEST.TXT loaded in 339 seconds.

INITTIME (new 23ai)

Undocumented ku$_dpapply.inittime;

exec ku$_dpapply.inittime;

      

      PL/SQL procedure successfully completed;

RESTORE_INITTIME (new 23ai)

Undocumented ku$_dpapply.restore_inittime;

exec ku$_dpapply.restore_inittime;

      

      PL/SQL procedure successfully completed;

SAVE_INITTIME (new 23ai)

Undocumented ku$_dpapply.save_inittime;

exec ku$_dpapply.save_inittime;

      

      PL/SQL procedure successfully completed;