finding fragmented tables. [message #336044] |
Thu, 24 July 2008 10:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
suresh.wst
Messages: 53 Registered: June 2008 Location: Hyderabad
|
Member |
|
|
Hi,
How to find out the tables which are fragmented. Is there any view for that. please help me out.
Thanks & Regards
suresh
|
|
|
|
|
|
|
|
|
Re: finding fragmented tables. [message #336069 is a reply to message #336053] |
Thu, 24 July 2008 12:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
suresh.wst wrote on Thu, 24 July 2008 11:40 | using which view I can see the list of tables which are fragmented.
|
You are using 10g, therefore you do not have fragmented tables.
|
|
|
|
|
Re: finding fragmented tables. [message #336196 is a reply to message #336186] |
Fri, 25 July 2008 02:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
suresh.wst
Messages: 53 Registered: June 2008 Location: Hyderabad
|
Member |
|
|
yes, I executed following query & posting result below.
SYS>select tablespace_name,extent_management,allocation_type from dba_tablespaces where tablespace_name in('USERDATA','TS_2K');
TS_NAME EXTENT_MAN ALLOC_TYPE
---------- ---------- ----------
TS_2K LOCAL SYSTEM
USERDATA LOCAL SYSTEM
Regards
suresh
|
|
|
|
|
|
|
|