DB hang

From: madunix <madunix_at_gmail.com>
Date: 10 Sep 2006 03:20:44 -0700
Message-ID: <1157883644.948038.3290@m73g2000cwd.googlegroups.com>

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

Received on Sun Sep 10 2006 - 05:20:44 CDT