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