FAQ
Hi,
the limit of connections on my Dedicated Server
is 400.
The Server is on Windows NT
I have a script that kills all conections that fails
due to communication.
When I run the The script, the status of the sessions change into kill
but it takes a long time to really kill them.
How Can I free those connections faster?

Regards,
Mauricio Vélez

Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vélez"
INET: oraclemavelgo_at_yahoo.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • Khedr, Waleed at Nov 6, 2003 at 9:34 pm
    Did you try orakill?

    -----Original Message-----
    Sent: Thursday, November 06, 2003 4:14 PM
    To: Multiple recipients of list ORACLE-L

    Hi,
    the limit of connections on my Dedicated Server
    is 400.
    The Server is on Windows NT
    I have a script that kills all conections that fails
    due to communication.
    When I run the The script, the status of the sessions change into kill
    but it takes a long time to really kill them.
    How Can I free those connections faster?

    Regards,
    Mauricio Velez

    Do you Yahoo!?
    Protect <http://antispam.yahoo.com/whatsnewfree> your identity with Yahoo!
    Mail AddressGuard

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Khedr, Waleed
    INET: Waleed.Khedr_at_FMR.COM

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Mladen Gogala at Nov 6, 2003 at 9:59 pm
    PMON has to perform rollback on the behalf of the killed session and relinquish
    any resources that the session might be holding. Alter system disconnect session
    immediate will relinquich the server process faster, but PMON will have more
    work. Other then that, 'coz it's windoze, try with ctrl-alt-delete while holding
    NMI button on the housing of the computer. Your sessions will get killed instantly.
    On 11/06/2003 04:14:25 PM, Mauricio V?lez wrote:
    Hi,
    the limit of connections on my Dedicated Server
    is 400.
    The Server is on Windows NT
    I have a script that kills all conections that fails
    due to communication.
    When I run the The script, the status of the sessions change into kill
    but it takes a long time to really kill them.
    How Can I free those connections faster?

    Regards,
    Mauricio V?lez


    ---------------------------------
    Do you Yahoo!?
    Protect your identity with Yahoo! Mail AddressGuard
    Mladen Gogala
    Oracle DBA

    Note:
    This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
    Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Mladen Gogala
    INET: mladen_at_wangtrading.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Paul Drake at Nov 7, 2003 at 10:59 pm
    dead connection detection is supposed to work on 9.2.0.4, but I can't seem to find any docs on this. has anyone exmained this?


    thanks,


    Pd

    "Khedr, Waleed" wrote:
    Did you try orakill?
    -----Original Message-----
    Sent: Thursday, November 06, 2003 4:14 PM
    To: Multiple recipients of list ORACLE-L

    Hi,
    the limit of connections on my Dedicated Server
    is 400.
    The Server is on Windows NT
    I have a script that kills all conections that fails
    due to communication.
    When I run the The script, the status of the sessions change into kill
    but it takes a long time to really kill them.
    How Can I free those connections faster?

    Regards,
    Mauricio Vélez

    Do you Yahoo!?
    Protect your identity with Yahoo! Mail AddressGuard

    Do you Yahoo!?
    Protect your identity with Yahoo! Mail AddressGuard
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Paul Drake
    INET: discgolfdba_at_yahoo.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 6, '03 at 9:14p
activeNov 7, '03 at 10:59p
posts4
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase