<SPAN
class=075435103-13022002>Helmut,
<SPAN
class=075435103-13022002>
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.
<SPAN
class=075435103-13022002>
Best Regards,K GopalakrishnanBangalore,
INDIA
<FONT face=Tahoma
size=2>-----Original Message-----From: root_at_fatcity.com
[mailto:root_at_fatcity.com]On Behalf Of Daiminger, HelmutSent:
Tuesday, February 12, 2002 5:53 AMTo: Multiple recipients of list
ORACLE-LSubject: 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
Received on Tue Feb 12 2002 - 09:10:49 CST
