Re: Number of active http requests keep growing

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 Received on Wed Feb 06 2008 - 09:35:22 CST