| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Supporting package for DBMS_FEATURE_USAGE and the Feature Usage Report. |
| AUTHID |
DEFINER |
| Dependencies |
|
| Documented |
No |
| First Available |
19c |
| Security Model |
Owned by SYS with no privileges granted |
| Source |
{ORACLE_HOME}/rdbms/admin/prvsfusc.plb |
| Subprograms |
|
| |
| CALLOUT_TEST |
| Undocumented. The info parameter is just a random string to see what happens. |
dbms_feature_usage_client.callout_test(
FEATURE_BOOLEAN OUT NUMBER,
AUX_COUNT OUT NUMBER,
INFO IN OUT CLOB); |
DECLARE
ftbool NUMBER;
auxcnt NUMBER;
info CLOB := ' CALLOUT TEST';
BEGIN
dbms_feature_usage_client.callout_test(ftbool, auxcnt, info);
dbms_output.put_line(ftbool);
dbms_output.put_line(auxcnt);
dbms_output.put_line(info);
END;
/
1
93
kewfc callout test string
PL/SQL procedure successfully completed. |
| |
| DBSNMP_BASELINE_ADAPTIVE |
| Undocumented. The info parameter is just a random string to see what happens. |
dbms_feature_usage_client.dbsnmp_baesline_adaptive(
FEATURE_BOOLEAN OUT NUMBER,
AUX_COUNT OUT NUMBER,
INFO IN OUT CLOB); |
DECLARE
ftbool NUMBER;
auxcnt NUMBER;
info CLOB := 'ADAPTIVE QUERY';
BEGIN
dbms_feature_usage_client.dbsnmp_baseline_adaptive(ftbool, auxcnt, info);
dbms_output.put_line(ftbool);
dbms_output.put_line(auxcnt);
dbms_output.put_line(info);
END;
/
0
0
Adaptive: 0; Static:0
PL/SQL procedure successfully completed. |
| |
| DBSNMP_BASELINE_COMPUTES |
| Undocumented. The info parameter is just a random string to see what happens. |
dbms_feature_usage_client.dbsnmp_baseline_computes(
FEATURE_BOOLEAN OUT NUMBER,
AUX_COUNT OUT NUMBER,
INFO IN OUT CLOB); |
DECLARE
ftbool NUMBER;
auxcnt NUMBER;
info CLOB := ' SQL BASELINE';
BEGIN
dbms_feature_usage_client.dbsnmp_baseline_computes(ftbool, auxcnt, info);
dbms_output.put_line(ftbool);
dbms_output.put_line(auxcnt);
dbms_output.put_line(info);
END;
/
0
0
SQL BASELINE
PL/SQL procedure successfully completed. |