OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Tablespace info (Oracle 10.2.0.4.0 , Sunos)

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

Tablespace info [message #534555]

Wed, 07 December 2011 04:32

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi,

I am looking for a tablespace script/statement which should return allocated size,used size ,
free size,max size,tablespace name for a single tablespace.

Thanks

Report message to a moderator

Re: Tablespace info [message #534556 is a reply to message #534555]

Wed, 07 December 2011 04:37

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

Use DBA_TABLESPACES

Report message to a moderator

Re: Tablespace info [message #534557 is a reply to message #534555]

Wed, 07 December 2011 04:38

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

SELECT * FROM DICTIONARY 
 WHERE Lower (comments)  LIKE '%tablespace%'

Report message to a moderator

Re: Tablespace info [message #534559 is a reply to message #534557]

Wed, 07 December 2011 04:42

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I think I already pointed him to this view and query, and to Reference Manual about 100 times.
His answer is: he does not care about the documentation or catalog, he just wants we provide him the solution.

@balaji14
Do you think you are the first one to ask this question?
Don't you think there are hundred of scripts on the web giving what you ask?

Regards
Michel

Report message to a moderator