Database memory

[mike73]

For some reason, I shutdown the database and it freeze up 500 M of memory which is 1/4 of the entire database server. I understand that each user logged in the system will allocate certain memory them but when they logged off the system I thought those allocated memory will be released. Is there any set up I have to config in the init.ora for it automatically to release the memory whn the user logged off.

Please give me some detail and solutions of how to handle it.

Thanks

[sambavan]

What is the DB and OS name and versions?

Sam

[mike73]

sorry,

it's Linux, but I like to get some ideas so we can configure in 200 server

[sambavan]

Without knowing the version of oracle you are working with, I cannot say anything.

Sam

[mike73]

it's 8.1.6

Thanks

[tamilselvan]

In some OS ( particulary NT) setting a huge shared_pool_size may cause the entire system hanging. To solve this problem, log in as system and flush out the shared pool.
The command is:
ALTER SYSTEM FLUSH SHARED_POOL ;

In Unix, you can find how much memory is being by each user process, by running pmap (pid) command.
If you think it occupies more memory and it is hanging for long time, you can kill the process.