Re: Number of active http requests keep growing

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Wed, 6 Feb 2008 07:41:38 -0800 (PST)
Message-ID: <674a3d9c-1c9e-42b9-a68e-784b4e719ec2@l32g2000hse.googlegroups.com>


On Feb 6, 10:35 am, gazzag <gar..._at_jamms.org> wrote:
> On 6 Feb, 15:05, Steve Howard <stevedhow..._at_gmail.com> wrote:
>
>
>
> > Also, what do you get when you type...
>
> > show processes
> > show sessions
>
> > Regards,
>
> > Steve
>
> SQL> show processes
> SP2-0158: unknown SHOW option "processes"
> SQL> show sessions
> SP2-0158: unknown SHOW option "sessions"
>
> SQL> show parameter processes
>
> NAME TYPE VALUE
> ------------------------------------ ----------- -----------
> aq_tm_processes integer 0
> db_writer_processes integer 1
> gcs_server_processes integer 0
> job_queue_processes integer 10
> log_archive_max_processes integer 2
> processes integer 150
>
> SQL> show parameter sessions
>
> NAME TYPE VALUE
> ------------------------------------ ----------- -----------
> 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
>
> :-)
>
> HTH
>
> -g

LOL! less than three cups of coffee...less than three cups of coffee...less than three cups of coffee...less than three cups of coffee... Received on Wed Feb 06 2008 - 09:41:38 CST

Original text of this message