Re: Number of active http requests keep growing

Result of the query:

Machine: sr-svx-722.unifr.ch   Inst_id:1     Count: 12
Machine: sr-svx-722   Inst_id:1     Count: 16

Show parameter processes:
aq_tm_processes integer 1
db_writer_processes integer 1

gcs_server_processes   integer 0
job_queue_processes   integer 10
log_archive_max_processes   integer 2

Show parameter sessions:
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1 sessions integer 170
shared_server_sessions integer

pher

"Steve Howard" <stevedhoward_at_gmail.com> wrote in message news:074a3348-3f9a-43e0-b4a6-4841bdf9442b_at_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 Fri Feb 08 2008 - 04:19:24 CST