OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » segment tuning (10.2.0.1)

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

segment tuning [message #352244]

Mon, 06 October 2008 16:27

varunvir
Messages: 389
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,

Report message to a moderator

Re: segment tuning [message #352779 is a reply to message #352244]

Thu, 09 October 2008 09:31

Kevin Meade
Messages: 2103
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

Report message to a moderator

Re: segment tuning [message #352786 is a reply to message #352779]

Thu, 09 October 2008 10:33

varunvir
Messages: 389
Registered: November 2007

Senior Member

Thanks Kevin.

Report message to a moderator

Previous Topic:	Index creation- Performance impact
Next Topic:	10.2..0..2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 09:19:50 CST 2024