[wiery]

By the sounds of things you need to tune your virtual memory settings rather than just keep adding paging space. On an oracle box, there should be very little if no paging at all. If you have 20GB of physical memory, there should ideally be no need for any more than 12 -14 GB paging space and even at that, you would hope for very little paging activity.

[alexisl]

We were okay on the paging space until we went to Oracle 10g, it seems to do a lot more in memory than 9i. Now we barely use any CPU and a lot of memory. I know we should be able to "tweak" Oracle so that it is not such a hog but my DBA has not researched how to do it nor do I think that he wants to do it.

[wiery]

Its pretty straight forward really, there are a good number of IBM /Oracle docs available. One other thing i would say in relation to your paging spaces is that they are very uneven. It is recommended that you create them all approx the same size, this will prevent the 8GB in your case being fully used before the others get used. Ideally you would create multiple paging spaces of equal size on different volumes. This way they get equal load and one disk is not hammered by paging.

I can post up the link of some Oracle docs if you want. It is only a 10 min job in most cases but i would recommend you put through your test environment first, just in case.

[alexisl]

We were thinking of adding the paging to paging00:
Grits:root:/# lsps -a
Page Space Physical Volume Volume Group Size %Used Active Auto Type
paging01 hdisk3 rootvg 8320MB 99 yes yes lv
paging00 hdisk0 rootvg 19200MB 76 yes yes lv
paging00 hdisk2 rootvg 1024MB 76 yes yes lv

which is on 2 hdisks, is there a way to specify that we want it on hdisk2? When I looked at smit chps it only asks which space and how many PPs

[kinay61]

If you have a logical volume in inner or middle, you must move it --> To verify

Then you create your paging space and after you can move it.

Use the commande 'lslv -l YourLV' before and after the move of the lv, it shows you the repartition

[kierong]

The question Kinya61 asked about "CIO" or "DIO" is very important. I guessing that your Oracle database is using filesystem space not raw logical volumes. If that is the case then you should consider mounting the filesystems containing the database with the CIO option. Do not use CIO if the filesystem contains binaries. This may very well improve performance and lower paging. Read Oracle's recommendations on CIO.

[alexisl]

When I do lslv paging00 this is what I get:
Grits:root:/usr/users/datatel# lslv paging00
LOGICAL VOLUME: paging00 VOLUME GROUP: rootvg
LV IDENTIFIER: 00c42efd00004c0000000105ba468d37.12 PERMISSION: read/write
VG STATE: active/complete LV STATE: opened/syncd
TYPE: paging WRITE VERIFY: off
MAX LPs: 512 PP SIZE: 128 megabyte(s)
COPIES: 2 SCHED POLICY: parallel
LPs: 158 PPs: 316
STALE PPs: 0 BB POLICY: non-relocatable
INTER-POLICY: minimum RELOCATABLE: yes
INTRA-POLICY: center UPPER BOUND: 32
MOUNT POINT: N/A LABEL: None
MIRROR WRITE CONSISTENCY: off
EACH LP COPY ON A SEPARATE PV ?: yes
Serialize IO ?: NO

Is that where it should be?

I have gone into smit fs but cannot find anything saying CIO or DIO, we are using enhanced journaled file system but that is all I can tell

[kinay61]

The CIO or DIO options is use when you mount your FS
mount -o cio /yourFS

How is the amount of memory use by your Oracle ?
Are you sure what all memory is really use by Oracle ?

[kierong]

issue the command lsfs and under the Options column it will show what options are in effect. i.e. "cio,rw" or "rw". If after researching CIO you want to turn it on, you need to unmount the filesystem, add cio as an option for that filesystem in /etc/filesystems and mount the filesystem.

[alexisl]

kinay61 - We do have Java running also but other than that it is just Oracle and root.

kierong - Under options it just has rw so I guess we are not running CIO