Re: QueuePool and ORA-12519
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Tue, 17 Aug 2010 05:35:13 -0700 (PDT)
Message-ID: <771876d0-ca97-4b46-9aec-467b32e5bda2_at_w30g2000yqw.googlegroups.com>
On Aug 16, 10:24 am, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> sajup:
>
> > how can i find optimal Queue pool size?
>
> Try the relevant performance tuning guide for your release ... all the
> Oracle documentation is free.
>
> One url ishttp://tahiti.oracle.com
Date: Tue, 17 Aug 2010 05:35:13 -0700 (PDT)
Message-ID: <771876d0-ca97-4b46-9aec-467b32e5bda2_at_w30g2000yqw.googlegroups.com>
On Aug 16, 10:24 am, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> sajup:
>
> > how can i find optimal Queue pool size?
>
> Try the relevant performance tuning guide for your release ... all the
> Oracle documentation is free.
>
> One url ishttp://tahiti.oracle.com
John, actually I think this is the sqlnet queue so try this
LISTENER=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521)
(QUEUESIZE=20)))
The default queue varies by platform such as Solaris is only 5 while
Windows NT is 50.
Ref: OracleŽ Database Net Services Administrator's Guide 10g Release 2 (10.2) Part Number B14212-02 Ch 10. Configuring and Administering the Listener
HTH -- Mark D Powell -- Received on Tue Aug 17 2010 - 07:35:13 CDT