oracle audit / Oracle licensing

What is Oracle ReviewLite?

Oracle ReviewLite is a script within the Oracle LMS Collection Tool for auditing and certifying Oracle ULAs.

Its features include:

  • Purpose: Used by Oracle to audit customers and certify Oracle ULAs.
  • Scope: Covers only Oracle database products; different scripts are used for other Oracle software products.
  • Functionality: Measures static information like user count, database version, processor count, session information, and high watermarks.
  • Execution: This must be run wherever an Oracle database is installed, lacking discovery functionality.
  • Output: Generates various spool files, providing detailed information about database usage, versions, sessions, and product use.

What Is Oracle ReviewLite?

What Is Oracle ReviewLite?

Oracle ReviewLite is a script part of the Oracle LMS Collection Tool, the toolset Oracle uses to audit customers and certify Oracle ULAs.

Vendors who want to be verified by Oracle are given a copy of this script. The Script only covers Oracle database products. Different scripts are used for other Oracle software products.

ReviewLite is an SQL*Plus script that measures static information, including the number of users (declared in the database), the database version installed, the number of processors (generally the logical processors), the options used, session information, and high watermarks.

The script needs to be executed wherever an Oracle database is installed; it does not have a discovery functionality.

What Will the Oracle ReviewLite Script Generate When Used?

The script will generate eleven spool files upon running:

  • *_summary.csv
    Shows a summary of the server information and number of users for the database.
  • *_v_option.csv
    This displays the data from the v$OPTION view.
  • *_options.csv
    Used to determine which options are installed and being used in the database.
  • *_dba_feature.csv
    Used to determine which options are installed and used for versions 11g and above. Displays the data in the DBA_Feature_Usage_Statistics table.
  • *_parameter.csv
    Displays the value of the CPU_Count parameter for the database.
  • *_segments.csv
    Displays the partitions in the database and the owner of each. This is used to help determine if the customer is using partitioning. Refer to the Options query output for more information about partitioning.
  • *_users.csv
    Displays the number of named users created in the database and user details, including username, user_id, tablespace information, created date, and profile. Passwords are not collected.
  • *_version.csv
    Displays the version of the database.
  • *_license.csv
    Used to determine the high watermark in each database.
  • *_session.csv
    Used to determine all concurrent devices that accessed the database.
  • *_oraproducts.csv
    Used to detect usage of various Oracle products.

How Redress Compliance Can Help with Your Oracle Licensing Assessment Needs

Expert Oracle Licensing Support at Your Fingertips

  • Former Oracle License Auditors: Benefit from the insights of experienced professionals.
  • Comprehensive Services:
    • Accurate licensing reports.
    • Specialized advice on Oracle licensing topics.
  • Global Reach, Remote Delivery: Serving over 200 clients in 41 countries, all services are delivered remotely.
  • Schedule a Consultation: Discuss how we can support your organization with our tailored Oracle licensing solutions.

Ready to optimize your Oracle licensing strategy?

Contact us today.

Author

  • Fredrik Filipsson

    Fredrik Filipsson brings two decades of Oracle license management experience, including a nine-year tenure at Oracle and 11 years in Oracle license consulting. His expertise extends across leading IT corporations like IBM, enriching his profile with a broad spectrum of software and cloud projects. Filipsson's proficiency encompasses IBM, SAP, Microsoft, and Salesforce platforms, alongside significant involvement in Microsoft Copilot and AI initiatives, improving organizational efficiency.

    View all posts