RE: Fragmentation of data dictionary

[K Gopalakrishnan]

Title: Fragmentation of data dictionary

Helmut,

 

X$ tables are NEVER stored in the disk. THey are just memory structures in the SGA and the contents are zeroed (are reset) when you shutdown the database. THey will not cause data dictionary fragmentation.

 

 

Best Regards,
K Gopalakrishnan
Bangalore, INDIA

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daiminger, Helmut
Sent: Tuesday, February 12, 2002 5:53 AM
To: Multiple recipients of list ORACLE-L
Subject: Fragmentation of data dictionary

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