From: Mike Krolewski Newsgroups: comp.databases.oracle.server Subject: Re: slow update, what to look for? Date: Fri, 26 Jan 2001 21:47:09 GMT Organization: Deja.com Lines: 50 Message-ID: <94sr8q$gd7$1@nnrp1.deja.com> References: NNTP-Posting-Host: 63.75.139.178 X-Article-Creation-Date: Fri Jan 26 21:47:09 2001 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) X-Http-Proxy: 1.1 x58.deja.com:80 (Squid/1.1.22) for client 63.75.139.178 X-MyDeja-Info: XMYDJUIDmikkrolewski In article , hegyvari@ardents.hu wrote: > Greetings, > > We are developing for the web using Oracle 8 on a Linux as a database > server. One thing I have noticed and it really is frustrating by now, > that update statements run much slower than any select or insert > statements. This is more than true when I try to use correlated updates. > I understand that update is the most resource-consuming of the lot, but I > suspect that there can be things done around the rollback segments or > anywhere else to tune the database. The current configuration is > basically the default (I accepted the option of creating the database > during install). I have changed the init...ora file to the LARGE default > values, but so for that was all. I searched the manuals for some > practical advice, but found none. Could someone please enlighten me what > I should try to change on my Oracle setup to get better results? The > server has 512M RAM, fast disks, fast processor, it should not be a > problem. > > Any info is highly appreciated, > > Hegyvari Krisztian > You have not stated the problem. What is slow? How many updates per minute. What is your configuration : # and type of CPU, how many controler cards, SGA size, how many disks, how big of data set, etc Most of my development (even with on NT, running Oracle on my local work station) updating a row was nearly instantaneous. As a rule, IMHO no one ever uses the default Oracle setup -- too small for almost anything, no rollback segments, etc. -- Michael Krolewski Rosetta Inpharmatics mkrolewski@rii.com Usual disclaimers Sent via Deja.com http://www.deja.com/