Get all feature usage statistics
get
/database/feature_usage/
See what features are used in the database. Returns records from DBA_FEATURE_USAGE_STATISTICS. A client requires SQL Administrator role to invoke this service.
Request
Supported Media Types
- application/json
Query Parameters
-
limit(optional): integer(int32)
The maximum number of records to return.
-
q(optional): string
Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.
Response
Supported Media Types
- application/json
200 Response
Feature Usage records from DBA_FEATURE_USAGE_STATISTICS.
Root Schema : DatabaseFeatureUsage
Type:
object
Title:
Show Source
DatabaseFeatureUsage
-
count(optional):
integer(int32)
Total number of records in the current response.
-
hasMore(optional):
boolean
Indicates if there are more records to be retrieved.
-
items(optional):
array items
-
limit(optional):
integer(int32)
The actual page size limit on number of records applied by the server.
-
links(optional):
array links
-
offset(optional):
integer(int32)
The actual index from which the item resources are returned.
Nested Schema : items
Type:
Show Source
array
-
Array of:
object DatabaseFeatureUsageItem
Title:
DatabaseFeatureUsageItem
Statistics on the usage in the database for an Oracle Database feature.
Nested Schema : DatabaseFeatureUsageItem
Type:
object
Title:
DatabaseFeatureUsageItem
Statistics on the usage in the database for an Oracle Database feature.
Show Source
-
aux_count(optional):
integer(int32)
This column stores feature-specific usage data in number format.
-
currently_used(optional):
string
Indicates whether usage was detected the last time the system checked (TRUE) or not (FALSE).
-
dbid(optional):
integer(int32)
Database identifier of the database being tracked.
-
description(optional):
string
Description of the feature and usage detection logic.
-
detected_usages(optional):
integer(int32)
Number of times the system has detected usage for the feature.
-
feature_info(optional):
string
This column stores feature-specific usage data in character format.
-
first_usage_date(optional):
string
First sample time the system detected usage of the feature.
-
last_sample_date(optional):
string
The last time the system checked for usage.
-
last_sample_period(optional):
integer(int32)
Amount of time (in seconds) between the last two usage sample times.
-
last_usage_date(optional):
string
Last sample time the system detected usage of the feature.
-
links(optional):
array links
-
name(optional):
string
Name of the feature.
-
sample_interval(optional):
integer(int32)
Sample interval.
-
total_samples(optional):
integer(int32)
Number of times the system has woken up and checked for feature usage.
-
version(optional):
string
Database version in which the feature was tracked.