Home » RDBMS Server » Performance Tuning » latch waits
latch waits [message #205075] Thu, 23 November 2006 04:27 Go to next message
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.
Re: latch waits [message #205078 is a reply to message #205075] Thu, 23 November 2006 04:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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,
Re: latch waits [message #205095 is a reply to message #205078] Thu, 23 November 2006 05:21 Go to previous message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi mahesh,
Thanks for ur reply.

Documents were informative.
Thanks for that.

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


Current Time: Sun Dec 04 00:32:36 CST 2016

Total time taken to generate the page: 0.08111 seconds