Low performances SYSTEM_CORE_DUMPED
Hi,
we've SAP ECC 6.0 on Oracle 10.2.0.5 and MS Windows 2003 Server Ent Ed. x64 on MSCS Cluster.
We performed a kernel upgrade to the latest patch (278 for basis 700 sp 14) from a patch level 232.
C:\Documents and Settings\prdadm>disp+work
-
disp+work information
-
kernel release 700
kernel make variant 700_REL
compiled on NT 5.2 3790 Service Pack 2 x86 MS VC++ 14.00 for NTAMD64
compiled for 64 BIT
compilation mode UNICODE
compile time Oct 31 2010 22:37:06
update level 0
patch number 278
source id 0.278
-
supported environment
-
database (SAP, table SVERS) 700
operating system
Windows NT 5.0
Windows NT 5.1
Windows NT 5.2
Windows NT 6.0
Windows NT 6.1
Bundled to this action, our DBA has modified some oracle parameters getting this configuration:
########################################################################
This init.ora profile is a transparent copy of Oracle spfile. #
It was created by BRARCHIVE at 2011-04-20 12.00.05. #
Please do not change this file! Maintain only the spfile. #
You can use BRSPACE for the altering of database parameters: #
brspace -f dbparam #
########################################################################
*._first_spare_parameter=1
*._hash_join_enabled=FALSE
*.aq_tm_processes=0
*.background_dump_dest='D:\ORACLE\PRD\BACKGROUND'
*.compatible='10.2.0'
*.control_file_record_keep_time=30
*.control_files='F:\ORACLE\PRD\ORIGLOGA\CNTRL\CNTRLPRD.DBF','F:\ORACLE\PRD\ORIGLOGB\CNTRL\CNTRLPRD.DBF','F:\ORACLE\PRD\SAPDATA1\CNTRL\CNTRLPRD.DBF'
*.core_dump_dest='D:\ORACLE\PRD\BACKGROUND'
*.db_block_size=8192
*.db_cache_size=10116661248
PRD.db_file_multiblock_read_count=1
*.db_files=254
*.db_name='PRD'
*.db_writer_processes=6
*.filesystemio_options='setall'
*.log_archive_dest_1='LOCATION=F:\oracle\PRD\oraarch\PRDarch'
*.log_archive_format='%t_%s_%r.dbf'
*.log_buffer=30483456
*.log_checkpoints_to_alert=TRUE
*.max_dump_file_size='20000'
*.open_cursors=800
PRD.optimizer_features_enable='10.2.0.4'
*.optimizer_index_cost_adj=20
*.parallel_execution_message_size=16384
*.parallel_max_servers=80
*.parallel_threads_per_cpu=1
*.pga_aggregate_target=6144000000
*.processes=210
*.query_rewrite_enabled='false'
*.recyclebin='off'
*.remote_login_passwordfile='EXCLUSIVE'
*.remote_os_authent=TRUE
*.replication_dependency_tracking=FALSE
*.resource_manager_plan=''
*.sessions=420
*.sga_max_size=20266876928
*.shared_pool_size=8103395328
*.star_transformation_enabled='true'
*.undo_management='AUTO'
*.undo_retention=900
*.undo_tablespace='PSAPUNDO'
*.user_dump_dest='D:\ORACLE\PRD\USERTRACE'
Since those operations, customers says the performances are very slow. In addition we have more SYSTEM_CORE_DUMPED
SAP (R) - R/3(TM) Callstack, Version 1.0
Copyright (C) SAP AG. All rights reserved.
Application exception occurred:
Exception : c0000005 (Access Violation)
App : disp+work.EXE (pid=2864)
When : 4/20/2011 6:9:32.788
Threads : 2
Computer Name : URANO
User Name : SAPServicePRD
Number of Processors: 8
Processor Type: EM64T Family 6 Model 23 Stepping 10
Windows Version : 5.2 Current Build: 3790
State Dump for Thread Id 10d8
FramePtr ReturnAd Param#1 Function Name
0000000008546bf0 000000000075947a 0000000008547ce0 disp+work!DiagoTabFocusColumn [diagoutp.c (2818
0000000008547c80 0000000000759b6e 0000000000000000 disp+work!DiagoSetFocus [diagoutp.c (2486)]
0000000008547d90 000000000075ae09 0000000000000001 disp+work!DiagoFocus [diagoutp.c (2773)]
0000000008548780 000000000075b517 0000000000000000 disp+work!diagoutput [diagoutp.c (903)]
00000000085488b0 000000000074ce3a 000007ffac490050 disp+work!diagmout [diagoutp.c (258)]
0000000008548ed0 0000000000640df7 ffffffffffffffff disp+work!diagmsgo [sapdiag.c (196)]
00000000085490c0 0000000000688180 000007df04ea78a0 disp+work!dytrcexit [dymain.c (2726)]
0000000008549150 000000000068defa 0000000000000000 disp+work!dynpoutf [dymainstp.c (4735)]
0000000008549200 0000000000645575 0000000000000000 disp+work!dynprctl [dymainstp.c (361)]
000000000854fc30 00000000004f729b 0000000000000002 disp+work!dynpen00 [dymain.c (1937)]
000000000854feb0 000000000043069b 0000000008638460 disp+work!TskhLoop [thxxhead.c (4652)]
000000000854fee0 000000000040108d ffffffff00000003 disp+work!DpMain [dpxxdisp.c (1166)]
000000000854ff10 0000000001a708c1 0000000000000000 disp+work!nlsui_main [thxxanf.c (84)]
000000000854ff70 0000000077d596ac 0000000000000000 disp+work!wmainCRTStartup [crtexe.c (498)]
000000000854ffa0 0000000000000000 0000000001a70750 kernel32!BaseProcessStart
State Dump for Thread Id df8
FramePtr ReturnAd Param#1 Function Name
000000000f62fe40 0000000077d5f6f1 0000000000000000 ntdll!NtFsControlFile
000000000f62feb0 00000000019537df fffffffffffffffe kernel32!ConnectNamedPipe
000000000f62ff40 000007ff7fc411c4 0000000000000000 disp+work!SigIMsgFunc [signt.c (679)]
000000000f62ff70 0000000077d6b71a 0000000077d6b6e0 msvcrt!endthreadex
000000000f62ffa0 0000000000000000 0000000000000000 kernel32!BaseThreadStart
Please, help me to find what's going wrong... if I have to change any oracle parameter, if i have made any mistake with the kernel upgrade... or if I have to change all my customers.... :P
Kind Regards