OraFAQ Forum: Server Administration » SQL Tuning Adviser error in alert log.

Home » RDBMS Server » Server Administration » SQL Tuning Adviser error in alert log. (RHEL 6, Oracle 11g R2 (11.2.0.1.0))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Tuning Adviser error in alert log. [message #610836]

Tue, 25 March 2014 01:48

chintan.patel
Messages: 162
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

Report message to a moderator

Re: SQL Tuning Adviser error in alert log. [message #610844 is a reply to message #610836]

Tue, 25 March 2014 02:15

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: SQL Tuning Adviser error in alert log. [message #610878 is a reply to message #610844]

Tue, 25 March 2014 07:25

hitesh.bhatt
Messages: 84
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...

Report message to a moderator

Re: SQL Tuning Adviser error in alert log. [message #610923 is a reply to message #610878]

Wed, 26 March 2014 00:12

chintan.patel
Messages: 162
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 23:46:47 CST 2025