Oracle-L: HP Superdome Server tuning

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Mon, 28 Apr 2003 09:11:39 -0800
Message-ID: <F001.0058AA1D.20030428091139@fatcity.com>

For a Hybrid Transaction Mix Benchmark :-

init.ora parameters hpux_sched_noage=178 already set

Any Advisable Kernel parameters / O.S. Tuning for HP Superdome Server/64way ?

Database Server :-
O.S. version HP 11.11
Storage = XP1024
Number of CPUs = 64
RAM = 256 GB Will give any Details required

Thanks

-----Original Message-----

Sent: Saturday, April 26, 2003 7:07 PM
To: Multiple recipients of list ORACLE-L

Vivek:

What is the current setting of the parameter hpux_sched_noage?

Best Regards,
K Gopalakrishnan

-----Original Message-----

VIVEK_SHARMA
Sent: Saturday, April 26, 2003 6:17 AM
To: Multiple recipients of list ORACLE-L

We are Doing an OLTP Transaction Benchmark & getting the following contention "CPU time "
on HP Super Dome machines with XP1024 Storage

How may this be addressed ?

Any Best Practice Kernel parameters that may be set for HP Server ?

Thanks

     Snap Id     Snap Time      Sessions Curs/Sess Comment
            ------- ------------------ -------- --------- ------------------


-

Begin Snap:                          265 26-Apr-03 04:44:27    1,276

18.6

  End Snap:                          266 26-Apr-03 04:59:33    1,276

18.7

   Elapsed:                               15.10 (mins)

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~                                                     %
Total
Event                                               Waits    Time (s) Ela

Time
-------------------------------------------- ------------ ----------- ------
--

CPU time                                                        1,175
79.07
log file sync                                     132,814         166
11.17
log file parallel write                           129,139         101
6.82
latch free                                            751          32
2.16
rdbms ipc reply                                       203          10
.68
          -------------------------------------------------------------

P.S. will provide any details needed

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: K Gopalakrishnan
INET: kaygopal_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message