----- Original Message -----
Sent: Friday, August 29, 2003 9:44
AM
Subject: Client hangs on some key
values
New DBA on the block and already ran into my first problem:
We have an Oracle Database (8.1.7.0) running on Clustered HP-UX.
Oracle client running on a HP-UX (11) B2000 machine.
The query looks like
select col1, col2, col3, 0, col4, col5, 0, 0,
................col100
from table 1
where col1 = '123'
This query works for most everytime except certain selected col1
values. col1 a primary key.
For the unfortuante col1 values, the client just hangs. I looked
under v$session_wait, don't see anthying unusual. Only following events
I have noticed:
Message to/from SQL*CLient, more data to SQL*Client, file
open The values for the wait were not any different from the sessions
when the SQL got executed. Although the query never makes to V$SQL
view.
No locks on the table. verified with V$lock views.
No corrupt blocks: verified with analyze ...cascade command.
TNSPING normal
It is interesting that these queries only fail from this one
client. It works fine on the server or any other client.
Network guru says he doesn't see any problem with network either.
Changed the machine but still didn't help. Memory, CPU looks good on the
client and server.
Do you have any idea what might be wrong here?
Is there a view I can refrence to show that the sever never recived the
client request?
TIA
SB
This is going to be a great day!!!
Do you Yahoo!?
Yahoo!
SiteBuilder - Free, easy-to-use web site design
software
