Re: IIS 4.0 asp - Oracle 8 Problem

What does a query against v$session reveal?

select status, machine, process, count(*) from v$session group by status, machine, process;

select status, machine, count(*) from v$session group by status, machine;

select status, count(*) from v$session
group by status;

I worked an issue with Oracle and Microsoft that exhibited similar behavior. While I could minimize the impact and get the load to about 60 users per server, I could find no way to completely eliminate the issue under MTS / NT4.

Note that I only observed the issue with components that were participating in distributed transactions. This behavior never manifested with non-transactional connections, nor with connections using local transactions.

I have found a solution with COM+, but this requires object pooling and manual enlistment in the distributed transactions. This is not an option for a scripting language.

My observations also lead me to believe that it is a side effect of connection pooling; the interaction of JIT activation (even on Win2K) seems to aggravate the problem.

Mike

<donfranke_at_my-deja.com> wrote in message news:8btm9g$j8l$1_at_nnrp1.deja.com...
> Gerald,
>
> You're not alone. Same setup (except all ASP, no Perl) and same
> symptoms. I've been using PerfMon to monitor Web Service | Current
> Connections. When that number gets to be around 40 that's when I know
> the server is out to lunch. It's intersting you have isolated it to an
> Oracle connection attempt. Have you tried the turning off Connection
> Pooling suggestion?
>
> I will try this also; if still no luck I will install the latest MDAC
> SP though I really don't want to (not a big ODBC fan),
>
>
> Don
>
>
> In article <8bj9m4$ni3$1_at_lnews.actcom.co.il>,
> "Gerald Berkovics" <gerald_at_coral.co.il> wrote:
> > Hi.
> >
> > Background:
> >
> > I work on an application written in asp using perlscript.
> > The database I use is Oracle 8. I use the oracle odbc driver, because
 the
> > microsoft odbc
> > driver for oracle has all kind of problems.
> >
> > The application runs on NT4 + IIS 4 + sp6a, and the oracle is on
 another
> > unix computer.
> >
> > Problem:
> >
> > It seems that my applications hungs sometime.
> > It happens 1 - 3 times per day (with days that it works okay).
> > The IIS continue to serve html pages.
> > The IIS continue to serve asp pages that do not contain database
> > connections.
> > I've check network and looks okay.
> > At the oracle database everything looks okay.
> >
> > After my checks, I came to the following conclusions :
> > The problem happens because any call the Connection.open hungs the
 specific
> > asp page that
> > tries to make the connection.
> > The timeout is very short but does not affect, and We dont return
 from the
> > connection.open.
> >
> > Probably the problem is at the asp to odbc provider or the oracle
 driver.
> >
> > If i make connections from other places, through the same odbc, it
 works at
> > the same moment when it
> > doesnt work from the asp environment.
> >
> > Also, If i write a cgi in perl , it success to connect also.
> >
> > From this i conclude that the problem is like asp application loosing
> > connection to the provider or something.
> >
> > Ususaly the cpu is at 50% when this happens. Since the application
 server
> > has 2 cpu's, this probably means
> > that an asp is blocked at the connection and cpu is wasted o this
 block.
> >
> > IIS cannot be stoped from the services panel, so we must kill it or
 restart
> > the server.
> >
> > I wonder if others have already encounters this problem, and if yes
 how did
> > they solved it.
> >
> > Also, I would like to know if theree are debugging tools or other
 utilities
> > out there that can help me
> > find the exact location of problem.
> >
> > Thanks, Gerald.
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Apr 01 2000 - 00:00:00 CEST