Available space question [message #333451] |
Fri, 11 July 2008 12:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ehegagoka
Messages: 493 Registered: July 2005
|
Senior Member |
|
|
hi,
just want to ask on how to get the available space for a tablespace. i found this link
http://asktom.oracle.com/tkyte/Misc/free.html
but it tells that we've only got 7mb space left for our tablespace. last week our dba's already added space, and i think that's true because at first we cant add new records because we're getting an error for lacking space. just want to ask if this script really returns the current sizing of the tablespaces? here's the output:
NAME KBYTES USED FREE PCT_USED LARGEST MAX_SIZE PCT_MAX_USED
*a TBS01 9,835,584.00 9,828,416.00 7,168.00 99.93 7,168.00 33,554,416.00 29.31
regards,
rhani
|
|
|
|
Re: Available space question [message #333464 is a reply to message #333456] |
Fri, 11 July 2008 13:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
ehegagoka
Messages: 493 Registered: July 2005
|
Senior Member |
|
|
hi, thanks for the reply. i just wanted to know if i miss something to do before i run that script. or if i need to run first some "stat-collection" thing for these views to be updated. well if this is the final values, then i'll go ask our support team. thanks!
|
|
|