, Agosto 8, 2001 11:21 am
Asunto: Table Fragmentation - Please Help - Urgent
Hello All,
Please help in sending me a script for getting to know whether a
table is fragmented or not? Also need to know whether I will need
to Analyse the table for getting accurate results, and if yes how
to do
Hello All,
Please help in sending me a script for getting to know whether a table is fragmented
or not? Also need to know whether I will need to Analyse the table for getting
accurate results, and if yes how to do that?
Thanks
raja
Get 250 color business cards for FREE!
SELECT
SEGMENT_NAME,
SEGMENT_TYPE,
BYTES/1024/1024 Kbytes,
EXTENTS
FROM
DBA_SEGMENTS
/
- Mensaje original -
De: Viraj Luthra [EMAIL PROTECTED]
Fecha: MiƩrcoles, Agosto 8, 2001 11:21 am
Asunto: Table Fragmentation - Please Help - Urgent
Hello All
Title: RE: Table fragmentation
See All About Oracle Database Fragmentation by Craig A. Shallahamer at www.orapub.com. Click on RESEARCH/PAPERS and enjoy the bounty.
-Original Message-
From: Viraj Luthra [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 24, 2001 9:51 PM
To: Multiple
Hello all,
How do I come to know about table fragmentation, I know the info. on tablespace but I
need TABLE fragmentation. Please advise as to what kinds of info. and corresponding
script would be advantageous to know.
rgds,
raja
Get 250 color business cards for FREE!
http