RE: Performance - quick question
Date: Mon, 19 Dec 2011 17:40:36 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD3157509_at_MISOUT7MSGUSR9D.ITServices.sbc.com>
Take a look at the Oracle package calibrate_io to get a rough sense of your i/o capabilities. I think it is standard in 11.1 onwards.
For RAC, just a quick list of things to check-
- RAC interconnect is properly tuned (jumbo frames turned on, MTU=9000)
- INITRANS - ITL on tables and indexes properly set for objects with high concurrency.
- Sequences have cache settings properly set
- make sure RedHat has its network settings properly allocated (via /etc/sysctl.conf)
DBMS_RESOURCE_MANAGER.CALIBRATE_IO
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of mek s
Sent: Monday, December 19, 2011 4:33 AM
To: ORACLE-L
Subject: Performance - quick question
Hello,
We are using RAC 11gR2 under Redhat Linux 5 (4 nodes). We are in the
process of testing the performance of our system before pushing it to
production.
Application team will inject load testing and we take the decision to consider the database servers are highly loaded when the CPU usage of DB server will be 70% of usage (this is just a number we decided (DB team) ).
We need to collect from database side some metrics like Storage IOPS (Read + Write) and TPS so then we can say; For this number of transactions / seconds we reached this number of IOPS storage. so we will have an idea of the performance limit our system can reach (baseline).
I believe these metrics can be found in AWR reports, right? Any idea of the way to get them calculated? Please share your experience,this is the first time, I do it.
Cheers,
S
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 19 2011 - 11:40:36 CST