| 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 |
