Zongk_Tu wrote:
>> Arne:
>>
>> Oracle recommends two times the physical memory for the SWAP ...
>>
>> Sounds like you need to tune your Primary & Secondary Swap for your OS
>> ...
>>
>> More importantly, once you have your Instance up & running,
>>
>> you need to sum all of your SZ or VSZ coulmn from 'ps -o' command
>> ..(Posix ps).
>>
>> and then multiply that with 4K page size..
>>
>> That will be the total Virtual Set Size for your Instance ...
>>
>> So you will have to boot to a single user mode & resize your swap ..
>>
- NO - swap can be expanded or additional page lvs added dynamically in AIX.
norm
>> Unlesss you have tools like IGNITE-UX in the HP-UX world...
>>
>> HTH
>>
>> zongk Tu
>>
>> Oracle Apps DBA/Unix SA
>>
>> Arne S wrote:
>>
>>> Aixers!
>>>
>>> I've got a problem that all of a sudden came up after update of AIX to
>>> ML09 and upgrade of Oracle from 7.4.3 to 8.1.7: The machine is sometimes
>>> slowing down, and at the end I have to turn it off and back on again.
>>> After the machine is up again, I find this error in the error log:
>>> *********************************************
>>> LABEL: PGSP_KILL
>>> IDENTIFIER: C5C09FFA
>>>
>>> Date/Time: fre 02-04-26 05:33:
>>> Sequence Number: 3811
>>> Machine Id: 0040AD3A4C00
>>> Node Id: bsprod
>>> Class: S
>>> Type: PERM
>>> Resource Name: SYSVMM
>>>
>>> Description
>>> SOFTWARE PROGRAM ABNORMALLY TERMINATED
>>>
>>> Probable Causes
>>> SYSTEM RUNNING OUT OF PAGING SPACE
>>>
>>> Failure Causes
>>> INSUFFICIENT PAGING SPACE DEFINED FOR THE SYSTEM
>>> PROGRAM USING EXCESSIVE AMOUNT OF PAGING SPACE
>>>
>>> Recommended Actions
>>> DEFINE ADDITIONAL PAGING SPACE
>>> REDUCE PAGING SPACE REQUIREMENTS OF PROGRAM(S)
>>>
>>> Detail Data
>>> PROGRAM
>>> oracle
>>> USER'S PROCESS ID:
>>> 66786
>>> PROGRAM'S PAGING SPACE USE IN 1KB BLOCKS
>>> 152
>>> *********************************************
>>> Could it be the the valuse of "ulimit -a"? My new Oracle 8.1.7 is owned
>>> by the user "oracle8" instead of the old "oracle".
>>> ulimit -a for oracle:
>>> $ ulimit -a
>>> time(seconds) unlimited
>>> file(blocks) unlimited
>>> data(kbytes) unlimited
>>> stack(kbytes) unlimited
>>> memory(kbytes) unlimited
>>> coredump(blocks) unlimited
>>> nofiles(descriptors) unlimited
>>>
>>> ulimit -a for oracle8:
>>> $ ulimit -a
>>> time(seconds) unlimited
>>> file(blocks) unlimited
>>> data(kbytes) 131072
>>> stack(kbytes) 32768
>>> memory(kbytes) 32768
>>> coredump(blocks) unlimited
>>> nofiles(descriptors) 2000
>>>
>>> Info about the environment:
>>> 2 * RS/6000
>>> AIX 4.3.3-09
>>> Hacmp 4.3.1 (cluster.base.server.rte 4.3.1.16)
>>> SSA disks in concurrent VG
>>> Oracle 8.1.7.0.0 (raw device for db files)
>>> Mem 2GB
>>> Paging 2GB
>>>
>>> Any ideas??
>>>
>>> TIA!
>>>
>>> Arne S
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
Received on Sat Apr 27 2002 - 10:50:26 CDT