Re: Number of active http requests keep growing

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Wed, 6 Feb 2008 07:05:17 -0800 (PST)
Message-ID: <074a3348-3f9a-43e0-b4a6-4841bdf9442b@i72g2000hsd.googlegroups.com>


On Feb 6, 8:18 am, "pher" <chapk..._at_hotmail.com> wrote:
> Hello all
> I already posted this to comp.databases.oracle.misc, but I believe it's
> better here:
>
> in our Enterprise Manager 10g, the number of active HTTP connections and
> requests keep growing at a rate of 16/minute. I'm reaching now 60,000 and
> it's still growing. But on the server, the netstat -a command gives only
> about 200 connections, most ESTABLISHED, some TIME_WAIT. Any hint on how and
> what to search for would be appreciated.

Hi Pher,

What do you mean by "active connections"? What do you get when you run the following in SQL*PLUS...

select count(*),machine,inst_id from gv$session group by machine,inst_id;

Also, what do you get when you type...

show processes
show sessions

Regards,

Steve Received on Wed Feb 06 2008 - 09:05:17 CST

Original text of this message