Re: MTS tuning

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Fri, 17 May 2002 17:13:29 GMT
Message-ID: <3ce539bc.350897914@news.globix.com>

On Thu, 16 May 2002 11:50:33 +0530, "Pinto" <ucanmailme_at_india.com> wrote:

>These applications are scheduled to execute some taks on the switch. they
>use Database basically for logging. since these exes access Database very
>often (40 times per minute) our database monitoring activites are done by
>scheduling these jobs. there are many fornt end tools used which connect to
>database but they are not very DB intensive.

looks like your application needs some tuning... same app shouldn't login 40times/min.

>Any idea why cpu activity has almost doubled?
>does it help if the DB intensive logging exe's access DB using dedicated
>connections?

probably.. you can use both dedicated and MTS connections at the time, just define different strings in tnsnames.ora. question is, is there are a lot of such processes.. b/c is there are, u'd still have to use MTS.
.......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes remove NSPAM to email Received on Fri May 17 2002 - 12:13:29 CDT