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