calculate server process memory allocation
From: Elir <elire_at_amdocs.com>
Date: 31 Jul 2001 01:15:00 -0700
Message-ID: <e7cbfa45.0107310015.fdfc155_at_posting.google.com>
7 ;
10359039
Date: 31 Jul 2001 01:15:00 -0700
Message-ID: <e7cbfa45.0107310015.fdfc155_at_posting.google.com>
Hi
I need to know how much memory oracle allocate after new connection (
no activity made on the process )(in idle mode).
I use the below query to calculate this .
SQL> select sum(value) from v$parameter where name in
2 ('bitmap_merge_area_size',
3 'create_bitmap_area_size',
4 'hash_area_size',
5 'open_cursors',
6 'sort_area_size')
7 ;
SUM(VALUE)
10359039
I what to know if this mean that in each idle process on my oracle db
use 10M ?
Do I use the right query ?
Tnx Received on Tue Jul 31 2001 - 10:15:00 CEST