--- Rob Fegan <[Email Address Removed] wrote:
> Hi Kevin,
> One option might be to create a separate tns
> service name for the instance for use by dba's in
> such events. Then create a separate listener for
> this service, specifying the prespawn_max parameter,
> say with a value of 5. Starting this separate
> listener once the database has started should create
> 5 dedicated server processes which you can then use
> in such circumstances e.g. sqlplus
> [Email Address Removed] Hope this helps,
> Rob
>
> >>> Kevin Shao <[Email Address Removed] 05/31/01 04:30PM
> >>>
> I have application talks to an Oracle db, it opens
> 50
> connection session pool every time. It does not
> terminates itself, but be manuelly killed. However,
> after the application grabs all the sessions, I can
> not even log on to the db, nor other maintnence jobs
> are performed.
>
> Please advise: It there any way I can do to receive
> several sessions for DBA use only? or what is the
> best
> method to solve such a situation?
>
> Thanks in advance
>
> Kevin
>
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail -
> only $35
> a year! http://personal.mail.yahoo.com/
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed]
> To subscribe: send a blank email to
> oracledba-[Email Address Removed]
> Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
Oracle LazyDBA home page