Re: Internal locks

From: Ron <support_at_dbainfopower.com>
Date: Mon, 16 Feb 2004 09:54:16 -0800
Message-ID: <rp-dnTadn_nYn6zdRVn-uA@comcast.com>

Hello Ofer,

if you can generate and post for the group review statspack report from the time period when database is experiencing bad performance it would be great.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Ofer" <oferr_at_realcommerce.co.il> wrote in message news:c0q6at$2om$1_at_news2.netvision.net.il...
> Hi all,
>
> I am running a forum DB, and most of my users ask for the most recent page
> or message.
> Since everybody turn to the same block, I have many internal locks on that
> block...
>
> I increased the number of latches, and it helped for a while, but as the
> volume of the users goes up, my DB suffers from that problem again.
> As far as I understand, the problem is that most of the viewed data is at
> the same block, and get locked while retrieved...
>
> Is there a way to store the data in different random blocks, or any other
> solution for that problem?
>
> Thanks,
> Ofer
>
>
Received on Mon Feb 16 2004 - 11:54:16 CST