top troubles!!

[Lorenzo Facello]

Hi All,
I have a 11.0 with 5GB memory
1 - when I start top in the field MEMORY I have:

Memory: 650668K (218448K) real, 578820k (274444k) virtual, 1139916k free

Could you explain me this field... I got some infos on itrc but I'm really confused...

2 - always with top I have 4 oracle proc in sleep with a size 1850 MB!!!!!!! It's dangerous??? ( in attach the top's output)

the field SIZE: is the allocated mem of that proc or is the maximum size that the proc can reach???

Really thanks in advance!
L.F

[Eric Antunes]

Hi Lorenzo,

From the manual:

1 - "Memory Data
Includes virtual and real memory in use (with the amount of memory considered "active" in parentheses) and the amount of free memory.

2 - "SIZE
Total virtual size of the process in kilobytes. This includes virtual sizes of text, data, stack, uarea, mmap regions, shared memory regions and IO mapped regions.

You have such a big SIZE value because of values defined at the following init.ora parameters:

shared_pool_size = ?
db_block_buffers = ?

Best Regards,

Eric Antunes

[Eric Antunes]

To see if you have a shared_pool_size well defined, execute the following query:

select name, bytes/1024/1024 "Free Size in MB"
from v$sgastat
where name='free memory';

I think that if the free size is more than 20% of shared_pool_size, then you may reduce it...

Eric

[Steve Steel]

Hi

Top is a fun aide memoire but if you need real memory data go to

ftp://eh:spear9@hprc.external.hp.com/memory.htm

The information and tools are top class


Steve Steel