Regarding system parameters for Oracle DB with 2 instance

[Satish Kumar_5]

Dear All,

We are running 2 instance of oracle database on rp3440 with 8 gb RAM and 4 processors.Now i want to know whether we need to double the parameters specified by oracle eg nproc=4096 for one instance.What will be the optimized setting for kernel. We are running HP-UX 11i.if anyone have a same kind of setup pls suggest. we are using Oracle EBS 11.5.9, oracle apps with Databse.

Regs
Satish

[RAC_1]

In any case 2048 is too low. Try setting it to 20000. Observe the real time usage with
sar -v 5 5
glance -t

If it is unneccesarily high set it slightly low.

Anil

[Fred Ruffet]

Oracle prerequisites are a basis you have to work on.
To follow your example of nproc, it specifies the maximum number of processes allowed to be launched at a time. If each database is configured for a max processes number of 100, 4096 is enough.
So it depends on your Oracle configuration for each DB. Even with one DB, you may have to increase parameter given by Oracle.

Regards,

Fred

[Satish Kumar_5]

Hi,

We have around 800 process on both DBs.So i think nproc is fine. but still when we execute some command it took a second or 2 before executing. i have checked load and its not more than 5 total.. sar output for ur ref:

HP-UX ERP3 B.11.11 U 9000/800 12/01/04

19:09:52 %usr %sys %wio %idle
19:09:57 0 3 0 96
19:10:02 2 4 1 94
19:10:07 1 3 2 95
19:10:12 1 3 0 95
19:10:17 0 3 0 96

Average 1 3 1 95

whats wrong?? any help will be very appreciated.
regs
Satish

[Eric Antunes]

Hi,

Check:

#sar -b 5 15

And:

#sar -v 5 15

And finally:

#swapinfo -tam

Best Regards,

Eric

[Fred Ruffet]

could you post output for these :
sar -ubw 10 6 # this one will run 1 minute
swapinfo -tam

Regards,

Fred

[Fred Ruffet]

Oups, I forgot this command :
top -n $(ps -edf | wc -l) -f /tmp/frutopfile.$$ && cat /tmp/frutopfile.$$ && rm /tmp/frutopfile.$$

Regards,

Fred

[Satish Kumar_5]

Hi,

Thanks so much to u all guys. I m attaching the output of commands u were asking. pls have a look and suggest. Thanks Again

[Eric Antunes]

Hi Satish,

From the output of top, it seems you are using more than 1200Mb for the Oracle SGA (System Global Area) and Buffer Cache. In my opinion, this is too much... You need to tune this 2 paramaters: See Metalink Note 100709.1

Kindest Regards,

Eric

[Fred Ruffet]

Eric,

Why is this too much ? With 8GB of RAM, 1.2GB allocated for oracle is not much.

Satish,

You're talking about 2 instances, and I can only see one. top output may not be ful as long as We don't have header, and I don't see vhand (wich was my goal). I would really like to see the line from top for vhand process (and optinally uptime).

Regarding to stats you're system is swapping, and (yes, once again) I'm asking what is your settings for OS dbc.
Could you please give output for "mount" command (without parameter) and for those two :
kmtune -q dbc_max_pct
kmtune -q dbc_min_pct
Also, do you have Online JFS ?

It makes many command I ask for, but I have an idea behind all of that :)

Regards,

Fred