Showing posts with label Query to count no. of segments in each t.s.. Show all posts
Showing posts with label Query to count no. of segments in each t.s.. Show all posts
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;
Subscribe to:
Posts (Atom)
