[racdba] Tempspace usage by Instance
- From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- To: racdba@xxxxxxxxxxxxx
- Date: Thu, 21 Jul 2005 17:29:35 +0530
Guys:
I am trying to findout the tempspace usage by Instance level. I think
I can get it by joining gv$ sort_segment and sort_usage. Anyone have a
ready made script to tell what % of temp space is CONSUMED by each
instance..
Thanks
--
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
Other related posts:
