Home » RDBMS Server » Server Administration » SQL Tuning Adviser error in alert log. (RHEL 6, Oracle 11g R2 (11.2.0.1.0))
SQL Tuning Adviser error in alert log. [message #610836] Tue, 25 March 2014 01:48 Go to next message
chintan.patel
Messages: 131
Registered: July 2008
Location: Ahmedabad
Senior Member
Dear Friends,

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][578823]: completed
Sweep [inc2][578823]: completed


Regards

Chintan
Re: SQL Tuning Adviser error in alert log. [message #610844 is a reply to message #610836] Tue, 25 March 2014 02:15 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink/MOS and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

Re: SQL Tuning Adviser error in alert log. [message #610878 is a reply to message #610844] Tue, 25 March 2014 07:25 Go to previous messageGo to next message
hitesh.bhatt
Messages: 40
Registered: February 2014
Location: INDIA
Member
Hi,

As per Michel's suggestion please check Metalink, i think its - Bug- 9474259
Please confirm from your side as well.
Thanks...
Re: SQL Tuning Adviser error in alert log. [message #610923 is a reply to message #610878] Wed, 26 March 2014 00:12 Go to previous message
chintan.patel
Messages: 131
Registered: July 2008
Location: Ahmedabad
Senior Member
Dear Friends,

I have learnt through this experience which i would like to share with you. As you know i have been facing problem regarding error of automatic sql tuning task which i mentioned above is solved. I observed that, after four days automatic sql tuning process resolve on its own. i didn't have to do anything.

Thanks & Regards

Chintan
Previous Topic: adding a column to a policy in VPD
Next Topic: A scheduler job getting hung causing critical issues
Goto Forum:
  


Current Time: Wed Jul 30 14:59:51 CDT 2014

Total time taken to generate the page: 0.54200 seconds