error in alert log.

[AnthonySN]

>Or setting some configuration value to not do so many.
have changed nproc, what else do you suggest.

>Less sessions?
cant be done since this application is used by all over the branches.

>You have reserved that space for growth. If you don't want to grow, you shouldn't reserve so much.
How do i unreserve.

[Dennis Handly]

>so I cant get the swapinfo -tam output now.

Is your SGA value larger now?

You may want to look at these recent threads and see how to use ps(1) to see how much VM is being used by each process:
http://forums.itrc.hp.com/service/forums/questionanswer.do?threadId=1411399

[TTr]

> the application is now migrated to this new system

Did you also upgrade the oracle version? And/or the application version?

With the information given so far, there is nothing wrong with your setup. Either your application environment has grown (much more data, larger database, more users, more features) or your application needs a good cleanup.

Did you look at the "ps -ef" listing? Can you identify everything that is running as being valid? Can you post it here so we can look at it?

[AnthonySN]

the old system was hpux 11.11 and oracle 8i
its almost a year now since we migrated.
data has increased but the no. of oracle session was almost the same ie 1600+
We had rebooted the server one time and the memory usage was normal.
when the no of sessions in oracle touches 1600 swapinfo shows.

[TTr]

>We had rebooted the server one time and the memory usage was normal.

You need to look at the process mix and identify any runaway processes. When the users kick-off an oracle job and then disconnect, that job many times continues to run consuming resources. You need to identify and cleanup those processes.

[AnthonySN]

>You need to identify and cleanup those processes
there are approx 1700 session how do i monitot each session.is there a better way to do it.

[AnthonySN]

problem got resolved after adding increasing the ram to 32 GB.