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
2850,
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.__java_pool_size=16777216
king.__large_pool_size=16777216
king.__shared_pool_size=201326592
king.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/admin/king/adump'
*.audit_trail='TRUE'
*.background_dump_dest='/opt/oracle/admin/king/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/opt/oracle/oradata/king/control01.ctl','/opt/oracle/oradata/king/control02.ctl','/opt/oracle/oradata/king/control03.ctl'
*.core_dump_dest='/opt/oracle/admin/king/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='king'
*.job_queue_processes=10
*.log_archive_dest='/opt/oracle/archivelogs'
*.log_archive_format='king%s_%r_%t.arc'
*.nls_date_format='YYYY/MM/DD'
*.open_cursors=300
*.pga_aggregate_target=413138944
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_limit=TRUE
*.sga_target=1241513984
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle/admin/king/udump'

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

Replies