select from DBA_TYPE_ATTRS view running slow
(Doc ID 2679559.1)
Last updated on AUGUST 11, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
On : 11.2.0.4 version,
The internal Oracle sql never finishes
SELECT LENGTH FROM DBA_TYPE_ATTRS WHERE TYPE_NAME='KU$_SCHEMAOBJ_T' AND ATTR_NAME='TYPE_NAME'
This slowness can affect the upgrade process from 11.2.0.4 to higher versions.
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! |