Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!west.cox.net!cox.net!newsfeed-east.nntpserver.com!nntpserver.com!news.sprintnetops.net!not-for-mail
From: "Jim Stern" <jdstern@k2services.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle Portal -- DB Performance Tuning -- any tips ?
Date: Thu, 10 Oct 2002 19:44:18 -0400
Organization: Sprint Advanced Network Services
Lines: 46
Message-ID: <ao53ck$frm$1@news.utelfla.com>
References: <3DA4367C.AEA5931F@singnet_nospam.com.sg>
NNTP-Posting-Host: 208.31.229.178
X-Trace: news.utelfla.com 1034293461 16246 208.31.229.178 (10 Oct 2002 23:44:21 GMT)
X-Complaints-To: usenet@news.utelfla.com
NNTP-Posting-Date: Thu, 10 Oct 2002 23:44:21 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163802
X-Received-Date: Thu, 10 Oct 2002 16:44:19 MST (news.easynews.com)

Hemant,

There was a bug about high connection usage with Portal 3.0.9.8.3 and lower
that was supposedly fixed in the latest release.  Check metalink for the
bug, and upgrade to the terminal release of Portal ASAP.

Jim


"Hemant K Chitale" <hkchital_nospam@singnet_nospam.com.sg> wrote in message
news:3DA4367C.AEA5931F@singnet_nospam.com.sg...
>
> Has anyone experiences to share on DB Performance Tuning
> for Oracle Portal  [DB 8.1.7.2 for Oracle Portal 3.0.9.8.0 as part of
> iAS 1.0.2.2,
> not yet having upgraded the Portal to 3.0.9.8.3 or 3.0.9.8.4] ?
>
> Our portal implementation seems to have the following characteristics :
>   1.  Each page has 4 to 6 portlets  [some are HTML, others
> StoredProcedures]
>   2.  Every time a user visits a page, each of the portlets makes a
> seperate
> connection to the database, executes the procedure and disconnects.
> [ie,
> 4 to 6 connect-execute-disconnect calls for each page for each
> visitor].  I
> tried setting the "connection-pooling" or "connection-reuse" feature in
> the modplsql gateway settings but this suddenly caused the number of
> database
> sessions to go up from 40-60 to 200 in a matter of minutes.  Apparently,
> there's
> a few bugs logged and a couple of notes advising not to use this
> feature, particularly
> if you have Intermedia Indexing enabled -- which we have.  So I had to
> set the
> connection-reuse back to No.
>   3.  StatsPack indicates high waits on log-file-sync. OK, the LGWR may
> be
> slow writing to redo logs --- but this is a Portal, why are we having a
> large number
> of writes/transactions/commits in the first place ?
>
> Hemant
> hemant k chitale