Manage APEX Service

Stop APEX Service

Stop APEX Service by stopping the underlying Autonomous Database instance.

You can stop APEX Service from either the APEX Instances Details page or the Autonomous Database Details page.

To stop APEX Service and the underlying Autonomous Database instance:

Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
Next to the Oracle Cloud logo, click the Navigation menu ().
From the Oracle Cloud Infrastructure left navigation list, select Developer Services and then APEX Application Development or APEX Instances.
On the APEX Instances page, find and select your APEX Service.
The APEX Instance Details page appears.
You can stop APEX Service in two ways:
- On the APEX Instance Details page, click Stop.
- Navigate to the Autonomous Database Details page:
  - Under APEX instance information, click the Database name.
  - On the Autonomous Database details page, click the More actions drop-down list and select Stop.
Click Stop to confirm.

Note:

When an Autonomous Database instance is stopped:

Tools are no longer able to connect to a stopped instance.
Autonomous Database in-flight transactions and queries are stopped.
APEX Service CPU billing is halted.

Start APEX Service

Start APEX Service by starting the underlying Autonomous Database instance.

You can start APEX Service from either the APEX Instances Details page or the Autonomous Database details page. Start only displays for a stopped instance.

To start APEX Service and the underlying Autonomous Database instance:

Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
Next to the Oracle Cloud logo, click the Navigation menu ().
From the Oracle Cloud Infrastructure left navigation list, select Developer Services and then APEX Application Development or APEX Instances.
On the APEX Instances page, find and select your APEX Service.
The APEX Instance Details page appears.
You can start APEX Service in two ways:
- On the APEX Instance Details page, click Start.
- Navigate to the Autonomous Database details page:
  - Under APEX Instance Information, click the Database name.
    
    The Autonomous Database details page appears.
  - On the Autonomous Database details page, click the More Actions drop-down list and select Start.
Click Start to confirm.

Note:

When an Autonomous Database instance is started, APEX Service CPU billing is initiated, billed by the second with a minimum usage period of one minute.

Restart APEX Service

Restart APEX Service by restarting the underlying Autonomous Database instance.

You can restart APEX Service from either the APEX Instances Details page or the Autonomous Database details page.

To restart APEX Service and the underlying Autonomous Database instance:

Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
Next to the Oracle Cloud logo, click the Navigation menu ().
From the Oracle Cloud Infrastructure left navigation list, select Developer Services and then APEX Application Development or APEX Instances.
The APEX Instances page appears.
Find and select your APEX Service.
The APEX Instance Details page appears.
You can restart APEX Service in two ways:
- On the APEX Instance Details page, click Restart.
- Navigate to the Autonomous Database details page:
  - Under APEX Instance Information, click the Database name.
  - On the Autonomous Database details page, click the More Actions drop-down list and select Restart.
Click Restart to confirm.

Note:

When an Autonomous Database instance is restarted, APEX Service CPU billing is initiated, billed by the second with a minimum usage period of one minute.

About Auto Scaling

When you create an Autonomous Database instance, by default compute auto scaling is enabled and storage auto scaling is disabled. You can manage auto scaling from the Oracle Cloud Infrastructure Console to enable or disable compute auto scaling or storage auto scaling.

With compute auto scaling enabled the database can use up to three times more CPU and IO resources than specified by the number of ECPUs (OCPUs if your database uses OCPUs) as shown in the ECPU count or OCPU count field on the Oracle Cloud Infrastructure Console.

When you create an Autonomous Database instance, by default Storage auto scaling is disabled. When Storage auto scaling is enabled, the Autonomous Database can expand to use up to three times the reserved base storage, as specified by the storage shown in the Storage field on the Oracle Cloud Infrastructure Console. If you need additional storage, the database automatically uses the reserved storage without any manual intervention required.

To learm more, see Use Auto Scaling in Using Oracle Autonomous Database Serverless.

Tip:

View historical CPU utilization for a service on the CPU utilization (%) chart on the Database Monitor, Overview tab in Database Actions. To learn more, see Database Dashboard Page in Using Oracle Database Actions.

Modify CPU Count, Storage Resources, or Auto Scaling

Scale your Autonomous Database on demand by modifying ECPU count (or OCPU count), storage, or manage auto scaling.

To scale your database, modify ECPU count (or OCPU count), storage, or enable/disable auto scaling:

Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
Next to the Oracle Cloud logo, click the Navigation menu ().
From the Oracle Cloud Infrastructure left navigation list, select Developer Services and then APEX Application Development or APEX Instances.
On the APEX Instances page, find and select your APEX Service.
The APEX Instance Details page appears.
You can access the Scale dialog in two ways:
- On the APEX Instance Details page:
  - From the More Actions drop-down list, select Scale.
    
    The Scale dialog appears.
    
    Description of the illustration scale.png
  - ECPU count - The number of ECPUs (or OCPUs if your service uses OCPUs) to enable. The default is no change.
  - Storage - Specify the amount of storage you wish to make available to your database. The default is no change.
  - Storage unit size - Specify the storage to allocate in storage size units (GB or TB).
  - Compute auto scaling - Enabling Compute auto scaling allows the system to use up to three times the number of ECPUs (OCPUs if your database uses OCPUs) for processing workload if required.
  - Storage auto scaling - Allows the system to expand up to three times the reserved storage.
  - Click Save Changes.
- Navigate to the Autonomous Database details page:
  - Under APEX instance information, click the Database name.
  - On the Autonomous Database Details click Manage resource allocation.
    
    The Manage resource allocation dialog appears.
    
    Description of the illustration manage_resource_allocation.png
  - ECPU count - The number of ECPUs (or OCPUs if your service uses OCPUs) to enable. The default is no change.
  - Compute auto scaling - Enabling Compute auto scaling allows the system to use up to three times the number of ECPUs (OCPUs if your database uses OCPUs) for processing workload if required.
  - Storage - Specify the amount of storage you wish to make available to your database. The default is no change.
  - Storage unit size - Specify the storage to allocate in storage size units (GB or TB).
  - Storage auto scaling - Allows the system to expand up to three times the reserved storage.
  - Allocated storage - Displays the current allocated storage.
  - Shrink - Shrinks storage manually. Use after deletion of a significant amount of data. See Shrink Storage in Using Oracle Autonomous Database Serverless.
  - Click Apply.

Changing ECPU count (OCPU count if your service uses OCPUs), Storage, or enabling or disabling auto scaling options, changes the Lifecycle State to Scaling in Progress. After the Lifecycle State changes to Available the changes apply immediately.

Note:

If auto scaling is disabled while more CPUs are in use than the specified ECPU count (or OCPU count), then Autonomous Database scales the number in use down to the ECPU count (or OCPU count) number.

Terminate APEX Service

Terminate APEX Service by terminating the underlying Autonomous Database instance.

You can terminate APEX Service from either the APEX Instances Details page or the Autonomous Database Details page:

Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
Next to the Oracle Cloud logo, click the Navigation menu ().
From the Oracle Cloud Infrastructure left navigation list, select Developer Services and then APEX Application Development or APEX Instances.
On the APEX Instances page, find and select your APEX Service.
The APEX Instance Details page appears.
You can terminate APEX Service in two ways:
- On the APEX Instance Details page:
  - From the More Actions drop-down list, select, select Terminate.
  - On the Terminate APEX Instance page, enter the APEX instance name to confirm the termination and click Terminate.
- Navigate to the Autonomous Database details page:
  - Under APEX Instance Information, click the Database name.
  - On the Autonomous Database details, click the the More Actions drop-down list and select Terminate.
  - On the Terminate Autonomous Database page, enter the database name to confirm the termination and click Terminate Autonomous Database.

Move Resource to a Different Compartment

Move an APEX Service to a different compartment from either the APEX Instances page or APEX Instance Details page.

Compartments help you organize resources to make it easier to control access to them. Moving an APEX Service instance to another compartment also moves the underlying database resource. See Understanding Compartments for information on using and managing compartments.

Note:

To move a database you must have the right to manage Autonomous Databases in the database's current compartment and in the compartment you are moving it to.

As soon as you move a database to a different compartment, the policies that govern the new compartment apply immediately and affect access to the database. Therefore, your access to the database may change, depending on the policies governing your Oracle Cloud user account's access to resources.

To move an APEX Service to a different compartment:

Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
Next to the Oracle Cloud logo, click the Navigation menu ().
From the Oracle Cloud Infrastructure left navigation list, select Developer Services and then APEX Application Development or APEX Instances.
You can move a resource to a different compartment in two ways:
- On the APEX Instances page:
  - Find your APEX Service instance.
  - Click the three dots (or Row menu) and select Move resource.
- On the APEX Instance Details page:
  - On the APEX Instances page, find and select your APEX Service.
  - From the More Actions drop-down list, select, select Move resource.
The Move resource dialog appears.
Choose a new compartment and click Move resource.

Update to ECPU Billing Model for APEX Service

Learn about updating an existing APEX Service instance to the ECPU compute model.

APEX Service offers two compute models when you create a new instance: ECPU and OCPU. Oracle recommends the ECPU compute model for the best price performance over time.

Note:

If you update to use the ECPU compute model, you cannot revert back to the OCPU compute model. To learn more, see Compute Models in Autonomous Database and Update to ECPU Billing Model on Autonomous Databasel in Using Oracle Autonomous Database Serverless.

To update from a OCPU billing model to a ECPU billing model:

Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
Next to the Oracle Cloud logo, click the Navigation menu ().
From the Oracle Cloud Infrastructure left navigation list, select Developer Services and then APEX Application Development or APEX Instances.
On the APEX Instances page, find and select your APEX Service.
The APEX Instance Details page appears.
Navigate to the Autonomous Database details page:
1. Under APEX Instance Information, click the Database name.
  Autonomous Database Details page appears.
2. Under Resource allocation, OCPU count, click Update to ECPU model.
Follow the instructions in Update Billing Model Autonomous Database to ECPU Compute Model in Using Oracle Autonomous Database Serverless.

Learn More About Autonomous Database Lifecycle Operations

Learn more about Autonomous Database instance lifecycle operations in Using Oracle Autonomous Database Serverless.

See Lifecycle Operations in Using Oracle Autonomous Database Serverless.