Re: lock problem

From: Vsevolod Afanassiev <vafanassiev_at_westpac.com.au>
Date: Fri, 15 Oct 1999 11:46:04 +1000
Message-ID: <7u611b$hsk5@xlprod01.westpac.com.au>

Hi,
1. Oracle locks what needs to be locked - only tables according to the replication groups
you created. It only locks for updates, there is no need to lock against SELECTS. 2. Well, there is no magic trick. Look in V$ tables (V$SESSION_EVENT), increase block size, SGA, etc.

Regards,
Vsevolod

yangxiaode_at_my-deja.com wrote in message <7u5ecv$6qd$1_at_nnrp1.deja.com>...
>Hi, friends
>
>question1:
>I doubt whether the Oracle lock the database( doesn't allow access and
>retrieve data from the database) when you are doing the replication.
>
>question2:
>What do you think of the performance of Oracle running on NT comparing
>with MS/SQL?
>I have a very large mission critical table(600MB) on Oracle/NT, the
>speed of retrieving is very very slow compared with MS/SQL, do you have
>any good ideas for tuning the Oracle performance?
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Oct 14 1999 - 20:46:04 CDT