Fragmentation of data dictionary

From: Daiminger, Helmut <Helmut.Daiminger_at_KirchGruppe.de>
Date: Tue, 12 Feb 2002 05:59:06 -0800
Message-ID: <F001.0040C7EC.20020212055320@fatcity.com>

Hi!

I was wondering whether the Oracle data dictionary gets fragmented and whether the dba needs to do something about it. E.g. if granting tons of rights through grants directly to a user (and later revoke them), does the data dictionary get fragmented (i.e. the x$ tables that hold that information)? Would it be beneficial to reorganise the dd (or at least rebuild the indexes)?

Same thing with creating tons of temporary tables that are created during a session and get dropped at the end of a session. Does this fragment the dd?

This is 8.1.7 on Sun Solaris.

Thanks,
Helmut Received on Tue Feb 12 2002 - 07:59:06 CST