Environment is 11.2.0.3 rac one node logs at 10 PM every day automatic SQL Tuning Advisor error: ORA - 07445: the exception encountered: the core dump [kokscold () + 719] [SIGSEGV] [ADDR: 0 x50] [PC: 0 x141368f] [Address not mapped to the object] [] [/b]
The question is what problem? Whether a BUG? Is there any impact
Archived Log entry 91248 added for the thread ID 0 2 sequence 6 x1f474f3b dest 1:
Sun Aug 25 22:10:06 2019
The Begin automatic SQL Tuning Advisor run for special Tuning task "SYS_AUTO_SQL_TUNING_TASK
" the Exception type: SIGSEGV, Address not mapped to the object] [ADDR: 0 x50] [PC: 0 x141368f, kokscold () + 719] [flags: 0 x0, count: 1)
Errors in the file/opt/app/oracle/diag/RDBMS/gx/single trace/gx2_j002_31911 TRC (incident=17985) :
ORA - 07445: the exception encountered: the core dump [kokscold () + 719] [SIGSEGV] [ADDR: 0 x50] [PC: 0 x141368f] [Address not mapped to the object] []
Incident details: in/opt/app/oracle/diag/RDBMS/gx/single/Incident/incdir_17985/gx2_j002_31911_i17985 TRC
Use ADRCI or Support the Workbench to package the incident.
See Note 411.1 at My Oracle Support for the error and packaging details.
Sun Aug 25 22:10:13 2019
Dumping the diagnostic data in the directory=[cdmp_20190825221013], requested by (the instance=2, osid=31911 (J002)), the summary=[incident=17985].
Sun Aug 25 22:10:14 2019
Trace file/opt/app/oracle/diag/RDBMS/gx/single Trace/gx2_j002_26311 TRC
Oracle Database 11 g Enterprise Edition Release 11.2.0.3.0-64 - bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, on-line analytical processing (OLAP),
Data Mining, and Real Application Testing options
ORACLE_HOME=/opt/app/oracle/product/11.2.0/db_1
Linux System name:
The Node name: db2
Release: 2.6.32-573. The el6. X86_64
Version: # 1 SMP Wed Jul 1 18:23:37 EDT 2015
Machine: x86_64
The Instance name: single
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
* * * the SESSION ID: (1055.19) 2019-08-26 22:00:10. 705
* * * CLIENT ID: () the 2019-08-26 22:00:10. 705
* * * SERVICE NAME: (SYS $USERS) 2019-08-26 22:00:10. 705
* * * the MODULE NAME: (DBMS_SCHEDULER) 2019-08-26 22:00:10. 705
* * * the ACTION NAME: (ORA $AT_SQ_SQL_SW_277) 2019-08-26 22:00:10. 705
Status=(PST=SUCCESS)
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Execution Statistics
The 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)
The 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
The 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)
The User I/O Time: 4083 (us)
Status=(PST=ERROR)
Status=(PST=SUCCESS)
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Execution Statistics
The 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)
The User I/O Time: 7688 (us)
Status=(PST=SUCCESS)
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Execution Statistics
The 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)
The User I/O Time: 0 (us)
Status=(PST=ERROR)
Status=(PST=SUCCESS)
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull