Re: Oracle Performance problems

Is your database running in MTS or Direct mode? With 300 connections, you might want to run in MTS mode. There are about 5 parameters you must set up in your init<sid>.ora file.

Also, with a 130MB database, tuning should be a breeze... Maybe you suffer from free list contention, or running into Lock contention. With such a small database, and a large amount of concurrent logins, it is quite possible that almost every user wants the same information at the same time.

Also, check your Hardware...Both on the server level and the network level.

Why don't you run utilbstat/utilestat and see if it is on a database level?

Anyway, good luck to you...
Satar

In article <363E0B79.E933CD24_at_inf.uniroma3.it>,   orsano <orsano_at_inf.uniroma3.it> wrote:
> This is a multi-part message in MIME format.
> --------------FB78B0A805EBA3F1DF6FFC20
> Content-Type: text/plain; charset=us-ascii
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> Content-Transfer-Encoding: 7bit
>
> Hi,
> We are experimenting severe performance problems (the client is very
> unhappy about it ) apparently due to the number of connections.
> As soon as we reach about 300 simuoltaneous connections (that is about
> 50 users) the performance drops down
> The workload is not heavly transactional (long transactions)
>
> We are working on the following platform:
>
> Client
> Power Builder 5.0
> Microsoft ODBC 2.73
> SQL*Net 2.3
>
> Network
> WAN
>
> Server
> SQL*Net 2.3
> Oracle 7.3.3
> AIX 4.1.2.
>
> The DB size is about 130 MB
>
> The tuning parameters we set are:
> SGA = 800 MB (2 GB Available)
> All of the table are cached (ALTER TABLE CACHE)
> 16 blocks of 4 KB for each read/write I/O operation (each AIX block is
> 4KB)
> Number of DBWR process = 4
> Number of dispatcher = 40
> Number of concurrent dispatcher running=40
> Number of server processes : MIN=16, MAX=128
> No disk striping
>
> When a performace problem occurs the server seems OK:
> I/O ok
> CPU idle 80%
> Cache hits about 99%
>
> <><><><><><><><><><><><><><><>
> Alessandro Orsano
> e-mail: alessandro.orsano_at_ac.com
>
> <><><><><><><><><><><><><><><>
>
> --------------FB78B0A805EBA3F1DF6FFC20
> Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for orsano
> Content-Disposition: attachment; filename="vcard.vcf"
>
> begin: vcard
> fn: orsano
> n: ;orsano
> email;internet: orsano_at_inf.uniroma3.it
> x-mozilla-cpt: ;0
> x-mozilla-html: FALSE
> end: vcard
>
> --------------FB78B0A805EBA3F1DF6FFC20--
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 03 1998 - 12:48:03 CST