Home » RDBMS Server » Performance Tuning » SQL Repair (Oracle 11g , Unix)
SQL Repair [message #609635] Mon, 10 March 2014 10:50 Go to next message
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
Re: SQL Repair [message #609637 is a reply to message #609635] Mon, 10 March 2014 11:04 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: SQL Repair [message #609721 is a reply to message #609637] Tue, 11 March 2014 08:43 Go to previous messageGo to next message
younusc
Messages: 2
Registered: March 2014
Location: Pune
Junior Member
thanks !
Re: SQL Repair [message #609837 is a reply to message #609721] Thu, 13 March 2014 00:02 Go to previous message
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.
Previous Topic: database performance tuning
Next Topic: Incorrect cardinalty estimate when using a local non-prefixed unique index
Goto Forum:
  


Current Time: Thu Mar 28 17:50:14 CDT 2024