Home » Other » Client Tools » Space problem
Space problem [message #25941] Tue, 27 May 2003 22:31 Go to next message
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.
Re: Space problem [message #25950 is a reply to message #25941] Wed, 28 May 2003 05:31 Go to previous messageGo to next message
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
Re: Space problem [message #25951 is a reply to message #25950] Wed, 28 May 2003 05:56 Go to previous messageGo to next message
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...?
Re: Space problem [message #25954 is a reply to message #25951] Wed, 28 May 2003 07:31 Go to previous message
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

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


Current Time: Thu Mar 28 17:54:31 CDT 2024