Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: PMON seems to not close sessions in a timely manner eg "Max

RE: PMON seems to not close sessions in a timely manner eg "Max

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Thu, 26 Dec 2002 21:18:42 -0800
Message-ID: <F001.00522D1E.20021226211842@fatcity.com>


 What do you get when run this on the server hosting Oracle:

 lsnrctl services

 Waleed

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 12/26/02 3:49 PM

Waleed, thanks for the reply here is what I have

I have 26 sessions and 34 process, only one of which (my sqlplus session) that seems to indicate shared
The rest seem to be remanents of the stored procedure.

At the point of running this test, it was only myself monitoring and the developer repeadatly running his app which never ran the processses > 37 in about 15 min

How else can I analyse this?

Im wondering why only one session is in shared mode and the remainder are dedicated? And what mandates a shared connection over a dedicated?

My sql+ which initiated the shared session was simply username/passwd_at_instance

Thanks
bob

LOCALUSER_at_MYDB -> select count(*) from v$session;

  COUNT(*)


        26

LOCALUSER_at_MYDB -> select count(*) from v$process;

  COUNT(*)


        37

LOCALUSER_at_MYDB -> select
decode(username,'SECUSER','LOCALUSER',NULL,'IS_NULL', username), status,   program, server from v$session;

DECODE(US STATUS PROGRAM
SERVER

--------- --------
----------------------------------------------------------------
---------

IS_NULL ACTIVE ORACLE.EXE
DEDICATED
IS_NULL ACTIVE ORACLE.EXE
DEDICATED
IS_NULL ACTIVE ORACLE.EXE
DEDICATED
IS_NULL ACTIVE ORACLE.EXE
DEDICATED
IS_NULL ACTIVE ORACLE.EXE
DEDICATED
IS_NULL ACTIVE ORACLE.EXE
DEDICATED
username INACTIVE dbsnmp.exe
DEDICATED
LOCALUSER INACTIVE sqlplusw.exe
NONE
LOCALUSER INACTIVE sqlplusw.exe
NONE
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
NONE
LOCALUSER ACTIVE sqlplusw.exe
SHARED
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
DEDICATED
LOCALUSER INACTIVE
DEDICATED 26 rows selected.

> Do you know if the connections (sessions) created for the web
> app are shared or dedicated? If it's dedicated, did you try
> to connect using sqlplus from that win2k server and other hosts?
>
> Trying to isolate the problem?
>
> Regards,
>
> Waleed
>
>
> -----Original Message-----
> Sent: Thursday, December 26, 2002 10:44 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> > Does your app connect to the database using the listener or
> > directly (BEQ) without specifying a connect string?
> >
> > It should connect using the listener and a connect string.
> >
> > Regards,
> >
> > Waleed
> >
>
> Waleed
>
> Yes, it's a web application and uses a listener. The listener
> entry has not been modified. There was a vague reference in
> the MTS docs that eluded to using a special connection
> string. But I got the impression that you would use a special
> connection string *if* you wanted the abillity to chooose
> between direct connection or mts (shared).
>
> In my case Id simply like to have all connections to use MTS.
>
> Should I be using a special connection string or listener
> entry? If so where can I find some examples
>
> Here is my asp application connection string (using the
> Oracle OLEDB provider wich is current)
> Connect=Provider=OraOLEDB.Oracle;PLSQLRSet=1;Password=z;Persis
> t Security Info=True;User ID=me;Data Source=mydb
>
> Here is my traditional sql+ connection
> username/password_at_instance
>
> So, Im wondering what type of "special" connection string I'd
> need for mts (if that's the case)
>
> Listener entry
> (SID_DESC =
> (GLOBAL_DBNAME =mydb)
> (ORACLE_HOME = C:\Oracle\Ora81)
> (SID_NAME = mydb)
> )
>
> This is on win2k server, Oracle 8.1.7
>
> Thanks!
> bob
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: bmetelsky_at_cps92.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).
-- 
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).
Received on Thu Dec 26 2002 - 23:18:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US