You may want to consider determining *why* that process is taking so much CPU, and fix the problem. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On 4/20/05, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote: > > 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 <http://8.1.7.4> > > > -- //www.freelists.org/webpage/oracle-l