OraFAQ Forum: Performance Tuning » latch waits

Home » RDBMS Server » Performance Tuning » latch waits

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

latch waits [message #205075]

Thu, 23 November 2006 04:27

seema.taunk
Messages: 96
Registered: October 2006

Member

Hi friends,

My database ( oracle 9.2) is showing latch waits.
Presently, cursor_sharing is exact in my database.
I want to convert it into similar.
what will be its impact ? There are some statements in application which are not using bind variables, but couldn't be changed.So I want to change cursor_sharing parameter.
Please guide me.

Report message to a moderator

Re: latch waits [message #205078 is a reply to message #205075]

Thu, 23 November 2006 04:34

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.quest-pipelines.com/newsletter-v2/cursor_sharing.htm
http://asktom.oracle.com/pls/ask/f?p=4950:8:243122254267634687::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:5180609822543,

Report message to a moderator

Re: latch waits [message #205095 is a reply to message #205078]

Thu, 23 November 2006 05:21

seema.taunk
Messages: 96
Registered: October 2006

Member

Hi mahesh,
Thanks for ur reply.

Documents were informative.
Thanks for that.

Report message to a moderator

Previous Topic:	While Analyzing Schema
Next Topic:	Bothering "Sudden Death" by unexpected dropping efficient execution plan

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 02:44:29 CST 2024