Tuesday, March 17, 2009

Query to count no. of segments in each t.s.

select tablespace_name,count(*) from dba_segments group by tablespace_name;

No comments: