Executing Statements and Scripts in the Background

The SQL Worksheet supports background execution for long-running SQL statements and scripts. Background executions run asynchronously, allowing you to continue working while the execution completes.

By default:

• Run Statement and Run Script execute synchronously.
• Run in Background and Run Script in Background execute asynchronously.

Background execution results are stored in Oracle Cloud Infrastructure (OCI) Object Storage and can be monitored from the Background Executions tab in the output pane.

Topics:

• Prerequisites
• Set Background Execution Preferences
• Run a Statement or Script in the Background
• Monitor Background Executions
• Background Execution Output