Pleased to announce that we have moved to a new PeopleSoft blog http://peoplesofttutorial.com/ . You will find lots of articles about PT8.53, IB, PeopleSoft basics and administration tasks, Oracle tips.
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;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment