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

"Ofer" <oferr@realcommerce.co.il> wrote in message news:<c0q6at$2om$1@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

Ofer, by default Oracle does not lock data when it is read. Also a
latching problem and a locking problem are not one and the same in
Oracle, which problem do you have?

Is is select for update in use? You need to explain the processing
and your analysis of the locks and latches to get decent responses on
what your problem might be.

HTH -- Mark D Powell --

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_ad...isclaimer.html



"Ofer" <oferr@realcommerce.co.il> wrote in message
news:c0q6at$2om$1@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
>
>