Oracle Database (DB) option usage tracking is a critical component of software asset management, particularly for organizations seeking to maintain compliance with Oracle licensing requirements. In FlexNet Manager Suite (FNMS) and IT Asset Management (ITAM), Oracle DB option usage is determined through a combination of feature usage data and metadata extracted from the Oracle system views.

This article explains how FlexNet Manager Suite and Flexera One IT Asset Management evaluate Oracle DB option usage based on the DBA_FEATURE_USAGE_STATISTICS view, with a specific focus on the role of MAX_LAST_SAMPLE_DATE in determining whether a DB option is flagged as used.

Key data points collected during Oracle DB inventory

FlexNet Manager Suite and Flexera One IT Asset Management collect Oracle DB inventory data using the FlexNet Agent. During this process, the following key data points are extracted:

• COL050: Indicates whether the feature has been used (TRUE or FALSE).
• COL080 (sample_date): The date when the feature usage was last sampled.
• MAX_LAST_SAMPLE_DATE: The most recent sample date across all features, retrieved from the Oracle DB instance.

If COL050 = 'TRUE' but COL080 (sample_date) does not match the MAX_LAST_SAMPLE_DATE value, then the DB option may not be flagged as used.

This behavior ensures that only the most recent and relevant feature usage data is considered, reducing the risk of false positives due to outdated or stale usage records.