Re: session resource consumption?

You can use the v$sesstat view joined with v$statname to see how much pga and uga memory they consume.
They probably still *will* consume that memory. You should also be able to find cpu consumed, though I would guess that is 0.

Hth,

Sybrand Bakker, Oracle DBA

"gdas" <gdas1NOgdSPAM_at_yahoo.com.invalid> wrote in message news:1446b4e4.56ab75ff_at_usw-ex0102-015.remarq.com...
> Thanks in advance for any help on this...
>
> How much system resources does a single and inactive session
> take up. I'm not sure if there is a way to calculate the
> memory/cpu allocation. If not, would you say that this is
> neglible or is it significant?
>
> Our development team made a large number of changes to the way
> the application interacts with the database in the last few
> days. The database seems to be running much slower however...
>
> Unfortunately, I have to try to back track the individual
> changes to try to find the source of the problem.
>
> The first item I'm investigating is a change to use connection
> pooling. The application now grabs and holds connections on the
> oracle database.
>
> When I checked v$session, there were 120 connections being held
> by the application, but all were in an inactive state.
> The orace machine is running NT and it's a dev/test machine, so
> it's not all that powerful.
>
> Could this be the problem. Do inactive sessions consume
> significant resources?
>
> Thanks!
> Gavin
>
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Sun Jul 23 2000 - 00:00:00 CDT