CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_ODCI
Version 11.1
 
General
Note: DBMS_ODCI provides an estimate of of CPU instructions (in thousands) per unit of time in seconds
Source {ORACLE_HOME}/rdbms/admin/catodci.sql
First Available 9.0.1
Dependencies
DBMS_ASSERT IND$ PLITBLM
DBMS_I_INDEX_UTL OBJ$ SECOBJ$
DBMS_METADATA ODCIINDEXINFO SEM_INDEXTYPE_IM
DBMS_SQL ODCISECOBJ USER$
DBMS_SYS_SQL ODCISECOBJTABLE
 
CLEANUP (new in 11g)
Undocumented dbms_odci.estimate_cleanup(
ia          IN SYS.ODCIIndexInfo,
gtn_context IN NUMBER);
TBD
 
ESTIMATE_CPU_UNITS
Estimate instructions per second dbms_odci.estimate_cpu_units(elapsed_time IN NUMBER) RETURN NUMBER;
SELECT dbms_odci.estimate_cpu_units(1) * 1000
FROM dual;
 
GETMETADATA (new in 11g)
Undocumented dbms_odci.getmetadata(
ia          IN  SYS.ODCIIndexInfo,
exp_version IN  VARCHAR2,
idx_version IN  NUMBER DEFAULT 1,
stmt_string OUT VARCHAR2, 
new_block   OUT NUMBER);
TBD
 
GETTABLENAMES (new in 11g)
Undocumented dbms_odci.gettablenames(
ia          IN  SYS.ODCIIndexInfo,
read_only   IN  NUMBER,
exp_version IN  VARCHAR2,
idx_version IN  NUMBER,
stmt_string OUT VARCHAR2,
gtn_context OUT NUMBER,
status      OUT NUMBER);
TBD
 
RESTOREREFCURSOR
Undocumented PROCEDURE RestoreRefCursor(rc OUT SYS_REFCURSOR, curnum IN NUMBER)
IS LANGUAGE C
LIBRARY odci_extopt_lib
NAME "RestoreRefCursor"
WITH CONTEXT
PARAMETERS (CONTEXT, rc, curnum OCINumber, curnum INDICATOR);
TBD
 
SAVEREFCURSOR
Undocumented dbms_odci.SaveRefCursor(rc IN SYS_REFCURSOR, curnum OUT NUMBER)
IS LANGUAGE C
LIBRARY odci_extopt_lib
NAME "SaveRefCursor"
WITH CONTEXT
PARAMETERS (CONTEXT, rc, curnum OCINumber, curnum INDICATOR);
TBD
 
UPGRADE_SECOBJ
Undocumented dbms_odci.upgrade_secobj(objlist IN ODCISecObjTable);
TBD
 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [238 users online]    © 2010 psoug.org