DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;  s=s1024; d=yahoo.com;  h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Message-ID;  b=kXip647qo07HkfB5m3Jtx5eqmI4OBgLrW3Qliv81cECfr+bjZzvX3VBjiTpzosTdbKgaJTztHMd717dulCpdMUT8Z2zxUzoIEBHQNmGTSqEILWftc04UwbIUpsV9sRXrOlMKif9L7lQ5rRn1laWJ1Fr8WCk3y1syb1ocTO9THFk=;
Date: Fri, 12 Sep 2008 10:42:18 -0700 (PDT)
From: Yong Huang <yong321@yahoo.com>
Subject: Re: 10g RAC and defined services performance problem
To: oracle-l@freelists.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Message-ID: <107023.22281.qm@web80603.mail.mud.yahoo.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: yong321@yahoo.com

> Has anybody run into specific problems with 
> performance when using a lot of services

Jon,

I didn't measure. But I suppose if you have too many services, Oracle has to work harder to maintain all the service related performance views v$service% or the underlined tables, and service$. It reminds me of the old advice to not create too many tablespaces. But since all tablespaces are LMT now, the overhead is much smaller. (There's one thing common between ts$ and service$: "deleted" tablespaces/services stay in the table, although they can be reused if the same named tablespace/service is recreated.) Another concern is the limit of services, 100 as of 10.2.0.1 according to Jeremy Schneider's paper.

We have more than 10 services in our database. We created a generic one that handles all small applications and dedicated ones each for each of the bigger apps.

Yong Huang


--
http://www.freelists.org/webpage/oracle-l