Jump to

• Request
• Response

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

Query Parameters

• limit: integer(int32)
  The maximum number of records to return.
• q:
  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.

  Examples

  Select an example FilterCriteriaExample OrderByPropertyExample FilterAndOrderExample

There's no request body for this operation.

Back to Top

Response

Supported Media Types

• application/json

200 Response

Feature Usage records from DBA_FEATURE_USAGE_STATISTICS.

Body ()

Root Schema : DatabaseFeatureUsage

Type: object

Show Source

• count: integer
  Total number of records in the current response.
• hasMore: boolean
  Indicates if there are more records to be retrieved.
• items: array items
• limit: integer
  The actual page size limit on number of records applied by the server.
• links: array links
• offset: integer
  The actual index from which the item resources are returned.

{
    "type":"object",
    "properties":{
        "items":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/DatabaseFeatureUsageItem"
            }
        },
        "hasMore":{
            "type":"boolean",
            "description":"Indicates if there are more records to be retrieved."
        },
        "limit":{
            "type":"integer",
            "description":"The actual page size limit on number of records applied by the server."
        },
        "offset":{
            "type":"integer",
            "description":"The actual index from which the item resources are returned."
        },
        "count":{
            "type":"integer",
            "description":"Total number of records in the current response."
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/LinkRelation"
            }
        }
    }
}

Nested Schema : items

Type: array

Show Source

• Array of: object DatabaseFeatureUsageItem
  Statistics on the usage in the database for an Oracle Database feature.

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/DatabaseFeatureUsageItem"
    }
}

Nested Schema : links

Type: array

Show Source

• Array of: object LinkRelation

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/LinkRelation"
    }
}

Nested 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.

{
    "type":"object",
    "description":"Statistics on the usage in the database for an Oracle Database feature.",
    "properties":{
        "dbid":{
            "type":"integer",
            "description":"Database identifier of the database being tracked."
        },
        "name":{
            "type":"string",
            "description":"Name of the feature."
        },
        "version":{
            "type":"string",
            "description":"Database version in which the feature was tracked."
        },
        "detected_usages":{
            "type":"integer",
            "description":"Number of times the system has detected usage for the feature."
        },
        "total_samples":{
            "type":"integer",
            "description":"Number of times the system has woken up and checked for feature usage."
        },
        "currently_used":{
            "type":"string",
            "description":"Indicates whether usage was detected the last time the system checked (TRUE) or not (FALSE)."
        },
        "first_usage_date":{
            "type":"string",
            "description":"First sample time the system detected usage of the feature."
        },
        "last_usage_date":{
            "type":"string",
            "description":"Last sample time the system detected usage of the feature."
        },
        "aux_count":{
            "type":"integer",
            "description":"This column stores feature-specific usage data in number format."
        },
        "feature_info":{
            "type":"string",
            "description":"This column stores feature-specific usage data in character format."
        },
        "last_sample_date":{
            "type":"string",
            "description":"The last time the system checked for usage."
        },
        "last_sample_period":{
            "type":"integer",
            "description":"Amount of time (in seconds) between the last two usage sample times."
        },
        "sample_interval":{
            "type":"integer",
            "description":"Sample interval."
        },
        "description":{
            "type":"string",
            "description":"Description of the feature and usage detection logic."
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/LinkRelation"
            }
        }
    }
}

Nested Schema : links

Type: array

Show Source

• Array of: object LinkRelation

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/LinkRelation"
    }
}

Nested Schema : LinkRelation

Type: object

Show Source

• href(required): string
• rel(required): string

{
    "type":"object",
    "properties":{
        "rel":{
            "type":"string"
        },
        "href":{
            "type":"string"
        }
    },
    "required":[
        "rel",
        "href"
    ]
}

Back to Top