Re: Oracle 817 freezing
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: rgoulet@xxxxxxxxxx
- Date: Mon, 22 Jan 2007 21:54:13 +0100
Dick,
I have seen something similar, but with shared servers (obviously
not your case - your reference to dedicated servers is presumably not by
opposition to shared servers), but perhaps the reason for the freeze is
related.
In my case, the shared pool was too small (although the large pool was
adequate). Instead of returning ORA-I don't know how much as it should
have, Oracle exhibited exactly the behavior you describe. I couldn't
reproduce it in 9.2.
Stéphane Faroult
Richard J. Goulet wrote:
Has anyone seen the following condition in 8.1.7 on Solaris 9, all 64
bit:
1: The database appears to be frozen. New connections do not
reject, but don't come back to the client either.
2: Dedicated server processes amount to ~ 150 sessions where the
db process and sessions limits are up around 400
3: Database will not shutdown immediate even after half an hour of
waiting. Must use shutdown abort.
4: Cannot see what v$lock contains. Connection as sysdba comes
back to a command prompt, but about the only thing you can do is abort
the instance.
5: Memory(vmstat) appears normal, cpu loading is low and idle is high.
6: Sar does not indicate any disks being hit for anything. Io
appears to be non existent.
7: Alert log does not contain anything outside of the normal redo
switching activity. No user dump files either.
Dick Goulet, Senior Oracle DBA
45 Bartlett St Marlborough, Ma 01752, USA
/Tel.:/ 598.573.1978 |F/ax: / 508.229.2019 | Cell:508.742.5795
RGoulet@xxxxxxxxxx <mailto:RGoulet@xxxxxxxxxx>
: POWERING TRANSFORMATION
--
//www.freelists.org/webpage/oracle-l
Other related posts:
