enqueque_resources

From: Ed Lufker <elufker_at_swcp.com>
Date: 6 Jul 1998 20:02:31 GMT
Message-ID: <6nragn$ivi$1@sloth.swcp.com>

Hi All

I am running the following sql

select 'Warning: Enqueue Timeouts are '||value||'. They should be zero if the IN
IT.ora parameter is ' line1,

       'high enough. Try increasing INIT.ora parameter ENQUEUE_RESOURCES and see
if the Timeouts reduces.'
  from v$sysstat
where name = 'enqueue timeouts'
   and value > 0
/

It show me like 1145 waits, it should be zero. How high can I grow this parameter. I am on a sun e4000 running solaris 2.5.1 and oracle 7.3.3.0.

thank in advance for any help
eddie lufker Received on Mon Jul 06 1998 - 15:02:31 CDT