Discussions
Categories
- 196K All Categories
- 2.1K Data
- 208 Big Data Appliance
- 1.9K Data Science
- 447.4K Databases
- 220.8K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 23 Multilingual Engine
- 516 MySQL Community Space
- 463 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 469 SQLcl
- 3.9K SQL Developer Data Modeler
- 185.9K SQL & PL/SQL
- 20.9K SQL Developer
- 292.6K Development
- 7 Developer Projects
- 124 Programming Languages
- 289.4K Development Tools
- 95 DevOps
- 3K QA/Testing
- 645.5K Java
- 23 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.8K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 15 Java Essentials
- 143 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 197 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 238 LiveLabs
- 35 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
Looking for the Oracle LMS Collection Tool
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
-
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.
