Access APEX Service from the OCI Console UI

Access an APEX Service from the OCI Console UI for APEX Instances.

Navigate to the APEX Instances Page

Navigate to the APEX Instances page to view details about and access APEX Service components.

Tip:

Before you can access an APEX Service, you must create an APEX Service instance and then create a workspace and workspace administrator account. See Create and Set Up an APEX Service Instance for more information.

To navigate to the APEX Instances page:

  1. Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
  2. In the upper left corner next to the Oracle Cloud logo, click the Navigation Icon.
  3. From the Oracle Cloud Infrastructure left navigation list, select Developer Services and then APEX Application Development or APEX Instances.
    The APEX Instances page appears.
  4. Under Filters, narrow the display by selecting APEX from the Type list.
  5. Find your APEX Service instance. Click the three dots Row menu (or Row menu) and select one of the following:
    • View Details
    • Launch APEX
    • Launch Database Actions
    • Stop or Start
    • Restart
    • Move Resource
    • Copy OCID
    • Add Tags
    • View Tags
    • Terminate
  6. To access the APEX Instance Details page, do one of the following:
    • From the Row menu, click View Details.

    • Click the APEX Service name.

    The APEX Instance Details page appears.

  7. On the APEX Instance Details page, click one of the following:
    • Launch APEX
    • Launch Database Actions
    • Stop or Start
    • Restart
    • More Actions

See Also:

About the APEX Instances Page

Use the APEX Instances page to create a new APEX Service, or click the Row menu to select APEX Details, Launch APEX or Launch Database Actions.

Description of apex_instances_page.png follows

Click Create APEX service to create a new APEX Service instance. The following information displays for each APEX Service:

  • Name (link to APEX Instance Details)

  • State (Database)

  • Type (APEX)

  • Database name

  • OCPUs

  • Storage

  • Created (day, date, and time)

Clicking the three dots Row menu (or Row menu) on the right side page displays the following options:
  • View Details - Displays the APEX Instance Details page.

  • Launch APEX - Displays the Oracle APEX Sign In page. Enter your workspace administrator credentials and click Sign In.

  • Launch Database Actions - Access Oracle Database Actions (formerly Oracle SQL Developer Web) to execute queries and scripts, create database objects, load data, build data models, and monitor database performance. See About Database Actions in Using Oracle Database Actions.

  • Stop or Start. The option that displays depends upon the current state of the APEX Service instance. See Stop APEX Service and Start APEX Service.

  • Restart. Restart APEX Service by restarting the underlying Autonomous Database instance. See Restart APEX Service.

  • Move Resource. See Move Resource to a Different Compartment.

  • Copy OCID - Copy the Oracle Cloud Identifier (OCID). Most Oracle Cloud Infrastructure resources have an Oracle-assigned unique ID called an Oracle Cloud Identifier (OCID). It's included as part of the resource's information in both the Console and API. See Oracle Cloud IDs (OCIDs).

  • Add Tags - Add new tags Tagging is a metadata system that allows you to organize and track resources within your tenancy. Tags are composed of keys and values that can be attached to resources.

  • View Tags - View existing tags.

  • Terminate - Terminate APEX Service by terminating the underlying Autonomous Database instance. See Terminate APEX Service.

About the APEX Instance Details Page

Use the APEX Instance Details page to view details about your service, sign in to your APEX Service instance, access Database Actions, or stop or restart APEX Service.

Description of apex_details_top.png follows

The top of the pages features the following buttons:

  • Launch APEX - Displays the Oracle APEX Sign In page. On the Sign In page, enter your workspace administrator credentials and click Sign In.

  • Launch Database Actions - Access Oracle Database Actions (formerly Oracle SQL Developer Web) to execute queries and scripts, create database objects, load data, build data models, and monitor database performance. See About Database Actions in Using Oracle Database Actions.

  • Stop or Start. The button that displays depends upon the current state of the APEX Service instance. See Stop APEX Service and Start APEX Service.

  • Restart. Restart APEX Service by restarting the underlying Autonomous Database instance. See Restart APEX Service.

  • More Actions. The More Actions drop down list contains the following options: Upgrade Instance to Paid, Scale, Move Resource, Add Tags, and Terminate.

The APEX Instance Information tab displays the following information:

  • OCID

  • Compartment

  • Created

  • ORDS Version

  • Database Name (link to database details page)

  • Database type: APEX

  • Database name

  • Instance type (Free or Paid)

  • OCPU

  • Storage

  • Auto scaling

  • Storage auto scaling

Tip:

To learn more about using these controls, see Access APEX Service Components and Manage APEX Service

Metrics

The Metrics region displays at the bottom of the APEX Details page.

Description of apex_details_metrics.png follows

Control the display by clicking the following controls: Start time, End time, and Quick Selects. Displayed metrics include APEX Page Events and Active APEX Applications. Click Options to access the following controls:

  • View Query in Metrics Explorer

  • Copy Chart URL

  • Copy Query (MQL)

  • Create an Alarm on this Query

  • Table View