RE: Docs, Links, Good Books on Performance with RAC 10.2 / Solaris 10 ?

Thanks Zhu Chao for the info.

1 Question - If you mean CPU usage DOUBLED when using Shared Servers with RAC ?

A basic Qs - Is setting up shared servers for RAC similar to it's setup for single instance (NON-RAC) ?

Any Good Docs, Links, Books, metalink Doc IDs, Pointers to Oracle Documentation for Performance with RAC?

I will periodically send e-mails on our progress though the benchmark is tentatively planned to start after about 1 month.

Regards

From: Zhu,Chao [mailto:zhuchao_at_gmail.com] Sent: Wednesday, August 30, 2006 6:37 PM To: VIVEK_SHARMA
Subject: Re: Docs, Links, Good Books on Performance with RAC 10.2 / Solaris 10 ?

hi,
  You might want to try dedicated server, to compare with shared server. We hit severe capacity problem when we change from dedicated server to shared server. CPU usage simply doubled. Dispature used half of total cpu, which is a great overhead.

   However we are running on 9205/solaris8. But I think basicly they should be same.

   If you can get some benchmark between shared server/dedicated, please drop me an email. Oracle is saying to provide us with patch for that problem , And I am interested in how it is doing on oracle 10.

Thanks

--

Regards
Zhu Chao
www.cnoug.org <http://www.cnoug.org>

On 8/30/06, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:

Folks

For an upcoming High Hybrid (OLTP + Batch) Transaction Load Benchmark on RAC with Solaris 10/Oracle 10g,

need Good Docs, Links, Books, metalink Doc IDs, Pointers to Oracle Documentation for Performance.

Benchmark Config info:-

Approx 30,000 Concurrent OLTP sessions will be spawned

Application = Banking

Num of Database Server Nodes = 4

Each DB Server Node = 28 CPUs

DB Server model = SF25000

Oracle Shared Servers will be used

DB Size = 4 TB

Thanks indeed

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***
  --
  http://www.freelists.org/webpage/oracle-l