Oracle | DBMS_FEATURE_USAGE

Oracle DBMS_FEATURE_USAGE_CLIENT Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

DBSNMP_BASELINE_ADAPTIVE

DBSNMP_BASELINE_COMPUTES

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.