Wednesday, 30 September 2009

To know used/free space in tablespaces


To show the total space alloted to tablespace
=============================================
Select * from sm$ts_avail;

To show the free tablespace
===========================
Select * from sm$ts_free;

To show the total space used by tablespace
=============================================
Select * from sm$ts_used;


No comments:

Get our exclusive subscription-only PeopleSoft tips once per month!

How was the blog? Help us in getting better