SQL Performance (MOSC)

MOSC Banner

DBA_OBJECTS slow in PDB only

edited Dec 19, 2024 10:32AM in SQL Performance (MOSC) 4 commentsAnswered

DB is 19.25 on Linux 8

What we see is that a simple count of objects of DBA_OBJECTS in Root's container takes max. 1 second, but it takes 5 minutes in a PDB

Granted there are more objects in the PDB but the timing difference is of a total different order

select count(*) from dba_objects ;

What can explain such differences ? We see this extreme behaviour in one database only, other databases are not that slow, but just slow as well.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center