Oracle KU$_DPLOCK
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
Purpose Local package for SW update locking.

At the end of the dpload.sql script the package is dropped.
AUTHID DEFINER
Dependencies
DBMS_DB_VERSION DBMS_REGISTRY DUAL
DBMS_LOCK DBMS_STANDARD KU$_DPLOAD
Documented No
First Available 19c
Security Model Owned by SYS with no privileges granted
Source

Note: Running dpload.sql is time consuming and resource intensive. See KU$_DPLOAD for details.
{ORACLE_HOME}/rdbms/admin/dpload.sql
Subprograms
 
END_SW_UPDATE
Undocumented ku$_dplock.end_sw_update(swlock_handle IN VARCHAR2);
exec ku$_dplock.end_sw_update('10737418451073741845168');

PL/SQL procedure successfully completed.
 
GET_DB_VERSION
Undocumented ku$_dplock.get_db_version RETURN VARCHAR2;
SELECT ku$_dplock.get_db_version;

GET_DB_VERSION
---------------
23.0.0.0.0
 
START_SW_UPDATE
Undocumented ku$_dplock.start_sw_update(timeout IN NUMBER DEFAULT 0) RETURN VARCHAR2;
SELECT ku$_dplock.start_sw_update;

START_SW_UPDATE
------------------------
10737418451073741845168

Related Topics
Built-in Functions
Built-in Packages
KU$_DPLOAD
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved