Re: Database performance using 1 user account for multi clients?

Korstiaan Kamp wrote:
>
> I have some performance problems using an Oracle Database on a HP 9000
> if +/- 50 users are connect the oracle database gets very slow although
> the processor load is only 5-10 percent. All our (delphi) client
> programs
> connect to the server using the same user/password combination.
>
> Has this a (bad?) influence on the Oracle performance???
> Would the performance be better when using 50 different user/password
> combinations??
>
> Can someone help me out??
>
> Korstiaan KampNot necesassarily bad. Do you have I/O problems that you are aware of?

How is the data spread across the disks? How are indexes laid out? Are the indexes in separate tablespaces?

Are the users accessing the same table(s) or are the queries different? Are they doing only queries or inserts, or deletes, or updates or a mixture?

How well was the application written. In my experience, the place one want's to first look at for tuning is the SQL in the application.

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Donald P. Brown                     $  Your progress in life begins
Legacy Enterprises                  $  in your own mind and ends
dpbrown_at_phoenix.net                 $  in the same place.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=