My Oracle Support Banner

CDB_* Views Queries run in Parallel in 19C Which Were Running In Serial In 12c (Doc ID 2818448.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.10.0.0.0 and later
Information in this document applies to any platform.

Symptoms

In 12C, CDB_VIEWS queries run in serial. In 19C, parallel is the default.

Example:

 

SELECT pdb.name, m.tablespace_name, ROUND(m.used_percent, 2),
ROUND((m.tablespace_size - m.used_space)*t.block_size/1024/1024, 3) mb_free
FROM cdb_tablespace_usage_metrics m, cdb_tablespaces t, v$parameter p,
(SELECT con_id, name FROM v$containers) pdb WHERE p.name = 'statistics_level'
AND p.value != 'BASIC' AND t.contents = 'UNDO' AND t.tablespace_name =
m.tablespace_name AND m.con_id = t.con_id AND m.con_id = pdb.con_id;

Changes

 Upgrade to 19C

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.