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 is now availble. If you haven't you downloaded already: Why?

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"