OraFAQ Forum: Server Administration » Current table extent

Home » RDBMS Server » Server Administration » Current table extent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Current table extent [message #57017]

Wed, 14 May 2003 22:08

Wanchun
Messages: 4
Registered: May 2003

Junior Member

Please help.
I just can find the max_extents from the user_tables. However, how can i know the current extent of the table. Because, I need to know the table will be reached the max_extents or not, thanks.
Urgent!!!!

Report message to a moderator

Re: Current table extent [message #57022 is a reply to message #57017]

Thu, 15 May 2003 03:24

Deepa
Messages: 269
Registered: November 2000

Senior Member

hi,

u can use the following query to find out Extents reaching maximum

select owner "Owner", segment_name "Segment Name", segment_type "Type", tablespace_name "Tablespace", extents "Ext", max_extents "Max"from dba_segments where
((max_extents - extents) <= 3) and owner not in ('SYS','SYSTEM') order by owner, segment_name

Report message to a moderator

Previous Topic:	how many concurrent users??
Next Topic:	migrating db_block_size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 30 17:22:24 CST 2024