Re: Internal Lock Waits

From: Yong Huang <yong321_at_yahoo.com>
Date: 24 Mar 2002 13:08:56 -0800
Message-ID: <b3cb12d6.0203241308.7091717d@posting.google.com>

There's no such wait event. Tell us where you saw this phrase?

Yong Huang
yong321_at_yahoo.com

dhoffman0917_at_yahoo.com (Donna) wrote in message news:<79808a91.0203231045.4a5f3526_at_posting.google.com>...
> Does anyone know what could cause "Internal Lock Wait" with
> a sql query statement only (no updates). All db_block_buffers are not being used.
>
> CPU=4; UNIX/SOLARIS 8; Oracle 8.1.7.2
>
> db_block_lru_latches = 8; db_writer_processes=4;dbwr_io_slaves=0;
> db_block_size=8192; db_file_direct_io_count=64; db_file_multiblock_read_count=32;
>
>
> Thanks
Received on Sun Mar 24 2002 - 15:08:56 CST