Yong, yes I agree with the resource_limit view.. I remember using this before to troubleshoot a max processes issue then from there I drilled down on ASH, I have it on my notes here http://goo.gl/ghJEO8 -- Karl Arao Blog: karlarao.wordpress.com Wiki: karlarao.tiddlyspot.com Twitter: @karlarao <http://twitter.com/karlarao> -- //www.freelists.org/webpage/oracle-l