Database Tuning (MOSC)

MOSC Banner

slow queries against dba_data_files after dropping some datafiles

edited Dec 1, 2009 7:59AM in Database Tuning (MOSC) 8 commentsAnswered
 Our production database has many, many datafiles, over 40,000.  Queries such as "select file_name from dba_data_files where tablespace_name = 'DATA_1;" formally executed in 30 seconds to 1 minute.  We have sinced dropped about 1170 datafiles, and now such queries take almost 15 minutes.  Since we had also added memory/CPU to the database server, I gathered system statistics, but this made no difference to the execution time of this query.  This is of very much concern, because we are fairly soon going to be dropping another 2500 datafiles.  Do I need to gather fixed object statistics?  If so, when should it

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