Forum Stats

  • 3,757,045 Users
  • 2,251,189 Discussions
  • 7,869,702 Comments

Discussions

Looking for the Oracle LMS Collection Tool

4262449
4262449 Member Posts: 1

Hello,
I am looking for the Oracle LMS Collection Tool, a script to be run against an Oracle Database for licensing data collection.

Can anyone please tell me where I can download the script ?

Thank you and best regards

Answers

  • G R McHugh-Oracle
    G R McHugh-Oracle Member Posts: 9 Employee

    Hello,

    Please check the following article under MOS, there is a script that provides more info about the different features used.

    Database Options/Management Packs Usage Reporting for Oracle Databases 11gR2, 12c, 12cR2 and 18c (Doc ID 1317265.1)


    Sample:

    COLUMN name  FORMAT A60
    COLUMN detected_usages FORMAT 999999999999
    
    SELECT u1.name,
           u1.detected_usages,
           u1.currently_used,
           u1.version
    FROM   dba_feature_usage_statistics u1
    WHERE  u1.version = (SELECT MAX(u2.version)
                         FROM   dba_feature_usage_statistics u2
                         WHERE  u2.name = u1.name)
    AND    u1.detected_usages > 0
    AND    u1.dbid = (SELECT dbid FROM v$database)
    ORDER BY name;
    
    NAME                                                         DETECTED_USAGES CURRE VERSION
    ------------------------------------------------------------ --------------- ----- -----------------
    Adaptive Plans                                                             1 TRUE  12.1.0.2.0
    Automatic Maintenance - Optimizer Statistics Gathering                     1 TRUE  12.1.0.2.0
    Automatic Maintenance - SQL Tuning Advisor                                 1 TRUE  12.1.0.2.0
    Automatic Maintenance - Space Advisor                                      1 TRUE  12.1.0.2.0
    Automatic Reoptimization                                                   1 TRUE  12.1.0.2.0
    Automatic SGA Tuning                                                       1 TRUE  12.1.0.2.0
    Automatic SQL Execution Memory                                             1 TRUE  12.1.0.2.0
    Automatic Segment Space Management (system)                                1 TRUE  12.1.0.2.0
    Automatic Undo Management                                                  1 TRUE  12.1.0.2.0
    Backup Rollforward                                                         1 TRUE  12.1.0.2.0
    Backup and Restore of plugged database                                     1 TRUE  12.1.0.2.0
    
    NAME                                                         DETECTED_USAGES CURRE VERSION
    ------------------------------------------------------------ --------------- ----- -----------------
    Character Set                                                              1 TRUE  12.1.0.2.0
    Deferred Segment Creation                                                  1 TRUE  12.1.0.2.0
    Flashback Database                                                         1 TRUE  12.1.0.2.0
    Job Scheduler                                                              1 TRUE  12.1.0.2.0
    LOB                                                                        1 TRUE  12.1.0.2.0
    Locally Managed Tablespaces (system)                                       1 TRUE  12.1.0.2.0
    Locally Managed Tablespaces (user)                                         1 TRUE  12.1.0.2.0
    Logfile Multiplexing                                                       1 TRUE  12.1.0.2.0
    Oracle Java Virtual Machine (system)                                       1 TRUE  12.1.0.2.0
    Oracle Managed Files                                                       1 TRUE  12.1.0.2.0
    Oracle Multitenant                                                         2 TRUE  12.1.0.1.0
    
    NAME                                                         DETECTED_USAGES CURRE VERSION
    ------------------------------------------------------------ --------------- ----- -----------------
    Oracle Pluggable Databases                                                 1 TRUE  12.1.0.2.0
    Parallel SQL Query Execution                                               1 TRUE  12.1.0.2.0
    Partitioning (system)                                                      1 TRUE  12.1.0.2.0
    Recovery Area                                                              1 TRUE  12.1.0.2.0
    Result Cache                                                               1 TRUE  12.1.0.2.0
    SQL Plan Directive                                                         1 TRUE  12.1.0.2.0
    SecureFiles (system)                                                       1 TRUE  12.1.0.2.0
    SecureFiles (user)                                                         1 TRUE  12.1.0.2.0
    Server Parameter File                                                      1 TRUE  12.1.0.2.0
    Traditional Audit                                                          1 TRUE  12.1.0.2.0
    Unified Audit                                                              1 TRUE  12.1.0.2.0
    
    33 rows selected.