Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Internal Lock Waits

Internal Lock Waits

From: Donna <dhoffman0917_at_yahoo.com>
Date: 23 Mar 2002 10:45:27 -0800
Message-ID: <79808a91.0203231045.4a5f3526@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 Sat Mar 23 2002 - 12:45:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US