Get usage statistic for a feature
get
/database/feature_usage/{dbid},{name}
Returns records from DBA_FEATURE_USAGE_STATISTICS for a specific feature. A client requires SQL Administrator role to invoke this service.
Request
Path Parameters
-
dbid(required): number
Database identifier as found in GV$DATABASE.
-
name(required): string
Name of the feature.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
Information on the usage statistics for a specific feature.
Root Schema : DatabaseFeatureUsageItem
Type:
object
Statistics on the usage in the database for an Oracle Database feature.
Show Source
-
aux_count: integer
This column stores feature-specific usage data in number format.
-
currently_used: string
Indicates whether usage was detected the last time the system checked (TRUE) or not (FALSE).
-
dbid: integer
Database identifier of the database being tracked.
-
description: string
Description of the feature and usage detection logic.
-
detected_usages: integer
Number of times the system has detected usage for the feature.
-
feature_info: string
This column stores feature-specific usage data in character format.
-
first_usage_date: string
First sample time the system detected usage of the feature.
-
last_sample_date: string
The last time the system checked for usage.
-
last_sample_period: integer
Amount of time (in seconds) between the last two usage sample times.
-
last_usage_date: string
Last sample time the system detected usage of the feature.
-
links: array
links
-
name: string
Name of the feature.
-
sample_interval: integer
Sample interval.
-
total_samples: integer
Number of times the system has woken up and checked for feature usage.
-
version: string
Database version in which the feature was tracked.