| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Automatic Table Cache utilities. |
| AUTHID |
DEFINER |
| Dependencies |
| ALL_EXTERNAL_TAB_CACHES |
DBMS_OUTPUT |
| ALL_EXTERNAL_TAB_CACHE_LOCATIONS |
DBMS_SQL |
| ALL_USERS |
DBMS_STANDARD |
| DBA_EXTERNAL_TAB_CACHES |
DBMS_SYS_SQL |
| DBA_SQLSET_PLANS |
DBMS_UTILITY |
| DBA_TABLES |
EXTERNAL_TAB_CACHE_USER_PROP$ |
| DBMS_ASSERT |
JSON_ARRAY_T |
| DBMS_CACHE_INT |
JSON_ELEMENT_T |
| DBMS_EXT_TABLE_CACHE |
JSON_OBJECT_T |
|
| Documented |
No |
| First Available |
26ai |
| Pragma |
PRAGMA SUPPLEMENTAL_LOG_DATA(DEFAULT, NONE); |
| Security Model |
Owned by SYS with EXECUTE granted to PUBLIC |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsautotc.sql |
| Subprograms |
|
| |
CLEAR (new 26ai)  |
| Undocumented |
dbms_cache.clear(owner IN VARCHAR2); /* owner of external tables */ |
exec dbms_cache.clear(USER);
PL/SQL procedure successfully completed. |
| |
| GET_GLOBAL_PROPERTY (new 26ai) |
Undocumented
Overload 1 |
dbms_cache.get_global_property(
property_name IN VARCHAR2,
property_value_num OUT NUMBER); |
| TBD |
| Overload 2 |
dbms_cache.get_global_property(
property_name IN VARCHAR2,
property_value_str OUT VARCHAR2); |
| TBD |
| |
| GET_USER_PROPERTY (new 26ai) |
Undocumented
Overload 1 |
dbms_cache.get_user_property(
property_name IN VARCHAR2,
owner IN VARCHAR2 DEFAULT NULL,
property_value_num OUT NUMBER); |
| TBD |
| Overload 2 |
dbms_cache.get_user_property(
property_name IN VARCHAR2,
owner IN VARCHAR2 DEFAULT NULL,
property_value_str OUT VARCHAR2); |
| TBD |
| |
| REFRESH (new 26ai) |
| Undocumented |
dbms_cache.refresh(
owner IN VARCHAR2, /* owner of external tables */
refresh_type IN VARCHAR2 DEFAULT NULL); |
| TBD |
| |
| REFRESH_WORK (new 26ai) |
| Undocumented |
dbms_cache.refresh_work(spare IN NUMBER DEFAULT 0); |
-- from $ORACLE_HOME/rdbms/admin/execcache.sql
IF cnt > 0 THEN
dbms_scheduler.set_attribute(jobname,'repeat_interval','FREQ=MINUTELY; INTERVAL=5');
RETURN;
END IF;
dbms_scheduler.create_job(job_name => jobname,
job_type => 'STORED_PROCEDURE',
job_action => jobowner || '.dbms_cache.refresh_work',
job_class => 'DEFAULT_JOB_CLASS',
start_date => SYSTIMESTAMP,
repeat_interval => 'FREQ=MINUTELY; INTERVAL=5',
end_date => NULL,
auto_drop => FALSE,
enabled => FALSE,
comments => 'system job for managing table caches');
END;
/ |
| |
| SET_GLOBAL_PROPERTY (new 26ai) |
Undocumented
Overload 1 |
dbms_cache.set_global_property(
property_name IN VARCHAR2,
property_value_num IN NUMBER); |
| TBD |
| Overload 2 |
dbms_cache.set_global_property(
property_name IN VARCHAR2,
property_value_str IN VARCHAR2); |
| TBD |
| |
| SET_USER_PROPERTY (new 26ai) |
Undocumented
Overload 1 |
dbms_cache.set_user_property(
property_name IN VARCHAR2,
property_value_num IN NUMBER,
owner IN VARCHAR2 DEFAULT NULL); |
| TBD |
| Overload 2 |
dbms_cache.set_user_property(
property_name IN VARCHAR2,
property_value_str IN VARCHAR2,
owner IN VARCHAR2 DEFAULT NULL); |
| TBD |