Home » RDBMS Server » Performance Tuning » Bock Inefficiency 100% (oracle 8.0.4.3,SunOS 5.9)
Bock Inefficiency 100% [message #292472] Wed, 09 January 2008 00:46 Go to next message
hitenparekh
Messages: 5
Registered: January 2008
Junior Member
Hi all ,

i have executed a query regarding block inefficiency and HWM(high water mark ) .. i get results showing some tables having block inefficiency around 100 % ,98 % .. is there any solution or remedies for it ..


TIA
Parekh Hiten

Report message to a moderator

Re: Bock Inefficiency 100% [message #292491 is a reply to message #292472] Wed, 09 January 2008 01:18 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you don't post the query, we don't what you mean with "block inefficiency" and so we can't answer you.

Before posting your query, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Previous Topic: Merge join verse Filter. Same code, different database, different explain plan
Next Topic: How can i tune the query...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 05:30:19 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.