Re: Stored procedure and memory impact

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 23 Jul 2001 21:29:00 -0700
Message-ID: <3B5CF98C.EF8B8758@exesolutions.com>

ananth rani wrote:

> Hi
>
> Checking to see if anyone has information on the impact of simultaneous
> execution of stored procedures - there could be upto 10000 concurrent users
> executing a stored procedure which is not very data intensive (could be a
> query or a simple insert) - how can this be measured - can I get by just
> increasing RAM and SGA pool size or is there more to it
>
> Thanks
> Ananth Rani

I wouldn't do a thing ... unless you have a performance issue. And if you do ... proper tuning is not just a question of throwing RAM at it.

Daniel A. Morgan Received on Mon Jul 23 2001 - 23:29:00 CDT