環境是11.2.0.3 rac 其中有一節點日志 每天晚上10點 automatic SQL Tuning Advisor 報錯 ：ORA-07445: exception encountered: core dump [kokscold()+719] [SIGSEGV] [ADDR:0x50] [PC:0x141368F] [Address not mapped to object] [][/b]
這個問題是什么問題？ 是否BUG? 有影響嗎
Archived Log entry 91248 added for thread 2 sequence 6 ID 0x1f474f3b dest 1:
Sun Aug 25 22:10:06 2019
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x50] [PC:0x141368F, kokscold()+719] [flags: 0x0, count: 1]
Errors in file /opt/app/oracle/diag/rdbms/gx/gx2/trace/gx2_j002_31911.trc (incident=17985):
ORA-07445: exception encountered: core dump [kokscold()+719] [SIGSEGV] [ADDR:0x50] [PC:0x141368F] [Address not mapped to object] []
Incident details in: /opt/app/oracle/diag/rdbms/gx/gx2/incident/incdir_17985/gx2_j002_31911_i17985.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sun Aug 25 22:10:13 2019
Dumping diagnostic data in directory=[cdmp_20190825221013], requested by (instance=2, osid=31911 (J002)), summary=[incident=17985].
Sun Aug 25 22:10:14 2019
Trace file /opt/app/oracle/diag/rdbms/gx/gx2/trace/gx2_j002_26311.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /opt/app/oracle/product/11.2.0/db_1
System name: Linux
Node name: db2
Release: 2.6.32-573.el6.x86_64
Version: #1 SMP Wed Jul 1 18:23:37 EDT 2015
Machine: x86_64
Instance name: gx2
Redo thread mounted by this instance: 2
Oracle process number: 151
Unix process pid: 26311, image: oracle@db2 (J002)
*** 2019-08-26 22:00:10.705
*** SESSION ID:(1055.19) 2019-08-26 22:00:10.705
*** CLIENT ID:() 2019-08-26 22:00:10.705
*** SERVICE NAME:(SYS$USERS) 2019-08-26 22:00:10.705
*** MODULE NAME:(DBMS_SCHEDULER) 2019-08-26 22:00:10.705
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_277) 2019-08-26 22:00:10.705
status=(pst=SUCCESS)
**************************************************************
Execution Statistics
Exec count: 1
CR gets: 8771
CU gets: 0
Disk Reads: 0
Disk Writes: 0
IO Read Requests: 0
IO Write Requests: 0
Bytes Read: 0
Bytes Written: 0
Bytes Exchanged with Storage: 0
Bytes Exchanged with Disk: 0
Bytes Simulated Read: 0
Bytes Simulated Returned: 0
Elapsed Time: 71 (ms)
CPU Time: 71 (ms)
User I/O Time: 0 (us)
*** 2019-08-26 22:00:12.681
status=(pst=ERROR)
*** 2019-08-26 22:00:24.288
status=(pst=SUCCESS)
**************************************************************
Execution Statistics
Exec count: 1
CR gets: 179067
CU gets: 0
Disk Reads: 8
Disk Writes: 0
IO Read Requests: 8
IO Write Requests: 0
Bytes Read: 65536
Bytes Written: 0
Bytes Exchanged with Storage: 65536
Bytes Exchanged with Disk: 65536
Bytes Simulated Read: 0
Bytes Simulated Returned: 0
Elapsed Time: 3524 (ms)
CPU Time: 3495 (ms)
User I/O Time: 4083 (us)
status=(pst=ERROR)
status=(pst=SUCCESS)
**************************************************************
Execution Statistics
Exec count: 1
CR gets: 172250
CU gets: 1
Disk Reads: 25
Disk Writes: 0
IO Read Requests: 25
IO Write Requests: 0
Bytes Read: 204800
Bytes Written: 0
Bytes Exchanged with Storage: 204800
Bytes Exchanged with Disk: 204800
Bytes Simulated Read: 0
Bytes Simulated Returned: 0
Elapsed Time: 640 (ms)
CPU Time: 628 (ms)
User I/O Time: 7688 (us)
status=(pst=SUCCESS)
**************************************************************
Execution Statistics
Exec count: 1
CR gets: 22
CU gets: 0
Disk Reads: 0
Disk Writes: 0
IO Read Requests: 0
IO Write Requests: 0
Bytes Read: 0
Bytes Written: 0
Bytes Exchanged with Storage: 0
Bytes Exchanged with Disk: 0
Bytes Simulated Read: 0
Bytes Simulated Returned: 0
Elapsed Time: 139 (us)
CPU Time: 200 (us)
User I/O Time: 0 (us)
status=(pst=ERROR)
status=(pst=SUCCESS)
**************************************************************
Execution Statistics
Exec count: 1
CR gets: 9
CU gets: 0
Disk Reads: 0
Disk Writes: 0
IO Read Requests: 0
IO Write Requests: 0
Bytes Read: 0
Bytes Written: 0
Bytes Exchanged with Storage: 0
Bytes Exchanged with Disk: 0
Bytes Simulated Read: 0
Bytes Simulated Returned: 0
Elapsed Time: 128 (us)
CPU Time: 200 (us)
User I/O Time: 0 (us)
*** 2019-08-26 22:00:25.315
status=(pst=SUCCESS)
**************************************************************
Execution Statistics
Exec count: 1
CR gets: 2657
CU gets: 1
Disk Reads: 2
Disk Writes: 0
IO Read Requests: 2
IO Write Requests: 0
Bytes Read: 19660
Bytes Written: 0
Bytes Exchanged with Storage: 19660
Bytes Exchanged with Disk: 19660
Bytes Simulated Read: 0
Bytes Simulated Returned: 0
Elapsed Time: 20 (ms)
CPU Time: 19 (ms)
User I/O Time: 685 (us)
*** 2019-08-26 22:01:12.285
status=(pst=SUCCESS)
**************************************************************
Execution Statistics
Exec count: 1
CR gets: 6
CU gets: 0
Disk Reads: 0
Disk Writes: 0
IO Read Requests: 0
IO Write Requests: 0
Bytes Read: 0
Bytes Written: 0
Bytes Exchanged with Storage: 0
Bytes Exchanged with Disk: 0
Bytes Simulated Read: 0
Bytes Simulated Returned: 0
Elapsed Time: 211 (us)
CPU Time: 199 (us)
User I/O Time: 0 (us)
*** 2019-08-26 22:01:20.754
status=(pst=SUCCESS)
**************************************************************
Execution Statistics
Exec count: 1
CR gets: 164805
CU gets: 0
Disk Reads: 0
Disk Writes: 0
IO Read Requests: 0
IO Write Requests: 0
Bytes Read: 0
Bytes Written: 0
Bytes Exchanged with Storage: 0
Bytes Exchanged with Disk: 0
Bytes Simulated Read: 0
Bytes Simulated Returned: 0
Elapsed Time: 2677 (ms)
CPU Time: 2673 (ms)
User I/O Time: 0 (us)
*** 2019-08-26 22:01:20.909
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x50] [PC:0x141368F, kokscold()+719] [flags: 0x0, count: 1]
Incident 17209 created, dump file: /opt/app/oracle/diag/rdbms/gx/gx2/incident/incdir_17209/gx2_j002_26311_i17209.trc
ORA-07445: exception encountered: core dump [kokscold()+719] [SIGSEGV] [ADDR:0x50] [PC:0x141368F] [Address not mapped to object] []
ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL
ksdbgcra: writing core file to directory '/opt/app/oracle/diag/rdbms/gx/gx2/cdump'
uj5u.com熱心網友回復：
這種報錯，bug的可能性比較大，可以登錄mos賬號檢查和確認下。uj5u.com熱心網友回復：
十有八九是BUG，也許升級到11.2.0.4能解決，但還是先考慮把這個advisor關了吧，優化這種東西，太自動化了也不好啊。。。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/29788.html
標籤：高級技術
上一篇：oracle ODI
下一篇：SFTP上傳檔案