I am having a databasse been using very much of CPU where during peak time, a single process used to call several time and so taking almost all CPU and stop the site.Is there way I can control that one session cannot use excessive CPU. If I use CPU_PER_SESSIOn , then if I say that 30 sec per session, then what happen after 30 second, is the session hanged on closed . I am at 8.1.7.4 If I use Resource limit, can any have any example that can help. The load is high between 10-12 EST Thanks for everybody time Sanjay __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l