OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » SQL Repair (Oracle 11g , Unix)

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

SQL Repair [message #609635]

Mon, 10 March 2014 10:50

younusc
Messages: 2
Registered: March 2014
Location: Pune

Junior Member

Hello Everyone,

does anyone knows about SQL Repair? is anyone used the new feature of 11g.
would like to know the results and issues related as well.

-Younus

Report message to a moderator

Re: SQL Repair [message #609637 is a reply to message #609635]

Mon, 10 March 2014 11:04

John Watson
Messages: 8803
Registered: January 2010
Location: Global Village

Senior Member

I've never needed to use it, but in earlier releases it would have been useful. I remember hitting a bug in 10.2 where a hash group by could give wrong results, and we had to hint some statements to prevent the CBO from choosing that access method. A SQL repair would have had that effect without needing to adjust the code.

Report message to a moderator

Re: SQL Repair [message #609721 is a reply to message #609637]

Tue, 11 March 2014 08:43

younusc
Messages: 2
Registered: March 2014
Location: Pune

Junior Member

thanks !

Report message to a moderator

Re: SQL Repair [message #609837 is a reply to message #609721]

Thu, 13 March 2014 00:02

Markwillium
Messages: 13
Registered: December 2010
Location: India

Junior Member

I have not used yet. It helps to diagnose and fix valid SQL statements that fail with critical errors at runtime. SQL repair advisor performs a diagnostic operation on the statement and may provide a patch to repair the statement. It is available from Enterprise Manager.

Report message to a moderator

Previous Topic:	database performance tuning
Next Topic:	Incorrect cardinalty estimate when using a local non-prefixed unique index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 09:00:22 CDT 2023