Access APEX in Autonomous Database

Access Oracle APEX components from the OCI Console UI, or by directly signing in to Oracle APEX.

Tip:

To learn more about using Oracle APEX in Autonomous Database, see Creating Applications with Oracle Application Express on Autonomous Database in Using Oracle Autonomous Database Serverless.

Note:

Task instructions now use the Redwood Preview user interface. The Redwood Preview switch displays in the status bar at the bottom of the Browser window.

Navigate to the APEX Instances Page

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

Tip:

Before you can access an APEX instance, you must create an Autonomous Database. See Using Oracle Autonomous Database Serverless 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. Next to the Oracle Cloud logo, click the Navigation menu (Navigation menu) and select Developer Services and then APEX Instances.

    Tip:

    You can narrow the display using the Search and Filter field. For example, if a filter already exists, select it, make a new selection, and click Apply Filter.

    The APEX Instances page appears.

  3. Find your APEX instance. Click the three dots Actions menu (or Action menu) and select one of the following:
    • 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.

      Note:

      If you have not yet created a workspace, the Administration Services Sign In page appears. Follow the instructions in Set Up a New APEX Service.
    • Launch Database Actions - Oracle Database Actions provides development, data studio, administration and monitoring features for Oracle Autonomous Database. See About Database Actions in Using Oracle Database Actions.

    • View database details - Displays the Autonomous Details page. See Manage the Service in Using Oracle Autonomous Database Serverless.

    • 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).

    • Manage tags - Displays the Manage Tags page. 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.

  4. To access the APEX Instance Details page, do one of the following:
    • From the Row menu, click View Details.
    • Click the APEX Name.

    The APEX Instance Details page appears.

See Also:

About the APEX Instance Details Page

Use the APEX Instance Details page to view details about your service, sign in to your APEX instance, and manage other actions.

For Oracle APEX on Autonomous, the APEX Instance Details page displays slightly different information compared to APEX Service.

Controls on the top of the APEX Instance Details page include:

  • Actions:
    • Launch Database Actions - Oracle Database Actions provides development, data studio, administration and monitoring features for Oracle Autonomous Database. See About Database Actions in Using Oracle Database Actions.
    • Configure Database Generator - Configure the Document Generator pre-built function from the APEX Instance Details page. See Configure Document Generator.
    • View database details - Displays the Autonomous Details page. See Manage the Service in Using Oracle Autonomous Database Serverless.

    • Add Tags - Displays the Add Tags page. 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.

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

APEX instance information

The APEX instance information tab displays two regions:

  • General information:

    • OCID
    • Compartment
    • Created
    • APEX Version
    • ORDS Version
  • Instance Details:

    • Database NAME (link to database details page)
    • Database type: Transaction Processing
    • Database name
    • Instance type (Free or Paid)
    • ECPU count (or OCPU if your service uses OCPUs)
    • Storage
    • Storage auto scaling

Tip:

To learn more, see Access APEX Components and Manage Oracle APEX

Monitoring

The Monitoring region displays in a tab on the APEX Details page.



Control the display by clicking the following Applied filters: Interval and Statistic. Click Actions menu to access the following controls:

  • Hide/Show Legend
  • View Query in Metrics Explorer
  • Copy Chart URL
  • Copy Query (MQL)
  • Create an Alarm on this Query
  • Table View

Connections

Connections enable you to connect Data Transforms to various technologies reachable from your OCI network.

To learn more, see Work with Connections and Supported Connection Types in Using Oracle Autonomous Database Serverless.