I have been facing one problem since last few days and it came into my knowledge through alert log. Whenever the process of automatic sql tuning adviser started, it was throwing an error into alert log Hence, as per me the process could not complete. I have a session query which i retrived from the trace file was executed without any error from sqlplus. I am seeking the solution of it. There are two options come into my mind, One is modify query then argument is why should i change it while runs fine from sqlplus, Second is bypass it from automatic sql tuning adviser then how could i do it? It would be great if anyone gives me an idea to overcome from this situation.
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Mon Mar 24 22:07:25 2014
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x3C] [PC:0x8BB5705, kkestGetColGroupNdv()+25] [flags: 0x0, count: 1]
Errors in file /ora11gsoft/odb/diag/rdbms/mydata/mydata/trace/mydata_j001_29802.trc (incident=578823):
ORA-07445: exception encountered: core dump [kkestGetColGroupNdv()+25] [SIGSEGV] [ADDR:0x3C] [PC:0x8BB5705] [Address not mapped to object] 
Incident details in: /ora11gsoft/odb/diag/rdbms/mydata/mydata/incident/incdir_578823/mydata_j001_29802_i578823.trc
Mon Mar 24 22:07:28 2014
Trace dumping is performing id=[cdmp_20140324220728]
Mon Mar 24 22:07:41 2014
Sweep [inc]: completed
Sweep [inc2]: completed