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@instance
Thanks
bob
LOCALUSER@MYDB -> select count(*) from v$session;
COUNT(*)
----------
26
LOCALUSER@MYDB -> select count(*) from v$process;
COUNT(*)
----------
37
LOCALUSER@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@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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
