Jonathan,
My interconnect capacity is 2Gbits/sec. and want to see the traffic at
about 2Gbits/sec. between 2 rac instances (one instance per node of
course).
I have 10(user) sessions on first instance running oci loop (these
clients
dont take much cpu time) udating 10 table/user of 250k rows and select
count(*) of all tables from another instance, this doesnt generate
much interconnect traffic. I found that dedicated processes not
responding
very quickly. I tried with different number of clients - no
difference.
Right now I just only care about interconnect traffic.
btw. what does your pl/sql loop do, select/update/insert/delete.
wonder if that performance problem is because of interconnect or some
other
reason like CPU reached its saturation.
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<bms28h$f8o$1$830fa79f_at_news.demon.co.uk>...
> What do you mean by 'stress out' the
> interconnect ? Do you want the RAC
> instances to suffer from performance
> problems, or do you want the interconnect
> to have more traffic than it can handle ?
>
> I managed to cause massive performance problems
> with RAC using the hp/compaq/whatever high speed
> interconnect (Memory Channel Architecture ?) with
> just one session per CPU running a pl/sql loop.
>
> I don't know if the actual interconnect was overloaded -
> but the sessions were losing time on nothing but
> global lock management.
>
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> The educated person is not the person
> who can answer the questions, but the
> person who can question the answers -- T. Schick Jr
>
>
> One-day tutorials:
> http://www.jlcomp.demon.co.uk/tutorial.html
> ____Iceland__November (tbc)
> ____Belgium__November (EOUG event)
> ____UK_______December (UKOUG conference)
>
>
> Three-day seminar:
> see http://www.jlcomp.demon.co.uk/seminar.html
> ____USA__October
> ____UK___November
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> "gdb_dsr" <ge_2000_2001_at_yahoo.com> wrote in message
> news:6299d152.0310171111.e5669de_at_posting.google.com...
> > Hi,
> >
> > I need to staturate 2 node RAC-9201/Linux interconnect, obviously it
> needs
> > lot of load. I used about 10 sessions one user each on each node
> with oci
> > programs and change 15k rows continuously. I dont see much traffic
> > (CPUs (4 xenon), scsi disk io are far below to their capacity).
> > I dont see any bottelneck.
> > (I tried sql scripts to update and retrive but they are too slow)
> > I can go for more sessions but for some of the sessions oracle is
> not
> > responsive for a while. In other words some times they are fast some
> times
> > too slow.
> >
> > Does any one knows any better options or environment setup in the
> oracle
> > to exploit to saturate interconnect (ethernet) card.
> >
> > Thank you.
Received on Sun Oct 19 2003 - 04:25:41 CDT
