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
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,
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!
http://businesscard
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 -
EMAIL PROTECTED]>
Fecha: Miércoles, 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