Oracle DBMS_RESCONFIG
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose Provides an interface to operate on the resource configuration list and to retrieve listener information for a resource
AUTHID N/A
Constants
Name Data Type Value
APPEND_RECURSIVE NUMBER 2
APPEND_RESOURCE NUMBER 1
DELETE_RECURSIVE NUMBER 2
DELETE_RESOURCE NUMBER 1
Dependencies
DBMS_RC_LIB PLITBLM XDB$STRING_LIST_T
DBMS_STANDARD RESOURCE_VIEW XMLTYPE
EQUAL_PATH XDB$RCLIST_V  
Documented Yes
First Available 10.2.0.1
Related System Privileges XDBADMIN
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/dbmsxrc.sql
Subprograms
 
ADDREPOSITORYRESCONFIG
Inserts the resource configuration specified by rcpath at the given position of the repository's configuration list. Shifts the element currently at that position (if any) and any subsequent elements to the right. dbms_resconfig.addrepositoryresconfig(rcpath IN VARCHAR2, pos IN PLS_INTEGER := NULL);
exec dbms_ResConfig.AddRepositoryResConfig('/sys/xs/morgan.xml', 20);

-- see also prvthzxevents.plb
 
ADDRESCONFIG
Inserts the resource configuration specified by rcpath at the given position in the target resource's configuration list dbms_resconfig.addresconfig(
respath IN VARCHAR2,
rcpath  IN VARCHAR2,
pos     IN PLS_INTEGER := NULL);
PRAGMA SUPPLEMENTAL_LOG_DATA(deleteResConfig, AUTO);
TBD
 
APPENDRESCONFIG
Appends the resource configuration specified by rcpath to the target resource's configuration list if it is not already included in the list dbms_resconfig.appendresconfig(
respath      IN VARCHAR2,
rcpath       IN VARCHAR2,
appendOption IN PLS_INTEGER);
PRAGMA SUPPLEMENTAL_LOG_DATA(deleteResConfig, AUTO);
TBD
 
DELETEREPOSITORYRESCONFIG
Removes the configuration at the given position in the repository's configuration list. Shifts any subsequent elements to the left. Users must have XDBADMIN role to execute this. This statement is treated as if it is a DDL statement. This means the system will implicitly commit before and after this statement.

Warning: Running this statement, as shown, is destructive. Demo only.
dbms_resconfig.deleteRepositoryResConfig(pos IN PLS_INTEGER);
-- found in xse102.sql
BEGIN
  dbms_ResConfig.DeleteRepositoryResConfig(6);
  dbms_ResConfig.DeleteRepositoryResConfig(5);
  dbms_ResConfig.DeleteRepositoryResConfig(4);
  dbms_ResConfig.DeleteRepositoryResConfig(3);
  dbms_ResConfig.DeleteRepositoryResConfig(2);
  dbms_ResConfig.DeleteRepositoryResConfig(1);
  dbms_ResConfig.DeleteRepositoryResConfig(0);
END;
/
 
DELETERESCONFIG
Removes the configuration at the given position in the target resource's configuration list
Overload 1
Warning: Running this statement, as shown, is destructive. Demo only.
dbms_resconfig.deleteresconfig(respath IN VARCHAR2, pos IN PLS_INTEGER);
PRAGMA SUPPLEMENTAL_LOG_DATA(deleteResConfig, AUTO);
exec dbms_resconfig.deleteresconfig('/sys/xs', 9);
Removes the configuration specified by rcpath from the target resource's configuration list. Shifts any subsequent elements to the left. Users must have write-config privilege on all affected resources to execute this.

Overload 2
dbms_resconfig.deleteresconfig(
respath      IN VARCHAR2,
rcpath       IN VARCHAR2,
deleteOption IN PLS_INTEGER);
PRAGMA SUPPLEMENTAL_LOG_DATA(deleteResConfig, AUTO);
-- found in nacla112.sql
zz
 
GETLISTENERS
Returns an XML doc containing the list of listeners applicable for a given resource dbms_resconfig.getlisteners(path IN VARCHAR2) RETURN SYS.XMLType;
SELECT dbms_resconfig.getlisteners('/sys/xs') FROM dual;
 
GETREPOSITORYRESCONFIG
Returns the resource configuration at the specified position of the repository's configuration list dbms_resconfig.getRepositoryResConfig(pos IN PLS_INTEGER) RETURN SYS.XMLType;
SELECT dbms_resconfig.getRepositoryResConfig(0)
FROM dual;
 
GETREPOSITORYRESCONFIGPATHS
Returns a list of resource configuration paths defined for the repository dbms_resconfig.getrepositoryresconfigpaths RETURN XDB$STRING_LIST_T;
SELECT * FROM TABLE(dbms_resconfig.getRepositoryResConfigPaths());

DECLARE
 out_list xdb$string_list_t := dbms_resconfig.getRepositoryResConfigPaths();
BEGIN
  FOR i in 1..out_list.COUNT LOOP
    dbms_output.put_line(out_list(i));
  END LOOP;
END;
/

-- see also xsu112.sql
 
GETRESCONFIG
Returns the resource configuration at the specified position of the target resource's configuration list dbms_resconfig.getresconfig(respath IN VARCHAR2, pos IN PLS_INTEGER)
RETURN sys.XMLType;
SELECT dbms_resconfig.getresconfig('/sys/xs', 4)
FROM dual;
 
GETRESCONFIGPATHS
Returns a list of resource configuration paths defined in the target resource's configuration list dbms_resconfig.getresconfigpaths(respath IN VARCHAR2) RETURN XDB$STRING_LIST_T;
SELECT dbms_resconfig.getresconfigpaths('/sys/xs') FROM dual;
 
Related Queries
Found in xse102.sql SELECT ANY_PATH p
FROM RESOURCE_VIEW
WHERE under_path(RES, '/sys/xs', 1) = 1
ORDER BY depth(1) DESC;

Related Topics
Packages

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