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 126.96.36.199 and later
Information in this document applies to any platform.
On : 188.8.131.52 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 184.108.40.206 to higher versions.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!