Home » RDBMS Server » Server Administration » Tablespace info (Oracle 10.2.0.4.0 , Sunos)
Tablespace info [message #534555] Wed, 07 December 2011 04:32 Go to next message
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
Re: Tablespace info [message #534556 is a reply to message #534555] Wed, 07 December 2011 04:37 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Use DBA_TABLESPACES
Re: Tablespace info [message #534557 is a reply to message #534555] Wed, 07 December 2011 04:38 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
SELECT * FROM DICTIONARY 
 WHERE Lower (comments)  LIKE '%tablespace%'
Re: Tablespace info [message #534559 is a reply to message #534557] Wed, 07 December 2011 04:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Tablespace info [message #534571 is a reply to message #534559] Wed, 07 December 2011 06:49 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Sad
Re: Tablespace info [message #534629 is a reply to message #534555] Thu, 08 December 2011 00:13 Go to previous message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
I agree with Michel. There are so many scripts all over the web.
Just google and you will see many results.
Previous Topic: Select statement generates Redo
Next Topic: oracle 11g ora-04031
Goto Forum:
  


Current Time: Fri Mar 29 09:12:58 CDT 2024