OraFAQ Forum: Client Tools

Home » Other » Client Tools » Space problem

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

Space problem [message #25941]

Tue, 27 May 2003 22:31

manish mendiratta
Messages: 110
Registered: May 2002

Senior Member

Hi,
I have a database of around 40GB which has snapshotys of our production database, and one of the moitoring tools (spotlite) is showing that
'THERE MAY BE 4 SEGMENTS WHICH MAY FAIL TO EXTEND'

can i find out anyway which are the 4 segments which are likely to give error.

Pls help in this regards.

Thanks

ManishM.

Report message to a moderator

Re: Space problem [message #25950 is a reply to message #25941]

Wed, 28 May 2003 05:31

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi Manish,

this errorr my be reportet in your alert*.log. Here you may find the name of the segment and table which could not extend because of datafile-borders.
hth
Uwe

Report message to a moderator

Re: Space problem [message #25951 is a reply to message #25950]

Wed, 28 May 2003 05:56

manish mendiratta
Messages: 110
Registered: May 2002

Senior Member

Thanks for your reply. Can I know somehow before the error occurs which are those segments...?

Report message to a moderator

Re: Space problem [message #25954 is a reply to message #25951]

Wed, 28 May 2003 07:31

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi,
to filter this you need a script like this from orafaq scripting site. You need to run it in sqlplus and you can see which tablespace will neot fit the next extent size and you need to add a new datafile.
hth
uwe

exterror.sql

Report message to a moderator

Previous Topic:	Re: Finding Largest Among Matrix
Next Topic:	Positioned delete(using current of logic)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 11:32:13 CST 2025