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 |