Re: Session memory usage

From: Fredrik Bertilsson <fredrik_bertilsson_at_passagen.se>
Date: 29 Jul 2004 10:46:38 -0700
Message-ID: <31f7e57d.0407290946.11006275@posting.google.com>

Sorry I am not clear enough,
I mean what is the memory requirements for a idle user session that are not executing any query.

I am talkning about Oracle 9.2 for Windows 2000 Server. The installation is a standard installation with no additional configuration is done. What configuration can be done to make the memory usage for a idle session as small as possible.

/Fredrik

> Hi Fredrik,
>
> With the info you've provided, it's an impossible question to answer.
>
> What version of Oracle ?
> What type of server ? What O/S ?
> What "type" of database are we're talking here ?
> What's the size and expected usage of the database ?
> What are these concurrent users going to do on the DB ? Run hundreds of
> different massive DW financial reports or occasionally insert a row into a
> table ?
> Do you have good developers or bad developers ?
> What would be "acceptable" response times for all these different activities
> ?
> What do you mean by "normal" ?
>
> List goes on and on but you get my point ...
>
> In theory, an Oracle session could be as small or as large as you can
> imagine. Nearly.
>
> Cheers
>
> Richard
Received on Thu Jul 29 2004 - 12:46:38 CDT