| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Internal auto table cache utilities |
| AUTHID |
DEFINER |
| Dependencies |
| DBA_ROLE_PRIVS |
DBMS_CACHE |
| DBA_SCHEDULER_JOBS |
DBMS_SCHEDULER |
| DBA_SQLSET_PLANS |
DBMS_STANDARD |
| DBA_SQLSET_STATEMENTS |
EXTERNAL_TAB_CACHE$ |
| DBA_TABLES |
EXTERNAL_TAB_CACHE_USER_PROP$ |
| DBA_TS_QUOTAS |
OBJ$ |
| DBA_USERS |
USER$ |
|
| Documented |
No |
| First Available |
26ai |
| Security Model |
Owned by SYS with no privileges granted |
| Source |
None found |
| Subprograms |
|
| |
ENABLE_JOB (new 26ai)  |
| Undocumented |
dbms_cache_int.enable_job(
property_name IN VARCHAR2,
property_value IN NUMBER); |
| TBD |
| |
| ENSURE_DBA (new 26ai) |
| Undocumented |
dbms_cache_int.ensure_dba RETRN BOOLEAN; |
BEGIN
IF dbms_cache_int.ensure_dba THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/
ORA-00904: insufficient privileges to access object DBMS_CACHE_INT |
| |
| GET_GLOBAL_PROPERTY_NUM (new 26ai) |
| Undocumented |
dbms_cache_int.get_global_property_num(
property_name IN VARCHAR2,
is_set OUT BOOLEAN)
RETURN NUMBER; |
| TBD |
| |
| GET_GLOBAL_PROPERTY_STR (new 26ai) |
| Undocumented |
dbms_cache_int.get_global_property_str(
property_name IN VARCHAR2,
is_set OUT BOOLEAN)
RETURN VARCHAR2; |
| TBD |
| |
| GET_QUOTA (new 26ai) |
| Undocumented |
dbms_cache_int.get_quota(
owner_nq IN VARCHAR2,
tablespace_name IN VARCHAR2
curr_kb OUT NUMBER,
max_kb OUT NUMBER); |
| TBD |
| |
| LIST_HOT_TABLES (new 26ai) |
| Undocumented |
dbms_cache_int.list_hot_tables(owner_nq IN VARCHAR2) RETURN CLOB; |
SELECT dbms_cache_int.list_hot_tables(USER);
ORA-06553: PLS-904: insufficient privileges to access object DBMS_CACHE_INT |
| |
| MARK_AUTO (new 26ai) |
| Undocumented |
dbms_cache_int.mark_auto(
owner_nq IN VARCHAR2,
table_name_nq IN VARCHAR2); |
| TBD |
| |
| SET_GLOBAL_PROPERTY_NUM (new 26ai) |
| Undocumented |
dbms_cache_int.set_global_property_num(
property_name IN VARCHAR2,
property_value IN NUMBER); |
| TBD |
| |
| SET_GLOBAL_PROPERTY_STR (new 26ai) |
| Undocumented |
dbms_cache_int.set_global_property_str(
property_name IN VARCHAR2,
property_value IN VARCHAR2); |
| TBD |