DB hang

Giganews Newsgroups
Subject: DB hang
Posted by:  madunix (madun…@gmail.com)
Date: 10 Sep 2006

I am running SLES9 with Oracle10g on Intel based server DellPowerEdge
when I came today found low performance, High utilization  with Oracle
user which include many oracle processes and system suffering
performance lack

I checked the error log didnt find in alert anything abnormal
but the listenr logs was showing

TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
  TNS-00530: Protocol adapter error
  Linux Error: 24: Too many open files

my spfile:


king:/opt/oracle/product/10gR2/dbs # cd
king:~ # cat /proc/meminfo
MemTotal:      4145584 kB
MemFree:      1717368 kB
Buffers:        198724 kB
Cached:        1750364 kB
SwapCached:          0 kB
Active:        1354472 kB
Inactive:      873416 kB
HighTotal:    3276544 kB
HighFree:      1221772 kB
LowTotal:      869040 kB
LowFree:        495596 kB
SwapTotal:    2112464 kB
SwapFree:      2112464 kB
Dirty:          42824 kB
Writeback:          0 kB
Mapped:        664608 kB
Slab:          164208 kB
Committed_AS:  1685924 kB
PageTables:      17856 kB
VmallocTotal:  112632 kB
VmallocUsed:    21596 kB
VmallocChunk:    89936 kB
HugePages_Total:    0
HugePages_Free:      0
Hugepagesize:    2048 kB

king:~ # df -kh
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda6            196G  97G  99G  50% /
tmpfs                2.0G  12K  2.0G  1% /dev/shm

Linux king 2.6.5-7.191-bigsmp #1 SMP Tue Jun 28 14:58:56 UTC 2005 i686
i686 i386 GNU/Linux

Any help, in this issue?

Communications/Network and Systems Engineer