Oracle | DBMS_SMB

Oracle DBMS_SMB_INTERNAL 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 SQL Management Base Utilities

AUTHID DEFINER

Dependencies

DBA_INDEXES	DBMS_SQLDIAG	DBMS_UTILITY
DBMS_ADVISOR	DBMS_SQLQ	DBMS_XPLAN
DBMS_ASSERT	DBMS_SQLQ_INTERNAL	DUAL
DBMS_AUTO_INDEX_INTERNAL	DBMS_SQLTUNE	IMPCALLOUTREG$
DBMS_AUTO_ZONEMAP_INTERNAL	DBMS_SQLTUNE_INTERNAL	PRVT_ACCESS_ADVISOR
DBMS_DATAPUMP	DBMS_SQLTUNE_UTIL2	PRVT_ADVISOR
DBMS_LOB	DBMS_STANDARD	PRVT_WORKLOAD
DBMS_METADATA	DBMS_STATS	SMB$CONFIG
DBMS_SMB	DBMS_STATS_ADVISOR	SQLPROF_ATTR
DBMS_SPM	DBMS_STATS_INTERNAL	SYS_IXMLAGG
DBMS_SPM_INTERNAL	DBMS_SYS_ERROR	XMLTYPE

Documented No

First Available 19.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvssmbi.plb

Subprograms

CHECK_SMO_PROPS	INIT_SMB_PARAMETER_FUN	NORMALIZE_NAME
CURSOR_TO_HINTS_XML	INSTANCE_CALLOUT_IMP	OPEN_SMB_OBJ_CURSOR
INIT_SMB	I_CONSTRUCT_SMB_QUERY	VARR_TO_HINTS_XML
INIT_SMB_PARAMETER	MAP_ORIGIN_BASE_TO_VIEW	VERIFY_QUALIFIED_STGTAB

CHECK_SMO_PROPS

Undocumented dbms_smb_internal.check_smo_props( obj_type IN VARCHAR2, origin IN VARCHAR2, enabled IN VARCHAR2, accepted IN VARCHAR2, fixed IN VARCHAR2);

TBD

CURSOR_TO_HINTS_XML

Undocumented dbms_smb_internal.cursor_to_hints_xml(cur IN REF CURSOR) RETURN CLOB;

TBD

INIT_SMB

Initializes the DBMS_SMB and and DBMS_SPM packages. dbms_smb_internal.init_smb();

exec dbms_smb_internal.init_smb();

      

      PL/SQL procedure successfully completed.

INIT_SMB_PARAMETER

Undocumented dbms_smb_internal.init_smb_parameter( p_name IN VARCHAR2, p_value IN NUMBER, p_data IN CLOB);

TBD

INIT_SMB_PARAMETER_FUN (new 23ai)

Undocumented dbms_smb_internal.init_smb_parameter_fun( p_name IN VARCHAR2, p_value IN NUMBER, p_data IN CLOB) RETRN BOOLEAN;

TBD

INSTANCE_CALLOUT_IMP

Undocumented dbms_smb_internal.instance_callout_imp( obj_name IN VARCHAR2, obj_schema IN VARCHAR2, obj_type IN NUMBER, prepost IN BINARY_INTEGER, action OUT VARCHAR2, alt_name OUT VARCHAR2);

TBD

I_CONSTRUCT_SMB_QUERY

Undocumented dbms_smb_internal.i_construct_smb_query( query_txt IN OUT CLOB, sql_handle IN VARCHAR2, obj_name IN VARCHAR2, obj_type IN VARCHAR2, sql_text IN CLOB, creator IN VARCHAR2, origin IN VARCHAR2, enabled IN VARCHAR2, accepted IN VARCHAR2, fixed IN VARCHAR2, module IN VARCHAR2, action IN VARCHAR2, category IN VARCHAR2, open_cur_flags IN BINARY_INTEGER);

TBD

MAP_ORIGIN_BASE_TO_VIEW

Undocumented dbms_smb_internal.map_origin_base_to_view( originnum IN NUMBER, objtype IN NUMBER) RETURN VARCHAR2;

TBD

NORMALIZE_NAME

Does not provide any validation that the "name" is a valid name in Oracle. Looks like it could be easily replace with UPPER. dbms_smb_internal.normalize_name( instr IN VARCHAR2, err_code IN NUMBER) RETURN VARCHAR2;

SELECT dbms_smb_internal.normalize_name('UWCLASS.SMBstg/TAB');

      

      DBMS_SMB_INTERNAL.NORMALIZE_NAME('UWCLASS.SMBSTG/TAB')

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

      UWCLASS.SMBSTG/TAB

OPEN_SMB_OBJ_CURSOR

Undocumented dbms_smb_internal.open_smb_obj_cursor( sql_handle IN VARCHAR2, obj_name IN VARCHAR2, obj_type IN VARCHAR2, sql_text IN CLOB, creator IN VARCHAR2, origin IN VARCHAR2, enabled IN VARCHAR2, accepted IN VARCHAR2, fixed IN VARCHAR2, module IN VARCHAR2, action IN VARCHAR2, category IN VARCHAR2, open_cur_flags IN BINARY_INTEGER, cur OUT REF CURSOR, impcallout IN BOOLEAN);

TBD

VARR_TO_HINTS_XML

Converts a VARRAY with hints into XML dbms_smb_internal.varr_to_hints_xml(varr IN sys.sqlprof_attr) RETURN CLOB;

TBD

VERIFY_QUALIFIED_STGTAB

Returns an object name fully qualified with double quotes in a manner analogous to that performed by DBMS_ASSERT to address SQL Injection issues dbms_smb_internal.verify_qualified_stgtab(qualified_stgtab_name IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_smb_internal.verify_qualified_stgtab('ZZYZX');

      

      DBMS_SMB_INTERNAL.VERIFY_QUALIFIED_STGTAB('ZZYZX')

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

      "ZZYZX".""

      

      SELECT dbms_smb_internal.verify_qualified_stgtab('UWCLASS.ZZYZX');

      

      DBMS_SMB_INTERNAL.VERIFY_QUALIFIED_STGTAB('ZZYZX')

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

      "UWCLASS"."ZZYZX"