Re: sqlplus scott/tiger@tnsname hangs

Thanks Jared. As you mentioned this is one of the Bank's high hitter application. I tried to find out why the database is running on shared server mode but could not find any answer from the people who are managing the database . opened a SR but the support wants me to trace a event on the next occurrance and get back to me . which may not be a small wait . so I will just keep my fingers crossed until the next occurrance.

On Tue, Apr 22, 2008 at 5:51 PM, Jared Still <jkstill_at_gmail.com> wrote:

> On Mon, Apr 21, 2008 at 5:47 PM, Prasad <p4cldba_at_gmail.com> wrote:
> >
> > virtual circuit buffers 34,514,923
> > virtual circuit queues 15,313,379
> > virtual circuits 7,641,167
> >
> > logon cumulative doesnt show very high
> >
> > logons cumulative 1,382 0.2 0.0
> >
>
> Sorry, I don't know too much about shared servers.
>
> I also don't know over what period of time the VC stats took place.
>
> Without the time component, and an indication that the shared servers
> are the bottleneck, it's rather difficult to make any statement about it.
>
> Does your database have a very large number of simultaneous connections?
>
> Just curious why shared servers are being used.
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

--
http://www.freelists.org/webpage/oracle-l