Jump to

• Request
• Response

Get application statistics

get

/apex/statistics/application/{application_id}/

This service returns usage statistics for a specific Oracle APEX application. A client requires SQL Administrator role to invoke this service.

Request

Path Parameters

• application_id(required): string
  Identifier of the application.

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

All Oracle APEX application usage statistics.

Body ()

Root Schema : APEXUsageStatistics

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/APEXUsageStatisticsItem"
            }
        },
        "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 APEXUsageStatisticsItem
  This object represents a APEX_WORKSPACE_LOG_ARCHIVE record of page view activity. Page view activity is a daily summary of workspace activity that is retained until physically purged.

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

Nested Schema : links

Type: array

Show Source

• Array of: object LinkRelation

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

Nested Schema : APEXUsageStatisticsItem

Type: object

This object represents a APEX_WORKSPACE_LOG_ARCHIVE record of page view activity. Page view activity is a daily summary of workspace activity that is retained until physically purged.

Show Source

• application_id: integer
  Application ID for which this page view log was recorded.
• application_name: string
  Application Name for which this page view log was recorded.
• average_render_time: number
  Summarized information by day, application and workspace.
• builder_events: integer
  TBD
• distinct_pages: integer
  Summarized information by day, application and workspace of the number of distinct pages used.
• distinct_sessions: integer
  Summarized information by day, application and workspace of the number of distinct sessions.
• distinct_users: integer
  Summarized information by day, application and workspace of the number of distinct users.
• error_count: integer
  Summarized information by day, application and workspace of the number of errors.
• links: array links
• log_day: string
  Total not null interactive report search values logged to the activity log.
• maximum_render_time: number
  Summarized information by day, application and workspace indicating maximum render time.
• median_render_time: number
  Summarized information by day, application and workspace indicating median render time.
• page_events: integer
  Total number of page events logged for a given day, application and workspace.
• public_page_events: integer
  Total public page events for a given day, application and workspace.
• total_render_time: number
  Summarized information by day, application and workspace indicating total render time.
• workspace_id: integer
  Identifies workspace.
• workspace_login_events: integer
  Total workspace login events by day, application and workspace.

{
    "type":"object",
    "description":"This object represents a APEX_WORKSPACE_LOG_ARCHIVE record of page view activity. Page view activity is a daily summary of workspace activity that is retained until physically purged.",
    "properties":{
        "application_id":{
            "type":"integer",
            "description":"Application ID for which this page view log was recorded."
        },
        "application_name":{
            "type":"string",
            "description":"Application Name for which this page view log was recorded."
        },
        "average_render_time":{
            "type":"number",
            "description":"Summarized information by day, application  and workspace."
        },
        "builder_events":{
            "type":"integer",
            "description":"TBD"
        },
        "distinct_pages":{
            "type":"integer",
            "description":"Summarized information by day, application and workspace of the number of distinct pages used."
        },
        "distinct_sessions":{
            "type":"integer",
            "description":"Summarized information by day, application and workspace of the number of distinct sessions."
        },
        "distinct_users":{
            "type":"integer",
            "description":"Summarized information by day, application and workspace of the number of distinct users."
        },
        "error_count":{
            "type":"integer",
            "description":"Summarized information by day, application and workspace of the number of errors."
        },
        "log_day":{
            "type":"string",
            "description":"Total not null interactive report search values logged to the activity log."
        },
        "maximum_render_time":{
            "type":"number",
            "description":"Summarized information by day, application and workspace indicating maximum render time."
        },
        "median_render_time":{
            "type":"number",
            "description":"Summarized information by day, application and workspace indicating median render time."
        },
        "page_events":{
            "type":"integer",
            "description":"Total number of page events logged for a given day, application and workspace."
        },
        "public_page_events":{
            "type":"integer",
            "description":"Total public page events for a given day, application and workspace."
        },
        "total_render_time":{
            "type":"number",
            "description":"Summarized information by day, application and workspace indicating total render time."
        },
        "workspace_id":{
            "type":"integer",
            "description":"Identifies workspace."
        },
        "workspace_login_events":{
            "type":"integer",
            "description":"Total workspace login events by day, application and workspace."
        },
        "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