Members   Search   Help    Register    Login   Home
Home » RDBMS Server » Performance Tuning » SQL statements were not shared due to the usage of literals. This resulted in additional hard parses (oracle 10.2.0.1.0,Redhat Linux 4)
SQL statements were not shared due to the usage of literals. This resulted in additional hard parses [message #429469] Wed, 04 November 2009 01:02 Go to next message
goracle9
Messages: 22
Registered: December 2006
Junior Member
SQL statements were not shared due to the usage of literals. This resulted in additional hard parses which were consuming significant database time.

ADDM Finding is

Alternatively, you may set the parameter "cursor_sharing" to "force".
Action Investigate application logic for possible use of bind variables instead of literals.


my cursor_sharing-Exact

could i chage it to "FORCE"

please rerply.
Report message to a moderator
Re: SQL statements were not shared due to the usage of literals. This resulted in additional hard pa [message #429471 is a reply to message #429469] Wed, 04 November 2009 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 29419
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Better change the application.
Search on Metalink for cursor=force and you will get more than 100 bugs from "wrong results" to "database crash".

Regards
Michel
Report message to a moderator
Re: SQL statements were not shared due to the usage of literals. This resulted in additional hard pa [message #429490 is a reply to message #429469] Wed, 04 November 2009 03:29 Go to previous message
JRowbottom
Messages: 5362
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Changing the application is definitely the best solution.

Setting the parameter to 'FORCE' is better than doing nothing, but you will need to test the performance of the system before putting it live.
Report message to a moderator
Previous Topic:performance issue wtith single instance database
Next Topic:Migration from Oracle8i to Oracle 10G
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 30 17:50:14 CST 2009

Total time taken to generate the page: 0.01917 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.