Home » RDBMS Server » Performance Tuning » segment tuning (10.2.0.1)
segment tuning [message #352244] Mon, 06 October 2008 16:27 Go to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Experts,
Some of my statement are using Literals instead of
bind variables leading to excessive hard parse.Can I
escape the use of literals by setting cursor_sharing to FORCE.
Right now the value is set to EXACT.

My ADDM Report recommended to do segment tuning on
two tables.Please advise me how to do segment tuning.

Regards,
Varun Punj,
Re: segment tuning [message #352779 is a reply to message #352244] Thu, 09 October 2008 09:31 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
segment tuning? No clue what he means. Go back and ask him for more details. Ask him what he thinks segment tuning means?

CURSOR_SHARING works. It does what it says it will do. You can get additional reading from the internet. I recommend going to ASKTOMHOME and doing a search there. Tom will give you a complete lowdown on CURSOR_SHARING for he has answered this question many time with great detail and insight.

Kevin
Re: segment tuning [message #352786 is a reply to message #352779] Thu, 09 October 2008 10:33 Go to previous message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Thanks Kevin.
Previous Topic: Index creation- Performance impact
Next Topic: 10.2..0..2
Goto Forum:
  


Current Time: Mon Dec 05 11:05:47 CST 2016

Total time taken to generate the page: 0.08483 seconds