Oracle 9.2 on Suse 7.2 S390

[Nilson Vieira]

Hello All,


I've been pondering these questions for some time now.  I have a 9672 G4 running Suse 
Linux 7.2 Lpar mode  with
Oracle 9.2. We have 1.5 GB of RAM, 115 Mips  processor/no float point, with  100% 
utilization almost all the time.


Linux configuration:

echo 100 32000 100 100   > /proc/sys/kernel/sem

echo 2147483648              > /proc/sys/kernel/shmmax

echo 8192                           > /proc/sys/kernel/shmmni

echo 2097152                    > /proc/sys/kernel/shmall

echo 65536                        > /proc/sys/fs/file-max

ulimit -n 65536

echo 1024 65000              > /proc/sys/net/ipv4/ip_local_port_range



Oracle�s configuration:

        Shared Pool: 144mb
        Buffer Cache: 500mb

        Java Pool: 16mb

        Block Size: 8192k

        Sort Area: 1,5mb

        Log Buffer: 500kb


        db_writer_processes = 1

        sga_max_size = 709mb


My questions:


        What do i to get a better performance ?
        Wich software should i use to monitor performance  (with documentation)? 
        How much a no float point processor can influence in a negative performance ?
        What are my options ?




Thanks,
Nilson