| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Internal support package for DBM_SQLHIST. |
| AUTHID |
DEFINER |
| Dependencies |
| DBMS_SQLHIST |
ODCIVARCHAR2LIST |
X$KESMASMON |
|
| Documented |
No |
| First Available |
23ai |
| Pragmas |
PRAGMA SUPPLEMENTAL_LOG_DATA(default, READ_ONLY); |
| Security Model |
Owned by SYS with no privileges granted |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmssqlh.sql
{ORACLE_HOME}/rdbms/admin/prvtsqlh.plb |
| Subprograms |
|
| |
I_GET_FILTERED_SQLIDS (new 23ai)  |
| Finds SQL IDs for SQL history statements that contain a given SQL text string |
dbms_sqlhist_internal.i_get_filtered_sqlids(
sqltext_filter IN VARCHAR2,
container_id IN NUMBER,
instance_id IN NUMBER)
RETURN sys.odcivarchar2list; |
| TBD |