swapinfo information

[mehul_3]

OS version ::HP-UX11.11
Oracle version :: 9.2.0.1.0
How many instances on this system :: One Instance

Following are kernel settings
maxssiz 134217728
maxssiz_64bit 1073741824
maxdsiz 1073741824
maxdsiz_64bit 2147483648
maxtsiz 67108864
maxtsiz_64bit 1073741824
shmmax 2147483648

We have increased shmmax from 536870912 to 2147483648 to fit entire SGA and(Which is 1500MB,PGA 600MB) but problem still persists.

Note:Physical RAM is 3GB.
Concurrent user 25

Regards,
Mehul

[RAC_1]

You did not provide this.

What is oracle version??
How many instances on this system??

[mehul_3]

already provided pl.check it.

Regards,
Mehul

[RAC_1 · Accepted solution]

Get shminfo tool and check shared memory usage. I also inclined towards reducing the SGA. try it.

[Yogeeraj_1]

hi again,

can you post the output of "show sga"

login to the database as '/ as sysdba'

regards
yogeeraj

[Rita C Workman]

Set up some disk for swap and set it up so it will be there when you reboot too. That will keep you from totally choking out for the moment. I notice you only have lvol2.

[Memory total is the total of all available and would include the lvol2 disk]

3Gb is not alot of memory running anything Oracle over 8i. You need to look at increasing this, cause the newer versions of Oracle just keep putting more of a strain on memory, so you also need to look at all your kernel parms.
Post all your parms...and let folks look them over, there may be a few others that could be suggested for changes to help.

Just a thought,
Rgrds,
Rita