Re: Oracle 817 freezing
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: rgoulet@xxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 22 Jan 2007 11:49:11 -0800
Is there any Standby to this setup?
On Mon, 22 Jan 2007 14:25:05 -0500, "Richard J. Goulet" <rgoulet@xxxxxxxxxx>
said:
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.
[cid:792151919@22012007-11A8]
Dick Goulet, Senior Oracle DBA
45 Bartlett St Marlborough, Ma 01752, USA
Tel.: 598.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795
[1]RGoulet@xxxxxxxxxx
References
1. mailto:RGoulet@xxxxxxxxxx
Other related posts:
