Xref: alice comp.databases.oracle.server:69883
Path: alice!news-feed.fnsi.net!news-FFM2.ecrc.net!newsfeed.enteract.com!netnews.com!newspeer.monmouth.com!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: yangxiaode@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: lock problem
Date: Thu, 14 Oct 1999 20:28:34 GMT
Organization: Deja.com - Before you buy.
Lines: 16
Message-ID: <7u5ecv$6qd$1@nnrp1.deja.com>
X-Article-Creation-Date: Thu Oct 14 20:28:34 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.1 x40.deja.com:80 (Squid/1.1.22) for client 216.13.96.10
X-MyDeja-Info: XMYDJUIDyangxiaode

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.