Oracle DBMS_FEATURE_USAGE_CLIENT
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Supporting package for DBMS_FEATURE_USAGE and the Feature Usage Report.
AUTHID DEFINER
Dependencies
DBMS_DBFUSC_LIB    
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.

Related Topics
Built-in Functions
Built-in Packages
DBMS_FEATURE_USAGE
DBMS_FEATURE_USAGE_INTERNAL
DBMS_FEATURE_USAGE_REPORT
Feature Usage Procedures
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx