Connections Dropped Metrics

The ConnectionsDroppedByClient metric shows the sum of the number of connections dropped by the client. The ConnectionsDroppedByServer metric shows the sum of the number of connections dropped by the server.

See Available Metrics: oci_autonomous_database for more information.

Oracle APEX 24.2

Autonomous Database uses Oracle APEX Release 24.2.

See Create Applications with Oracle APEX in Autonomous Database for more information.

Data Studio Enhancements

The Data Studio is updated with new features and changes:

• The Table AI Assist Tool: The Data Studio suite of tools now features an AI-powered Table Assist Tool to effortlessly enhance your local data tables with the power of AI. You can use natural language prompts to augment and correct your information with this tool.

  See The Table AI Assist Tool for more information.

• Catalog Tool Enhancements: The new multi-catalog capabilities of the Autonomous Database catalog mean you can add catalogs to enable data search, discovery and use across a wide range of external systems, including other Autonomous Databases, on-premises databases, cloud storage systems, shared data, and other data catalogs such as Oracle Cloud Infrastructure Data Catalog and AWS Glue.

  See The Catalog Tool for more information.

• The Data Marketplace Tool: Using Data Studio Marketplace, Autonomous Database users can easily collaborate by sharing data with other users of the same or another Autonomous Database. Data providers publish data sets in just minutes, no coding required. Data consumers can browse available data sets, and query live data or copy it to their own Autonomous Database Instance.

  See The Data Marketplace Tool for more information.

• Data Load Livefeed Enhancements:

  • With the new Basic mode, creating a Livefeed is as simple as selecting a folder from a drop-down menu.
  • New ability to use Merge semantics in livefeeds. The Livefeed feature automatically updates existing data in your tables with new information, eliminating redundant rows and ensuring data integrity.

  • With newly introduced Show code icon, you can view the underlying SQL code behind your livefeeds and even run the code manually in the SQL worksheet.

  See Feeding Data for more information.

Documentation Addition: Migrate Existing SQL Execution Plans to Autonomous Database

You can use Real-time SQL Plan Management when you migrate from a source Oracle Database to Autonomous Database.

See Migrate Existing SQL Execution Plans to Autonomous Database to Mitigate the Risk of SQL Performance Regressions for more information.

Offload Queries from Elastic Pool Leader to Member Refreshable Clones

When you have heavy read workloads, where a relatively small amount of data is scanned by multiple queries, you can offload queries (reads) from an elastic pool leader to Refreshable Clones.

See Offload Queries from Elastic Pool Leader to Member Refreshable Clones for more information.

Create External Tables Over PAR URLs

You can create an external table over Pre-Authenticated Request (PAR) URLs.

See Query Data that Uses Pre-Authenticated Request (PAR) URL Source for more information.

Update Cloud Links Registrations

With Cloud Links, a data owner registers a table or view for remote access for a selected audience as defined by the data owner, and the data is then accessible to those with access granted at registration time. After you register a data set you can update data set attributes.

See Update Data Set Registration Attributes for more information.

Database User Password Warning Event: DatabaseUserPasswordWarning

The database user password warning event provides a message that the Autonomous Database user password is expiring within the specified grace period (default 30 days) or has already expired.

See Critical Events on Autonomous Database for more information.

Documentation Addition: Create and Use Custom Metrics

You can create custom metrics to collect, publish, and analyze metrics. A custom metric collects specified data from your Autonomous Database instance and publishes the data to the OCI Monitoring service using a REST API provided by the OCI SDK.

See Use Custom Metrics on Autonomous Database for more information.

Disconnect a Peer Database

You can disconnect an Autonomous Data Guard standby or a Backup-Based Disaster Recovery peer. When you disconnect a cross-region peer, the database is permanently disassociated from the Primary database. This converts the database from a peer database to a standalone database.

See Disconnect a Peer Database for more information.

Change Patch Level After Provisioning

When you provision or clone an Autonomous Database instance you can select a patch level to apply to upcoming patches. You can also change the patch level after an Autonomous Database instance is provisioned. There are two patch level options: Regular and Early.

See Set the Patch Level for more information.

Service Name Mapping for Cloud Links Consumers

You can set the service name mapping to use when Cloud Links consumers access data from a data set owner.

See Set Database Service Name Mapping for Cloud Links Consumers for more information.

External Tables with ORC, Parquet, and Avro Provide an Option to Set Size of String Columns

When you access ORC, Parquet, or Avro data stored in object store using external tables, you can either automatically or explicitly set the maximum size of text columns. By default the text column size is set based on the value of MAX_STRING_SIZE.

See Query External Data with ORC, Parquet, or Avro Source Files and Explicitly Set the Text Column Size for more information.

Invoke Google Cloud Platform Cloud Run Functions

You can invoke Google Cloud Platform Cloud Run functions as SQL functions.

See Steps to Invoke Google Cloud Run Functions as SQL Functions for more information.