OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » RE:Segment error

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

RE:Segment error [message #19611]

Mon, 01 April 2002 17:27

dhnish
Messages: 26
Registered: March 2002

Junior Member

Hi

Is there a way for me to monitor the growth of my extents ?
For some of my tables the pct_increase is 50 , I believe this will effect whenever it tries to extend ,right?

Thank you

Report message to a moderator

Re: RE:Segment error [message #19614 is a reply to message #19611]

Mon, 01 April 2002 19:05

Nilesh Mahajan
Messages: 10
Registered: March 2002

Junior Member

You can query User_tables to get the number of extents allocated for a perticular table.

Report message to a moderator

Important [message #19616 is a reply to message #19611]

Mon, 01 April 2002 19:09

Nilesh Mahajan
Messages: 10
Registered: March 2002

Junior Member

Double quote means two single quotes('').

Report message to a moderator

Re: RE:Segment error [message #19627 is a reply to message #19611]

Mon, 01 April 2002 23:22

dhnish
Messages: 26
Registered: March 2002

Junior Member

Hi

Info from user_tables does it give only those extents allocated OR used ?
Thank you

Report message to a moderator

Previous Topic:	DBstart not working
Next Topic:	support

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 16:09:36 CDT 2024