Answer Detail: RE: If you 100 table spaces so how to find which table space is growing and which one is volatile?

GeekInterview.com > Interview Questions > Database > Database Admin

Print |

Question: If you 100 table spaces so how to find which table space is growing and which one is volatile?

March 03, 2008 07:51:32	#1
hemant.agarwal03	Oracle Expert Member Since: March 2007 Total Comments: 14
RE: If you 100 table spaces so how to find which table space is growing and which one is volatile?
select sum(bytes),TABLESPACE_NAME from dba_segments group by TABLESPACE_NAME order by sum(bytes) desc /