RE: Can't connect MTS from remote.

[Wendry]

Thanks for the answer Stephen,

I can ping and tnsping the server, in fact my connection using dedicated
server is working. But when I add initialization parameter for MTS in
init.ora like I have mentioned before, the connections are always fail,
looks like the listener can’t redirect connection to a dispatcher or the
dispatcher accept and immediately disconnect connection?? Since from
lsnrctl services command the number of established connection with
dispatcher shows increment even though the connection is failed. Btw, I
set my oracle on Windows 2000 environment. Any other ideas about the
problem here?

Thank you all in advance.

Regards

Wendry.


-Original Message-
Karniotis, Stephen
Sent: Tuesday, December 30, 2003 9:24 PM
To: Multiple recipients of list ORACLE-L

Generally, 12545 means that something in the connection string for
shared
environments is missing, the listener.ora, tnsnames.ora and sqlnet.ora
contain conflicting parameters, or the init.ora MTS parameters do not
match
the listener.ora.

I would make sure that you can ping the server remotely and that you can
TNSPING the server as well.  If not, your .ORA settings are
inconsistent.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED] 
Web:www.compuware.com 

 -Original Message-
Wendry
Sent:   Tuesday, December 30, 2003 8:54 AM
To: Multiple recipients of list ORACLE-L
Subject:Can't connect MTS from remote.

Dear all,

II have set up MTS on my environment (oracle 8.1.6.0.0), but I can't
connect through remote computers. The error is ora-12545 : target or
host doesn't exists.

My init.ora regarding to MTS goes like this.
mts_dispatchers = (PROTOCOL=TCP)(dispatchers=10)(sessions=20)
mts_max_dispatchers = 25
mts_servers = 5
mts_max_servers = 30

I also add clause (SERVER = SHARED) on all tnsnames.ora files.

I have also tried to use 2 listener namely listener_mts which I set to
port 1522, I use this especially to handle the MTS connection. So I add
in my init.ora
Local_listener = mts1

And in my tnsnames.ora
mts1 =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = server2000)(PORT = 1522))
)
(CONNECT_DATA =
  (SERVICE_NAME = sheet.almi.net)
  (SERVER = SHARED)
)
  )
I still can't connect to the database with message of can't establish
connection for this type of server. So I omit the   (SERVER =
SHARED) part. I can connect, but the connection is DEDICATED instead of
MTS. I know this by querying SERVER column of V$session and there's no
entry on V$circuit. V$shared_servers shows 5 entry.

Is there anyone has experience like I have? Please give me some input
here. Thank you all in advance.

Regards,

Wendry.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wendry
  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).



The contents of this e-mail are intended for the named addressee only.
It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or
disclose
it to anyone else. If you received it in error please notify us
immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Karniotis, Stephen
  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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wendry
  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

RE: Can't connect MTS from remote.

[Mercadante, Thomas F]

Wendry,

My experience with MTS is that, by default, the listener uses an MTS
connection.  I wonder why you are not getting that.

My init.ora file looks like this:

mts_dispatchers =
(ADDRESS=(PROTOCOL=TCP)(HOST=ip_address))(DISPATCHERS=5)
local_listener  =
(ADDRESS=(PROTOCOL=TCP)(HOST=ip_address)(PORT=1521))
mts_max_dispatchers = 10
mts_servers = 10
mts_max_servers = 100

and my listener.ora file looks like this:

Fsldbdol0a1advwtw =
  (DESCRIPTION_LIST= 
(DESCRIPTION= 
  (ADDRESS_LIST= 
(ADDRESS= 
  (PROTOCOL=IPC)
  (KEY=EXTPROCdbdol0a1advwtw)
)
(ADDRESS= 
  (PROTOCOL=TCP)
  (HOST=ip_address)
  (PORT=1521)
)
  )
)
  )

Note that I do not name my databases in the listener.ora file as the
databases self-register with the listener via the local_listener line in the
init.ora.

My tnsnames file then looks like this:

WTWT = # Shared connection
  (DESCRIPTION= 
(ADDRESS_LIST= 
  (ADDRESS= 
(PROTOCOL=TCP)
(Host=ip_address)
(Port=1521)
  )
)
(CONNECT_DATA= 
  (SID=WTWT)
)
  )

WTWT_DEDICATED =
  (DESCRIPTION= 
(ADDRESS_LIST= 
  (ADDRESS= 
(PROTOCOL=TCP)
(Host=ip_address)
(Port=1521)
  )
)
(CONNECT_DATA= 
  (SID=WTWT)
  (SERVER = DEDICATED)
)
  )


My guess is that you still have something small not quite right.  Tns
connections can be the most exasperating thing to deal with.  The smallest
detail can kill you.

Good Luck


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 31, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L


Thanks for the answer Stephen,

I can ping and tnsping the server, in fact my connection using dedicated
server is working. But when I add initialization parameter for MTS in
init.ora like I have mentioned before, the connections are always fail,
looks like the listener can't redirect connection to a dispatcher or the
dispatcher accept and immediately disconnect connection?? Since from
lsnrctl services command the number of established connection with
dispatcher shows increment even though the connection is failed. Btw, I
set my oracle on Windows 2000 environment. Any other ideas about the
problem here?

Thank you all in advance.

Regards

Wendry.


-Original Message-
Karniotis, Stephen
Sent: Tuesday, December 30, 2003 9:24 PM
To: Multiple recipients of list ORACLE-L

Generally, 12545 means that something in the connection string for
shared
environments is missing, the listener.ora, tnsnames.ora and sqlnet.ora
contain conflicting parameters, or the init.ora MTS parameters do not
match
the listener.ora.

I would make sure that you can ping the server remotely and that you can
TNSPING the server as well.  If not, your .ORA settings are
inconsistent.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED] 
Web:www.compuware.com 

 -Original Message-
Wendry
Sent:   Tuesday, December 30, 2003 8:54 AM
To: Multiple recipients of list ORACLE-L
Subject:Can't connect MTS from remote.

Dear all,

II have set up MTS on my environment (oracle 8.1.6.0.0), but I can't
connect through remote computers. The error is ora-12545 : target or
host doesn't exists.

My init.ora regarding to MTS goes like this.
mts_dispatchers = (PROTOCOL=TCP)(dispatchers=10)(sessions=20)
mts_max_dispatchers = 25
mts_servers = 5
mts_max_servers = 30

I also add clause (SERVER = SHARED) on all tnsnames.ora files.

I have also tried to use 2 listener namely listener_mts which I set to
port 1522, I use this especially to handle the MTS connection. So I add
in my init.ora
Local_listener = mts1

And in my tnsnames.ora
mts1 =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = server2000)(PORT = 1522))
)
(CONNECT_DATA =
  (SERVICE_NAME = sheet.almi.net)
  (SERVER = SHARED)
)
  )
I still can't connect to the database with message of can't establish
connection for this type of server. So I omit the   (SERVER =
SHARED) part. I can connect, but the connection is DEDICATED instead of
MTS. I know this by querying SERVER column of V$session and there's no
entry on V$circuit. V$shared_servers shows 5 entry.

Is there anyone has experience like I have? Please give me some input
here. Thank you all in advance.

Regards,

Wendry.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wendry
  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

Can't connect MTS from remote.

[Wendry]

Dear all,

II have set up MTS on my environment (oracle 8.1.6.0.0), but I can’t
connect through remote computers. The error is ora-12545 : target or
host doesn't exists.

My init.ora regarding to MTS goes like this.
mts_dispatchers = (PROTOCOL=TCP)(dispatchers=10)(sessions=20)
mts_max_dispatchers = 25
mts_servers = 5
mts_max_servers = 30

I also add clause (SERVER = SHARED) on all tnsnames.ora files.

I have also tried to use 2 listener namely listener_mts which I set to
port 1522, I use this especially to handle the MTS connection. So I add
in my init.ora
Local_listener = mts1

And in my tnsnames.ora
mts1 =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = server2000)(PORT = 1522))
)
(CONNECT_DATA =
  (SERVICE_NAME = sheet.almi.net)
  (SERVER = SHARED)
)
  )
I still can't connect to the database with message of can't establish
connection for this type of server. So I omit the   (SERVER =
SHARED) part. I can connect, but the connection is DEDICATED instead of
MTS. I know this by querying SERVER column of V$session and there's no
entry on V$circuit. V$shared_servers shows 5 entry.

Is there anyone has experience like I have? Please give me some input
here. Thank you all in advance.

Regards,

Wendry.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wendry
  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).

RE: Can't connect MTS from remote.

[Karniotis, Stephen]

Generally, 12545 means that something in the connection string for shared
environments is missing, the listener.ora, tnsnames.ora and sqlnet.ora
contain conflicting parameters, or the init.ora MTS parameters do not match
the listener.ora.

I would make sure that you can ping the server remotely and that you can
TNSPING the server as well.  If not, your .ORA settings are inconsistent.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED] 
Web:www.compuware.com 

 -Original Message-
Wendry
Sent:   Tuesday, December 30, 2003 8:54 AM
To: Multiple recipients of list ORACLE-L
Subject:Can't connect MTS from remote.

Dear all,

II have set up MTS on my environment (oracle 8.1.6.0.0), but I can't
connect through remote computers. The error is ora-12545 : target or
host doesn't exists.

My init.ora regarding to MTS goes like this.
mts_dispatchers = (PROTOCOL=TCP)(dispatchers=10)(sessions=20)
mts_max_dispatchers = 25
mts_servers = 5
mts_max_servers = 30

I also add clause (SERVER = SHARED) on all tnsnames.ora files.

I have also tried to use 2 listener namely listener_mts which I set to
port 1522, I use this especially to handle the MTS connection. So I add
in my init.ora
Local_listener = mts1

And in my tnsnames.ora
mts1 =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = server2000)(PORT = 1522))
)
(CONNECT_DATA =
  (SERVICE_NAME = sheet.almi.net)
  (SERVER = SHARED)
)
  )
I still can't connect to the database with message of can't establish
connection for this type of server. So I omit the   (SERVER =
SHARED) part. I can connect, but the connection is DEDICATED instead of
MTS. I know this by querying SERVER column of V$session and there's no
entry on V$circuit. V$shared_servers shows 5 entry.

Is there anyone has experience like I have? Please give me some input
here. Thank you all in advance.

Regards,

Wendry.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wendry
  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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Karniotis, Stephen
  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).

MTS v$session

[Wiegand, Kurt]

Title: MTS v$session






I've got an 8.1.7.4.0 instance running under Solaris 2.8.


I've never worked with MTS before, but got a call from a user telling me that there

were about 700 rows in v$session but they only had about 130 sessions open.

The user believes that when the session is ended, v$session doesn't (or doesn't always)

get cleaned up. Does anyone have any insight into this? Thanks.


I checked v$process and had about 89 rows, which matched exactly to the 89 unix processes that I had on the box.


I looked at paddr in v$session and saw that there were just over 100 rows pointing to each of the 6 dispatchers.

The other rows each had their own dedicated process.


I checked v$dispatcher and saw the 100+ values in the OWNED column, but also saw values between 300 - 450 in

the CREATED column.

  

I really don't know whether the application ends it's connections gracefully or nongracefully.


Kurt Wiegand Cable  Wireless Communications 703 292-2115

Re: MTS v$session

[Rachel Carmichael]

did you look at the status column in v$session for the ones that don't
match?

IIRC, there can be a status of SNIPED where the session is not
actually connected but has not been cleaned up.

curiosity -- why is a user looking at v$session?
--- Wiegand, Kurt [EMAIL PROTECTED] wrote:
 I've got an 8.1.7.4.0 instance running under Solaris 2.8.
 
 I've never worked with MTS before, but got a call from a user telling
 me that there
 were about 700 rows in v$session but they only had about 130 sessions
 open.
 The user believes that  when the session is ended, v$session doesn't
 (or doesn't always)
 get cleaned up.  Does anyone have any insight into this?  Thanks.
 
 I checked v$process and had about 89 rows, which matched exactly to
 the 89 unix processes that I had on the box.
 
 I looked at paddr in v$session and saw that there were just over 100
 rows pointing to each of the 6 dispatchers.
 The other rows each had their own dedicated process.
 
 I checked v$dispatcher and saw the 100+ values in the OWNED column,
 but also saw values between 300 - 450 in
 the CREATED column.
   
 I really don't know whether the application ends it's connections
 gracefully or nongracefully.
 
 Kurt Wiegand  Cable  Wireless Communications  703 292-2115
 
 


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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).

RE: MTS v$session

[Nuala Cullen]

Title: MTS v$session



Hi 
Kurt,

Have 
you set the sqlnet.expire_time in the sqlnet.ora file?

N.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Wiegand, 
  KurtSent: 01 August 2003 16:19To: Multiple recipients of 
  list ORACLE-LSubject: MTS v$session
  I've got an 8.1.7.4.0 instance running under 
  Solaris 2.8. 
  I've never worked with MTS before, but got a call 
  from a user telling me that there were 
  about 700 rows in v$session but they only had about 130 sessions open. 
  The user believes that when the session is 
  ended, v$session doesn't (or doesn't always) get cleaned up. Does anyone have any insight into this? 
  Thanks. 
  I checked v$process and had about 89 rows, which 
  matched exactly to the 89 unix processes that I had on the box. 
  I looked at paddr in v$session and saw that there 
  were just over 100 rows pointing to each of the 6 dispatchers. 
  The other rows each had their own dedicated 
  process. 
  I checked v$dispatcher and saw the 100+ values in 
  the OWNED column, but also saw values between 300 - 450 in the CREATED column. 
   
   I 
  really don't know whether the application ends it's connections gracefully or 
  nongracefully. 
  Kurt Wiegand Cable 
   Wireless Communications 703 
  292-2115 

RE: MTS v$session

[Wiegand, Kurt]

Title: MTS v$session



Yes; 
at least on the server side. 


# 
SQLNET.ORA Network Configuration File: 
/u01/app/oracle/product/817/network/admin/sqlnet.ora# Generated by Oracle 
configuration tools.#NAMES.DIRECTORY_PATH= 
(TNSNAMES)SQLNET.EXPIRE_TIME= 10

  -Original Message-From: Nuala Cullen 
  [mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003 12:34 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  MTS v$session
  Hi 
  Kurt,
  
  Have 
  you set the sqlnet.expire_time in the sqlnet.ora file?
  
  N.
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of Wiegand, 
KurtSent: 01 August 2003 16:19To: Multiple recipients 
of list ORACLE-LSubject: MTS v$session
I've got an 8.1.7.4.0 instance running under 
Solaris 2.8. 
I've never worked with MTS before, but got a call 
from a user telling me that there were 
about 700 rows in v$session but they only had about 130 sessions 
open. The user believes that when 
the session is ended, v$session doesn't (or doesn't always) get cleaned up. Does anyone have any insight into 
this? Thanks. 
I checked v$process and had about 89 rows, which 
matched exactly to the 89 unix processes that I had on the box. 
I looked at paddr in v$session and saw that there 
were just over 100 rows pointing to each of the 6 dispatchers. 
The other rows each had their own dedicated 
process. 
I checked v$dispatcher and saw the 100+ values in 
the OWNED column, but also saw values between 300 - 450 in the CREATED column. 
 
 I 
really don't know whether the application ends it's connections gracefully 
or nongracefully. 
Kurt Wiegand Cable 
 Wireless Communications 703 
292-2115 

RE: MTS v$session

[Wiegand, Kurt]

Title: RE: MTS v$session






No, they are not SNIPED; I've worked with those before.

They are in fact all INACTIVE. I suspect they are waiting on the

client for their next messages. As for your 2nd question:

I've got 7 users with the DBA role on this database! Why?

I'm too new here to ask. I view them as users/support personnel.


Kurt


-Original Message-

From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]

Sent: Friday, August 01, 2003 11:34 AM

To: Multiple recipients of list ORACLE-L

Subject: Re: MTS v$session



did you look at the status column in v$session for the ones that don't

match?


IIRC, there can be a status of SNIPED where the session is not

actually connected but has not been cleaned up.


curiosity -- why is a user looking at v$session?

--- Wiegand, Kurt [EMAIL PROTECTED] wrote:

 I've got an 8.1.7.4.0 instance running under Solaris 2.8.

 

 I've never worked with MTS before, but got a call from a user telling

 me that there

 were about 700 rows in v$session but they only had about 130 sessions

 open.

 The user believes that when the session is ended, v$session doesn't

 (or doesn't always)

 get cleaned up. Does anyone have any insight into this? Thanks.

 

 I checked v$process and had about 89 rows, which matched exactly to

 the 89 unix processes that I had on the box.

 

 I looked at paddr in v$session and saw that there were just over 100

 rows pointing to each of the 6 dispatchers.

 The other rows each had their own dedicated process.

 

 I checked v$dispatcher and saw the 100+ values in the OWNED column,

 but also saw values between 300 - 450 in

 the CREATED column.

   

 I really don't know whether the application ends it's connections

 gracefully or nongracefully.

 

 Kurt Wiegand Cable  Wireless Communications 703 292-2115

 

 



__

Do you Yahoo!?

Yahoo! SiteBuilder - Free, easy-to-use web site design software

http://sitebuilder.yahoo.com

-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.net

-- 

Author: Rachel Carmichael

 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).

RE: MTS v$session

[Rachel Carmichael]

okay that sounds a lot like the connection got broken (PC turned off,
sqlnet expire time, which I see you've set, etc) badly

being a newbie is the perfect time to ask. You can sound totally
innocent (I was just wondering how you have things set up here)


--- Wiegand, Kurt [EMAIL PROTECTED] wrote:
 No, they are not SNIPED; I've worked with those before.
 They are in fact all INACTIVE.  I suspect they are waiting on the
 client for their next messages.  As for your 2nd question:
 I've got 7 users with the DBA role on this database! Why?
 I'm too new here to ask.  I view them as users/support personnel.
 
 Kurt
 
 -Original Message-
 Sent: Friday, August 01, 2003 11:34 AM
 To: Multiple recipients of list ORACLE-L
 
 
 did you look at the status column in v$session for the ones that
 don't
 match?
 
 IIRC, there can be a status of SNIPED where the session is not
 actually connected but has not been cleaned up.
 
 curiosity -- why is a user looking at v$session?
 --- Wiegand, Kurt [EMAIL PROTECTED] wrote:
  I've got an 8.1.7.4.0 instance running under Solaris 2.8.
  
  I've never worked with MTS before, but got a call from a user
 telling
  me that there
  were about 700 rows in v$session but they only had about 130
 sessions
  open.
  The user believes that  when the session is ended, v$session
 doesn't
  (or doesn't always)
  get cleaned up.  Does anyone have any insight into this?  Thanks.
  
  I checked v$process and had about 89 rows, which matched exactly to
  the 89 unix processes that I had on the box.
  
  I looked at paddr in v$session and saw that there were just over
 100
  rows pointing to each of the 6 dispatchers.
  The other rows each had their own dedicated process.
  
  I checked v$dispatcher and saw the 100+ values in the OWNED column,
  but also saw values between 300 - 450 in
  the CREATED column.
  
  I really don't know whether the application ends it's connections
  gracefully or nongracefully.
  
  Kurt Wiegand  Cable  Wireless Communications  703 292-2115
  
  
 
 
 __
 Do you Yahoo!?
 Yahoo! SiteBuilder - Free, easy-to-use web site design software
 http://sitebuilder.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Rachel Carmichael
   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).
 


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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).

RE: MTS v$session

[Goulet, Dick]

Title: MTS v$session



First 
question I would have is Why does a user have access to V$SESSIONS in the first 
place?

Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 

  -Original Message-From: Wiegand, Kurt 
  [mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003 11:19 
  AMTo: Multiple recipients of list ORACLE-LSubject: MTS 
  v$session
  I've got an 8.1.7.4.0 instance running under 
  Solaris 2.8. 
  I've never worked with MTS before, but got a call 
  from a user telling me that there were 
  about 700 rows in v$session but they only had about 130 sessions open. 
  The user believes that when the session is 
  ended, v$session doesn't (or doesn't always) get cleaned up. Does anyone have any insight into this? 
  Thanks. 
  I checked v$process and had about 89 rows, which 
  matched exactly to the 89 unix processes that I had on the box. 
  I looked at paddr in v$session and saw that there 
  were just over 100 rows pointing to each of the 6 dispatchers. 
  The other rows each had their own dedicated 
  process. 
  I checked v$dispatcher and saw the 100+ values in 
  the OWNED column, but also saw values between 300 - 450 in the CREATED column. 
   
   I 
  really don't know whether the application ends it's connections gracefully or 
  nongracefully. 
  Kurt Wiegand Cable 
   Wireless Communications 703 
  292-2115 

Does mts affect explain plans of queries

[Rodrigues, Bryan]

Hi everyone,

I have a development, test and production databases (They are on HP-UX 11.0
with Oracle 8.1.7.4). The development and test databases are setup for Multi
Threaded Server (MTS) and production is not (We are still considering
whether or not to put it on production, another story). But during the
normal day, code is built, changed and tuned. I don't have any particular
example, but some of the code that works fine in development and test works
very differently in production. The data that exists in development and test
is comparable to what is in production. The only difference I see is that
development and test are using MTS and production is not.

The questions I see are: Would mts affect explain plans of queries to such a
degree that they would run differently in a non MTS database? Does the
optimizer care whether mts is being used?

TIA,

Bryan Rodrigues
DBA
Elcom, Inc.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rodrigues, Bryan
  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).

Re: JDBC and MTS

[Mladen Gogala]

On 2003.06.17 01:04, Richard Ji wrote:
I used to seen problems with JDBC Thin with MTS on Linux and switching to
a dedicated connection seemed to fix the problem.  But JDBC Thin and MTS
worked fine on my Solaris box.  Not sure with HP-UX.  Is the Java application
running on an Application Server?
Yes it is. Application server is a Solaris8 box (SUN 450).

--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 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).

RE: JDBC and MTS

[Regis Biassala]

Richard is right...If ur Java application uses it own connection
pooling...then do not use MTS...it slows down connections and more...We
faced the same issue here

Our configuration allows DBA to choose weather connection pooling should
handled by the app or the database...
Use dedicated servers if there's noway you can disable the application
connection pooling...


Regis

-Original Message-
Sent: Tuesday, June 17, 2003 6:05 AM
To: Multiple recipients of list ORACLE-L


I used to seen problems with JDBC Thin with MTS on Linux and switching to
a dedicated connection seemed to fix the problem.  But JDBC Thin and MTS
worked fine on my Solaris box.  Not sure with HP-UX.  Is the Java
application
running on an Application Server?

Richard Ji

-Original Message-
Sent: Monday, June 16, 2003 11:25 PM
To: Multiple recipients of list ORACLE-L


I'm not a Java expert so please forgive me my ignorance. JDBC application
is facing very strange performance problems during connect. Every now and
then 
everything appears to be hung and then, 10 minutes later, users proceed 
normally but with the elevated blood pressure and serious lack of patience.
I was told that JDBC has it's own connection pooling mechanism and that it 
will start it's own dedicated server connection. It seems though that the 
string SRVR=DEDICATED has been ignored and that users are acquiring a
shared 
server connection.
Does anybody in this group have any experience with JDBC and MTS? Version is
8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with 
listeners on all 4 nodes for load balancing purposes. I found surprisingly 
little material on the Metalink. No network collisions, no retransmits, no 
timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet
and I would be very surprised if approximately 100 users could kill it with
a
JDBC application. They could use DBA as a human sacrifice, though.



-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  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).
*
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error, 
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Regis Biassala
  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).

Re: JDBC and MTS

[Mladen Gogala]

OK. Let me get some things straight:
a) I'm not a developer. I'm one of those vile creatures called DBAs.
   I don't program. I troubleshoot other people's programs. Other people
   program, I nag. When developers start writing bug-free software which
uses the database in the most optimal way, my job is gone.
b) The whole problem is that even after specifying SRVR=DEDICATED in the
   connect string, the darned thing still connects as an MTS connection.
c) What was the issue that you faced? That was my original question.

On 2003.06.17 07:09, Regis Biassala wrote:
Richard is right...If ur Java application uses it own connection
pooling...then do not use MTS...it slows down connections and more...We
faced the same issue here
Our configuration allows DBA to choose weather connection pooling should
handled by the app or the database...
Use dedicated servers if there's noway you can disable the application
connection pooling...
Regis

-Original Message-
Sent: Tuesday, June 17, 2003 6:05 AM
To: Multiple recipients of list ORACLE-L
I used to seen problems with JDBC Thin with MTS on Linux and switching to
a dedicated connection seemed to fix the problem.  But JDBC Thin and MTS
worked fine on my Solaris box.  Not sure with HP-UX.  Is the Java
application
running on an Application Server?
Richard Ji

-Original Message-
Sent: Monday, June 16, 2003 11:25 PM
To: Multiple recipients of list ORACLE-L
I'm not a Java expert so please forgive me my ignorance. JDBC application
is facing very strange performance problems during connect. Every now and
then
everything appears to be hung and then, 10 minutes later, users proceed
normally but with the elevated blood pressure and serious lack of patience.
I was told that JDBC has it's own connection pooling mechanism and that it
will start it's own dedicated server connection. It seems though that the
string SRVR=DEDICATED has been ignored and that users are acquiring a
shared
server connection.
Does anybody in this group have any experience with JDBC and MTS? Version is
8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with
listeners on all 4 nodes for load balancing purposes. I found surprisingly
little material on the Metalink. No network collisions, no retransmits, no
timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet
and I would be very surprised if approximately 100 users could kill it with
a
JDBC application. They could use DBA as a human sacrifice, though.


--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
  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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Ji
  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).
*
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.
This footnote also confirms that this message has been swept
for computer viruses.
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Regis Biassala
  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

RE: JDBC and MTS

[DENNIS WILLIAMS]

Mladen - I'll add what I know, but it won't add much.

When the Java people say they are doing connection pooling, that almost
certainly means they are using an application server. This is the beast on
which to focus your attention. Start by finding out which species it is.
There are in my experience, a variety of settings related to AS connection
pooling. It is easy to get those settings wrong, which can produce a variety
of bad effects on the database end. They can create too many sessions, or
too few.
   In my simple view, MTS and connection pooling do the same thing. I don't
use MTS, so I'm assuming here. But I can see that using both MTS and
connection pooling at the same time might produce bad effects. 
   The other thing to remember about the thin client is that it does not use
Net8. It does not rely on a tnsnames.ora file on the client (application
server in this case). It connects directly to the listener. One possibility
to test would be to switch to the thick client. That may be better in your
situation.
   Good luck and keep us posted. We DBAs are all facing this
webbified/Javafied/.netified world and we've got to stick together.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, June 17, 2003 7:25 AM
To: Multiple recipients of list ORACLE-L


OK. Let me get some things straight:
a) I'm not a developer. I'm one of those vile creatures called DBAs.
I don't program. I troubleshoot other people's programs. Other people
program, I nag. When developers start writing bug-free software which

uses the database in the most optimal way, my job is gone.
b) The whole problem is that even after specifying SRVR=DEDICATED in the
connect string, the darned thing still connects as an MTS connection.
c) What was the issue that you faced? That was my original question.

On 2003.06.17 07:09, Regis Biassala wrote:
 Richard is right...If ur Java application uses it own connection
 pooling...then do not use MTS...it slows down connections and more...We
 faced the same issue here
 
 Our configuration allows DBA to choose weather connection pooling should
 handled by the app or the database...
 Use dedicated servers if there's noway you can disable the application
 connection pooling...
 
 
 Regis
 
 -Original Message-
 Sent: Tuesday, June 17, 2003 6:05 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I used to seen problems with JDBC Thin with MTS on Linux and switching to
 a dedicated connection seemed to fix the problem.  But JDBC Thin and MTS
 worked fine on my Solaris box.  Not sure with HP-UX.  Is the Java
 application
 running on an Application Server?
 
 Richard Ji
 
 -Original Message-
 Sent: Monday, June 16, 2003 11:25 PM
 To: Multiple recipients of list ORACLE-L
 
 
 I'm not a Java expert so please forgive me my ignorance. JDBC application
 is facing very strange performance problems during connect. Every now and
 then
 everything appears to be hung and then, 10 minutes later, users proceed
 normally but with the elevated blood pressure and serious lack of
patience.
 I was told that JDBC has it's own connection pooling mechanism and that it
 will start it's own dedicated server connection. It seems though that the
 string SRVR=DEDICATED has been ignored and that users are acquiring a
 shared
 server connection.
 Does anybody in this group have any experience with JDBC and MTS? Version
is
 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered
with
 listeners on all 4 nodes for load balancing purposes. I found surprisingly
 little material on the Metalink. No network collisions, no retransmits, no
 timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB
Ethernet
 and I would be very surprised if approximately 100 users could kill it
with
 a
 JDBC application. They could use DBA as a human sacrifice, though.
 
 
 
 --
 Mladen Gogala
 Oracle DBA
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Mladen Gogala
   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).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Richard Ji
   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

RE: JDBC and MTS

[Goulet, Dick]

Mladen,

I've found MTS to be a blessing and a curse at the same time no matter what 
language (C, ASP, JAVA, etc...) is being used.  The biggest problem with MTS is the 
number of idle shared servers that you have at any point in time.  When you connection 
request is processed by the database server any statements that need execution land in 
the shared pool's request queue.  If you have say 100 connections on the database with 
10 shared servers it only takes a 10% population of active users to exhaust your pool. 
 Yes Oracle will start additional servers up to MTS_MAX_SERVERS but don't expect it to 
respond rapidly.  More like a snail that a rocket.  You've got two options that I can 
safely recommend:

1) configure MTS_MAX_SERVERS = MTS_MIN_SERVERS = the maximum number of 
anticipated connections.
2) configure MTS_MAX_SERVERS = 2X MTS_MIN_SERVERS = 75% of the maximum number 
of anticipated connections

Option 3 is more fluid, but also takes more effort to maintain the desired 
performance.  It means programming a process or job that will occasionally wake up, 
evaluate the load on the database's shared server population  alter the mts_servers 
setting of the database dynamically.  It can be done, I do it, and is very successful.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Monday, June 16, 2003 11:25 PM
To: Multiple recipients of list ORACLE-L


I'm not a Java expert so please forgive me my ignorance. JDBC application
is facing very strange performance problems during connect. Every now and then 
everything appears to be hung and then, 10 minutes later, users proceed 
normally but with the elevated blood pressure and serious lack of patience.
I was told that JDBC has it's own connection pooling mechanism and that it 
will start it's own dedicated server connection. It seems though that the 
string SRVR=DEDICATED has been ignored and that users are acquiring a shared 
server connection.
Does anybody in this group have any experience with JDBC and MTS? Version is
8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with 
listeners on all 4 nodes for load balancing purposes. I found surprisingly 
little material on the Metalink. No network collisions, no retransmits, no 
timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet
and I would be very surprised if approximately 100 users could kill it with a
JDBC application. They could use DBA as a human sacrifice, though.



-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  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).

RE: JDBC and MTS

[Regis Biassala]

We add:
1. Application (Java)
Using a JDBC Connection Pooling (CP)feature...

2. Database
Oracle in MTS, pooling or not pooling enabled

This was not good for us...so we kept the Java pooling side of the app and
Oracle configured to run in dedicated mode.

We'got a XML policy file which disables JDBC connection pooling for our
application and gives the DBA a choice to configure a 
MTS...

So in our case we two scenarios:

1. DB(MTS) and app(without CP) this is OK

2. DB(dedicated) and app(with CP)

Regis



-Original Message-
Sent: Tuesday, June 17, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L


OK. Let me get some things straight:
a) I'm not a developer. I'm one of those vile creatures called DBAs.
I don't program. I troubleshoot other people's programs. Other people
program, I nag. When developers start writing bug-free software which

uses the database in the most optimal way, my job is gone.
b) The whole problem is that even after specifying SRVR=DEDICATED in the
connect string, the darned thing still connects as an MTS connection.
c) What was the issue that you faced? That was my original question.

On 2003.06.17 07:09, Regis Biassala wrote:
 Richard is right...If ur Java application uses it own connection
 pooling...then do not use MTS...it slows down connections and more...We
 faced the same issue here
 
 Our configuration allows DBA to choose weather connection pooling should
 handled by the app or the database...
 Use dedicated servers if there's noway you can disable the application
 connection pooling...
 
 
 Regis
 
 -Original Message-
 Sent: Tuesday, June 17, 2003 6:05 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I used to seen problems with JDBC Thin with MTS on Linux and switching to
 a dedicated connection seemed to fix the problem.  But JDBC Thin and MTS
 worked fine on my Solaris box.  Not sure with HP-UX.  Is the Java
 application
 running on an Application Server?
 
 Richard Ji
 
 -Original Message-
 Sent: Monday, June 16, 2003 11:25 PM
 To: Multiple recipients of list ORACLE-L
 
 
 I'm not a Java expert so please forgive me my ignorance. JDBC application
 is facing very strange performance problems during connect. Every now and
 then
 everything appears to be hung and then, 10 minutes later, users proceed
 normally but with the elevated blood pressure and serious lack of
patience.
 I was told that JDBC has it's own connection pooling mechanism and that it
 will start it's own dedicated server connection. It seems though that the
 string SRVR=DEDICATED has been ignored and that users are acquiring a
 shared
 server connection.
 Does anybody in this group have any experience with JDBC and MTS? Version
is
 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered
with
 listeners on all 4 nodes for load balancing purposes. I found surprisingly
 little material on the Metalink. No network collisions, no retransmits, no
 timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB
Ethernet
 and I would be very surprised if approximately 100 users could kill it
with
 a
 JDBC application. They could use DBA as a human sacrifice, though.
 
 
 
 --
 Mladen Gogala
 Oracle DBA
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Mladen Gogala
   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).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Richard Ji
   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).
 *
 This electronic transmission is strictly confidential and intended solely
 for the addressee. It may contain information which is covered by legal,
 professional or other privilege. If you are not the intended addressee,
 you must not disclose, copy or take any action in reliance of this
 transmission. If you have received this transmission in error,
 please notify the sender

Re: JDBC and MTS

[John Shaw]

Refer to Note:139775.1 - see if this helps out - basically it says to 
configure the jdbc driver so that it has to use dedicated server - using MTS is 
the problem.
 [EMAIL PROTECTED] 6/17/2003 7:24:50 AM 

OK. Let me get some things straight:a) I'm not a developer. I'm one of 
those vile creatures called DBAs. I don't program. I 
troubleshoot other people's programs. Other people 
program, I nag. When developers start writing bug-free software 
which uses the database in the most optimal way, my job is 
gone.b) The whole problem is that even after specifying SRVR=DEDICATED in 
the connect string, the darned thing still connects as an 
MTS connection.c) What was the issue that you faced? That was my original 
question.On 2003.06.17 07:09, Regis Biassala wrote: Richard is 
right...If ur Java application uses it own connection pooling...then do 
not use MTS...it slows down connections and more...We faced the same 
issue here  Our configuration allows DBA to choose weather 
connection pooling should handled by the app or the database... 
Use dedicated servers if there's noway you can disable the application 
connection pooling...   Regis  
-Original Message- Sent: Tuesday, June 17, 2003 6:05 AM 
To: Multiple recipients of list ORACLE-L   I used to 
seen problems with JDBC Thin with MTS on Linux and switching to a 
dedicated connection seemed to fix the problem. But JDBC Thin and 
MTS worked fine on my Solaris box. Not sure with HP-UX. Is 
the Java application running on an Application Server? 
 Richard Ji  -Original Message- Sent: 
Monday, June 16, 2003 11:25 PM To: Multiple recipients of list 
ORACLE-L   I'm not a Java expert so please forgive me my 
ignorance. JDBC application is facing very strange performance problems 
during connect. Every now and then everything appears to be hung 
and then, 10 minutes later, users proceed normally but with the elevated 
blood pressure and serious lack of patience. I was told that JDBC has 
it's own connection pooling mechanism and that it will start it's own 
dedicated server connection. It seems though that the string 
"SRVR=DEDICATED" has been ignored and that users are acquiring a 
shared server connection. Does anybody in this group have any 
experience with JDBC and MTS? Version is 8.1.7.1, 64 bit on HP-UX 11 
with OPS. Dispatchers are cross-registered with listeners on all 4 nodes 
for load balancing purposes. I found surprisingly little material on the 
Metalink. No network collisions, no retransmits, no timeouts can be seen 
from netstat -i and netstat -s. The NIC is 1GB Ethernet and I would be 
very surprised if approximately 100 users could kill it with a 
JDBC application. They could use DBA as a human sacrifice, though. 
   -- Mladen Gogala Oracle DBA 
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 
Author: Mladen Gogala 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). -- Please 
see the official ORACLE-L FAQ: http://www.orafaq.net -- 
Author: Richard Ji 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). 
* 
This electronic transmission is strictly confidential and intended 
solely for the addressee. It may contain information which is covered by 
legal, professional or other privilege. If you are not the intended 
addressee, you must not disclose, copy or take any action in reliance of 
this transmission. If you have received this transmission in 
error, please notify the sender as soon as possible.  
This footnote also confirms that this message has been swept for 
computer viruses. 
** 
 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 
Author: Regis Biassala INET: 
[EMAIL PROTECTED]  Fat City Network 
Services -- 858-538-5051 http://www.fatcity.com San Diego, 
California -- Mailing list and web 
hostin

AW: JDBC and MTS

[Stefan Jahnke]

Hi Mladen

We started evaluating MTS and JDBC Thin Driver (newest version for JDK 1.4,
running on Win2k against a test db on win2k, test db is oracle 9.2.0.3.0). I
never used SRVR=DEDICATED. I have a dispatcher running on port 5000 and a
listener on port 1521.
The only thing I do to direct the connection to either use MTS or dedicated
server is setting the port it connects to to either 1521 or 5000. That works
just fine.

Stefan


-Ursprüngliche Nachricht-
Von: Mladen Gogala [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 17. Juni 2003 14:25
An: Multiple recipients of list ORACLE-L
Betreff: Re: JDBC and MTS


OK. Let me get some things straight:
a) I'm not a developer. I'm one of those vile creatures called DBAs.
I don't program. I troubleshoot other people's programs. Other people
program, I nag. When developers start writing bug-free software which

uses the database in the most optimal way, my job is gone.
b) The whole problem is that even after specifying SRVR=DEDICATED in the
connect string, the darned thing still connects as an MTS connection.
c) What was the issue that you faced? That was my original question.

On 2003.06.17 07:09, Regis Biassala wrote:
 Richard is right...If ur Java application uses it own connection
 pooling...then do not use MTS...it slows down connections and more...We
 faced the same issue here
 
 Our configuration allows DBA to choose weather connection pooling should
 handled by the app or the database...
 Use dedicated servers if there's noway you can disable the application
 connection pooling...
 
 
 Regis
 
 -Original Message-
 Sent: Tuesday, June 17, 2003 6:05 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I used to seen problems with JDBC Thin with MTS on Linux and switching to
 a dedicated connection seemed to fix the problem.  But JDBC Thin and MTS
 worked fine on my Solaris box.  Not sure with HP-UX.  Is the Java
 application
 running on an Application Server?
 
 Richard Ji
 
 -Original Message-
 Sent: Monday, June 16, 2003 11:25 PM
 To: Multiple recipients of list ORACLE-L
 
 
 I'm not a Java expert so please forgive me my ignorance. JDBC application
 is facing very strange performance problems during connect. Every now and
 then
 everything appears to be hung and then, 10 minutes later, users proceed
 normally but with the elevated blood pressure and serious lack of
patience.
 I was told that JDBC has it's own connection pooling mechanism and that it
 will start it's own dedicated server connection. It seems though that the
 string SRVR=DEDICATED has been ignored and that users are acquiring a
 shared
 server connection.
 Does anybody in this group have any experience with JDBC and MTS? Version
is
 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered
with
 listeners on all 4 nodes for load balancing purposes. I found surprisingly
 little material on the Metalink. No network collisions, no retransmits, no
 timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB
Ethernet
 and I would be very surprised if approximately 100 users could kill it
with
 a
 JDBC application. They could use DBA as a human sacrifice, though.
 
 
 
 --
 Mladen Gogala
 Oracle DBA
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Mladen Gogala
   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).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Richard Ji
   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).
 *
 This electronic transmission is strictly confidential and intended solely
 for the addressee. It may contain information which is covered by legal,
 professional or other privilege. If you are not the intended addressee,
 you must not disclose, copy or take any action in reliance of this
 transmission. If you have received this transmission in error,
 please notify the sender

RE: JDBC and MTS

[Richard Ji]

b) I use server=dedicated, is srvr=dedicate a short hand version of
it?

-Original Message-
Sent: Tuesday, June 17, 2003 8:25 AM
To: Multiple recipients of list ORACLE-L


OK. Let me get some things straight:
a) I'm not a developer. I'm one of those vile creatures called DBAs.
I don't program. I troubleshoot other people's programs. Other people
program, I nag. When developers start writing bug-free software which
uses the database in the most optimal way, my job is gone.
b) The whole problem is that even after specifying SRVR=DEDICATED in the
connect string, the darned thing still connects as an MTS connection.
c) What was the issue that you faced? That was my original question.

On 2003.06.17 07:09, Regis Biassala wrote:
 Richard is right...If ur Java application uses it own connection
 pooling...then do not use MTS...it slows down connections and more...We
 faced the same issue here
 
 Our configuration allows DBA to choose weather connection pooling should
 handled by the app or the database...
 Use dedicated servers if there's noway you can disable the application
 connection pooling...
 
 
 Regis
 
 -Original Message-
 Sent: Tuesday, June 17, 2003 6:05 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I used to seen problems with JDBC Thin with MTS on Linux and switching to
 a dedicated connection seemed to fix the problem.  But JDBC Thin and MTS
 worked fine on my Solaris box.  Not sure with HP-UX.  Is the Java
 application
 running on an Application Server?
 
 Richard Ji
 
 -Original Message-
 Sent: Monday, June 16, 2003 11:25 PM
 To: Multiple recipients of list ORACLE-L
 
 
 I'm not a Java expert so please forgive me my ignorance. JDBC application
 is facing very strange performance problems during connect. Every now and
 then
 everything appears to be hung and then, 10 minutes later, users proceed
 normally but with the elevated blood pressure and serious lack of patience.
 I was told that JDBC has it's own connection pooling mechanism and that it
 will start it's own dedicated server connection. It seems though that the
 string SRVR=DEDICATED has been ignored and that users are acquiring a
 shared
 server connection.
 Does anybody in this group have any experience with JDBC and MTS? Version is
 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with
 listeners on all 4 nodes for load balancing purposes. I found surprisingly
 little material on the Metalink. No network collisions, no retransmits, no
 timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet
 and I would be very surprised if approximately 100 users could kill it with
 a
 JDBC application. They could use DBA as a human sacrifice, though.
 
 
 
 --
 Mladen Gogala
 Oracle DBA
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Mladen Gogala
   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).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Richard Ji
   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).
 *
 This electronic transmission is strictly confidential and intended solely
 for the addressee. It may contain information which is covered by legal,
 professional or other privilege. If you are not the intended addressee,
 you must not disclose, copy or take any action in reliance of this
 transmission. If you have received this transmission in error,
 please notify the sender as soon as possible.
 
 This footnote also confirms that this message has been swept
 for computer viruses.
 **
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Regis Biassala
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting

AW: JDBC and MTS

[Stefan Jahnke]

Hi Regis

That's basically right. As I just posted, we use MTS for development, so
that not every developer starts up a local connection pool on their
workstation and we also don't end up with too many dedicated server
processes.
But I think you're right saying that MTS and application side connection
pooling is pretty much redundant, if not even the 
source for trouble.
a) the app server should start and monitor the connection pool.
b) the client sessions (or app threads within the app server or whatever)
request connections from that pool.
c) important aspect here is the fact that the app server thinks that it
maintains a pool of readily available, permanent connections. The clients
(or whoever) will just be passed a reference to a certain connection. After
they are finished with what they want to do, they put the connection back
into the pool (plus some connection re-aquiring mechanism for dead clients
and the like).
d) That means, that with MTS, a new player shows up, as in the connections
held in the connection pool are not permanent (or dedicated in oracle
terms). That might lead to some latency while fetching a valid connection
from the pool and using it, because when you actually start using it, you
end up with some overhead since the dispatcher has to give you a
connection.
e) I don't know for sure, but has anybody ever testet some of the new
features like sharing prepared statements between connections (and the
possibility to tag a name to a statement for further information / statement
fetching) with MTS ?

So, I think it's either MTS OR Java Connection Pooling, not BOTH.

Open for bashing,
Stefan

Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.

visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp

Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
mailto:[EMAIL PROTECTED]

Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen  erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass  wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.

As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.


-Ursprüngliche Nachricht-
Von: Regis Biassala [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 17. Juni 2003 16:15
An: Multiple recipients of list ORACLE-L
Betreff: RE: JDBC and MTS


We add:
1. Application (Java)
Using a JDBC Connection Pooling (CP)feature...

2. Database
Oracle in MTS, pooling or not pooling enabled

This was not good for us...so we kept the Java pooling side of the app and
Oracle configured to run in dedicated mode.

We'got a XML policy file which disables JDBC connection pooling for our
application and gives the DBA a choice to configure a 
MTS...

So in our case we two scenarios:

1. DB(MTS) and app(without CP) this is OK

2. DB(dedicated) and app(with CP)

Regis



-Original Message-
Sent: Tuesday, June 17, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L


OK. Let me get some things straight:
a) I'm not a developer. I'm one of those vile creatures called DBAs.
I don't program. I troubleshoot other people's programs. Other people
program, I nag. When developers start writing bug-free software which

uses the database in the most optimal way, my job is gone.
b) The whole problem is that even after specifying SRVR=DEDICATED in the
connect string, the darned thing still connects as an MTS connection.
c) What was the issue that you faced? That was my original question.

On 2003.06.17 07:09, Regis Biassala wrote:
 Richard is right...If ur Java application uses it own connection
 pooling...then do not use MTS...it slows down connections and more...We
 faced the same issue here
 
 Our configuration allows DBA to choose weather connection pooling should
 handled by the app or the database...
 Use dedicated servers if there's noway you can disable the application
 connection pooling...
 
 
 Regis
 
 -Original Message-
 Sent: Tuesday, June 17, 2003 6:05 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I used to seen problems with JDBC Thin with MTS on Linux and switching to
 a dedicated connection seemed to fix the problem.  But JDBC Thin and MTS
 worked fine on my Solaris box.  Not sure with HP-UX.  Is the Java
 application
 running on an Application Server?
 
 Richard Ji
 
 -Original Message-
 Sent: Monday, June 16, 2003 11:25 PM
 To: Multiple recipients of list ORACLE-L
 
 
 I'm not a Java expert so

RE: JDBC and MTS

[Jeffrey Beckstrom]

I recall an old bug where MTS would sleep for a bit - don't recall the bug 
anymore.

Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204 [EMAIL PROTECTED] 6/17/03 12:35:20 PM 
b) I use server=dedicated, is srvr=dedicate a short hand version 
ofit?-Original Message-Sent: Tuesday, June 17, 2003 8:25 
AMTo: Multiple recipients of list ORACLE-LOK. Let me get some 
things straight:a) I'm not a developer. I'm one of those vile creatures 
called DBAs. I don't program. I troubleshoot other 
people's programs. Other people program, I nag. When 
developers start writing bug-free software which uses the 
database in the most optimal way, my job is gone.b) The whole problem is 
that even after specifying SRVR=DEDICATED in the connect 
string, the darned thing still connects as an MTS connection.c) What was the 
issue that you faced? That was my original question.On 2003.06.17 07:09, 
Regis Biassala wrote: Richard is right...If ur Java application uses it 
own connection pooling...then do not use MTS...it slows down connections 
and more...We faced the same issue here  Our 
configuration allows DBA to choose weather connection pooling should 
handled by the app or the database... Use dedicated servers if there's 
noway you can disable the application connection pooling... 
  Regis  -Original Message- 
Sent: Tuesday, June 17, 2003 6:05 AM To: Multiple recipients of list 
ORACLE-L   I used to seen problems with JDBC Thin with 
MTS on Linux and switching to a dedicated connection seemed to fix the 
problem. But JDBC Thin and MTS worked fine on my Solaris 
box. Not sure with HP-UX. Is the Java application 
running on an Application Server?  Richard Ji  
-Original Message- Sent: Monday, June 16, 2003 11:25 PM 
To: Multiple recipients of list ORACLE-L   I'm not a 
Java expert so please forgive me my ignorance. JDBC application is 
facing very strange performance problems during connect. Every now and 
then everything appears to be hung and then, 10 minutes later, users 
proceed normally but with the elevated blood pressure and serious lack 
of patience. I was told that JDBC has it's own connection pooling 
mechanism and that it will start it's own dedicated server connection. 
It seems though that the string "SRVR=DEDICATED" has been ignored and 
that users are acquiring a shared server connection. 
Does anybody in this group have any experience with JDBC and MTS? Version 
is 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are 
cross-registered with listeners on all 4 nodes for load balancing 
purposes. I found surprisingly little material on the Metalink. No 
network collisions, no retransmits, no timeouts can be seen from netstat 
-i and netstat -s. The NIC is 1GB Ethernet and I would be very surprised 
if approximately 100 users could kill it with a JDBC 
application. They could use DBA as a human sacrifice, though.  
  -- Mladen Gogala Oracle DBA -- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 
Author: Mladen Gogala 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). -- Please 
see the official ORACLE-L FAQ: http://www.orafaq.net -- 
Author: Richard Ji 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). 
* 
This electronic transmission is strictly confidential and intended 
solely for the addressee. It may contain information which is covered by 
legal, professional or other privilege. If you are not the intended 
addressee, you must not disclose, copy or take any action in reliance of 
this transmission. If you have received this transmission in 
error, please notify the sender as soon as possible.  
This footnote also confirms that this message has been swept for 
computer viruses. 
** 
 -- Please see the official ORACLE-L FAQ: http://www.

RE: JDBC and MTS

[alan . aschenbrenner]

The bug Jeffrey is referring to is supposedly fixed in 8.1.7 (but I've seen
metalink posts that suggest otherwise).  The bug numbers are 1304130 and
1309641 - the dispatcher goes to sleep occasionally for 60 seconds before
waking up and servicing requests again...

Alan Aschenbrenner
Oracle DBA
IHS Group
[EMAIL PROTECTED]



   

  Jeffrey 

  Beckstrom   To:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
  [EMAIL PROTECTED]cc:
 
  .orgSubject:  RE: JDBC and MTS  

  Sent by: 

  [EMAIL PROTECTED]

  .com 

   

   

  06/17/03 11:14 AM

  Please respond to

  ORACLE-L 

   

   





I recall an old bug where MTS would sleep for a bit - don't recall the bug
anymore.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

 [EMAIL PROTECTED] 6/17/03 12:35:20 PM 
b) I use server=dedicated, is srvr=dedicate a short hand version of
it?

-Original Message-
Sent: Tuesday, June 17, 2003 8:25 AM
To: Multiple recipients of list ORACLE-L


OK. Let me get some things straight:
a) I'm not a developer. I'm one of those vile creatures called DBAs.
I don't program. I troubleshoot other people's programs. Other people
program, I nag. When developers start writing bug-free software which

uses the database in the most optimal way, my job is gone.
b) The whole problem is that even after specifying SRVR=DEDICATED in the
connect string, the darned thing still connects as an MTS connection.
c) What was the issue that you faced? That was my original question.

On 2003.06.17 07:09, Regis Biassala wrote:
 Richard is right...If ur Java application uses it own connection
 pooling...then do not use MTS...it slows down connections and more...We
 faced the same issue here

 Our configuration allows DBA to choose weather connection pooling should
 handled by the app or the database...
 Use dedicated servers if there's noway you can disable the application
 connection pooling...


 Regis

 -Original Message-
 Sent: Tuesday, June 17, 2003 6:05 AM
 To: Multiple recipients of list ORACLE-L


 I used to seen problems with JDBC Thin with MTS on Linux and switching to
 a dedicated connection seemed to fix the problem.  But JDBC Thin and MTS
 worked fine on my Solaris box.  Not sure with HP-UX.  Is the Java
 application
 running on an Application Server?

 Richard Ji

 -Original Message-
 Sent: Monday, June 16, 2003 11:25 PM
 To: Multiple recipients of list ORACLE-L


 I'm not a Java expert so please forgive me my ignorance. JDBC application
 is facing very strange performance problems during connect. Every now and
 then
 everything appears to be hung and then, 10 minutes later, users proceed
 normally but with the elevated blood pressure and serious lack of
patience.
 I was told that JDBC has it's own connection pooling mechanism and that
it
 will start it's own dedicated server connection. It seems though that the
 string SRVR=DEDICATED has been ignored and that users are acquiring a
 shared
 server connection.
 Does anybody in this group have any experience with JDBC and MTS? Version
is
 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered

JDBC and MTS

[Mladen Gogala]

I'm not a Java expert so please forgive me my ignorance. JDBC application
is facing very strange performance problems during connect. Every now and then 
everything appears to be hung and then, 10 minutes later, users proceed 
normally but with the elevated blood pressure and serious lack of patience.
I was told that JDBC has it's own connection pooling mechanism and that it 
will start it's own dedicated server connection. It seems though that the 
string SRVR=DEDICATED has been ignored and that users are acquiring a shared 
server connection.
Does anybody in this group have any experience with JDBC and MTS? Version is
8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with 
listeners on all 4 nodes for load balancing purposes. I found surprisingly 
little material on the Metalink. No network collisions, no retransmits, no 
timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet
and I would be very surprised if approximately 100 users could kill it with a
JDBC application. They could use DBA as a human sacrifice, though.



--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 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).

RE: JDBC and MTS

[Richard Ji]

I used to seen problems with JDBC Thin with MTS on Linux and switching to
a dedicated connection seemed to fix the problem.  But JDBC Thin and MTS
worked fine on my Solaris box.  Not sure with HP-UX.  Is the Java application
running on an Application Server?

Richard Ji

-Original Message-
Sent: Monday, June 16, 2003 11:25 PM
To: Multiple recipients of list ORACLE-L


I'm not a Java expert so please forgive me my ignorance. JDBC application
is facing very strange performance problems during connect. Every now and then 
everything appears to be hung and then, 10 minutes later, users proceed 
normally but with the elevated blood pressure and serious lack of patience.
I was told that JDBC has it's own connection pooling mechanism and that it 
will start it's own dedicated server connection. It seems though that the 
string SRVR=DEDICATED has been ignored and that users are acquiring a shared 
server connection.
Does anybody in this group have any experience with JDBC and MTS? Version is
8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with 
listeners on all 4 nodes for load balancing purposes. I found surprisingly 
little material on the Metalink. No network collisions, no retransmits, no 
timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet
and I would be very surprised if approximately 100 users could kill it with a
JDBC application. They could use DBA as a human sacrifice, though.



-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  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).

Re:RE: MTS config

[dgoulet]

Thanks to all who replied.  It took filing an iTAR to get the answer and then it
took OTS 2 days to find the fat finger that caused the problems.

Dick Goulet

Reply Separator
Author: Adrian Roe [EMAIL PROTECTED]
Date:   2/25/2003 7:09 AM

Looks fine. We only have the following entries on a 9i database..

dispatchers = (protocol = TCP)(dispatchers = 6)

max_dispatchers = 12

shared_servers = 10

max_shared_servers = 40


Works fine, we ended up commenting out local_listener. How long have you
waited for the dispatchers to register ? It does not happen instantly. Have
you tried lsnrctl reload ?

-Original Message-
Sent: 25 February 2003 14:04
To: Multiple recipients of list ORACLE-L


OK, Someone dope slap me!  I added the following to my init.ora file
(8.1.7.0 on
HP-UX 11.0).  The dispatchers start up just fine, but won't register with
the
listener (also 8.1.7.0).  I've already done the RTFM and MetaLink RTFM but
can't
see the problem.

mts_servers=5
mts_max_dispatchers=10
mts_max_servers=40
service_names=05
# mts_dispatchers=(PROTOCOL=ipc)(DISPATCHERS=2)
mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=4)
local_listener=(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05))
 (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart)))

Thanks for the second set of eyes.  BTW, the end result would be to have all
outside TCP connections use MTS only.

Dick Goulet
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the
company. Any review, retransmission, dissemination or other use of, or taking of
any action in reliance upon, this information by persons or entities other than
the intended recipient is prohibited. If you received this in error, please
contact the sender immediately and delete the material from any computer.


==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Adrian Roe
  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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).

MTS config

[dgoulet]

OK, Someone dope slap me!  I added the following to my init.ora file (8.1.7.0 on
HP-UX 11.0).  The dispatchers start up just fine, but won't register with the
listener (also 8.1.7.0).  I've already done the RTFM and MetaLink RTFM but can't
see the problem.

mts_servers=5
mts_max_dispatchers=10
mts_max_servers=40
service_names=05
# mts_dispatchers=(PROTOCOL=ipc)(DISPATCHERS=2)
mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=4)
local_listener=(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05))
 (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart)))

Thanks for the second set of eyes.  BTW, the end result would be to have all
outside TCP connections use MTS only.

Dick Goulet
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).

RE: MTS config

[Jeroen van Sluisdam]

Hi,

We're unfortunately still on 7.3.4.5 and this is how my mts config
looks:

mts_dispatchers=ipc,10, tcp,15
mts_servers=10
mts_service=VU_2
mts_listener_address=(ADDRESS=(PROTOCOL=ipc)(KEY=VU_2))
mts_listener_address=(ADDRESS=(PROTOCOL=tcp)(HOST=stirling)(PORT=1526))
mts_max_dispatchers=40
mts_max_servers=40

differences are in mts_service and I don't use / don't have someting like 
local_listener but just defined an extra entru in tnsnnames for a dedicated
connection.

I'm not that deep in sqlnet config that I can point out u'r problem
but hopes this helps,

Regards,
Jeroen
-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Verzonden: dinsdag 25 februari 2003 15:04
Aan: Multiple recipients of list ORACLE-L
Onderwerp: MTS config


OK, Someone dope slap me!  I added the following to my init.ora file
(8.1.7.0 on
HP-UX 11.0).  The dispatchers start up just fine, but won't register with
the
listener (also 8.1.7.0).  I've already done the RTFM and MetaLink RTFM but
can't
see the problem.

mts_servers=5
mts_max_dispatchers=10
mts_max_servers=40
service_names=05
# mts_dispatchers=(PROTOCOL=ipc)(DISPATCHERS=2)
mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=4)
local_listener=(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05))
 (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart)))

Thanks for the second set of eyes.  BTW, the end result would be to have all
outside TCP connections use MTS only.

Dick Goulet
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeroen van Sluisdam
  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).

RE: MTS config

[Mercadante, Thomas F]

Dick,

here is what I use

mts_dispatchers =
(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.99.28))(DISPATCHERS=5)
local_listener  =
(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.99.28)(PORT=1521))
mts_max_dispatchers = 10
mts_servers = 10
mts_max_servers = 100

Good Luck!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, February 25, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L


OK, Someone dope slap me!  I added the following to my init.ora file
(8.1.7.0 on
HP-UX 11.0).  The dispatchers start up just fine, but won't register with
the
listener (also 8.1.7.0).  I've already done the RTFM and MetaLink RTFM but
can't
see the problem.

mts_servers=5
mts_max_dispatchers=10
mts_max_servers=40
service_names=05
# mts_dispatchers=(PROTOCOL=ipc)(DISPATCHERS=2)
mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=4)
local_listener=(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05))
 (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart)))

Thanks for the second set of eyes.  BTW, the end result would be to have all
outside TCP connections use MTS only.

Dick Goulet
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  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).

RE: MTS config

[Adrian Roe]

Looks fine. We only have the following entries on a 9i database..

dispatchers = (protocol = TCP)(dispatchers = 6)

max_dispatchers = 12

shared_servers = 10

max_shared_servers = 40


Works fine, we ended up commenting out local_listener. How long have you
waited for the dispatchers to register ? It does not happen instantly. Have
you tried lsnrctl reload ?

-Original Message-
Sent: 25 February 2003 14:04
To: Multiple recipients of list ORACLE-L


OK, Someone dope slap me!  I added the following to my init.ora file
(8.1.7.0 on
HP-UX 11.0).  The dispatchers start up just fine, but won't register with
the
listener (also 8.1.7.0).  I've already done the RTFM and MetaLink RTFM but
can't
see the problem.

mts_servers=5
mts_max_dispatchers=10
mts_max_servers=40
service_names=05
# mts_dispatchers=(PROTOCOL=ipc)(DISPATCHERS=2)
mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=4)
local_listener=(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05))
 (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart)))

Thanks for the second set of eyes.  BTW, the end result would be to have all
outside TCP connections use MTS only.

Dick Goulet
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which it is 
addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the 
company. Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact the 
sender immediately and delete the material from any computer.


==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Adrian Roe
  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).

RE: MTS config

[Stephen Lee]

service_names, I believe is an optional thing.  But if you use it, I think
it is supposed to be set to a sort of alias name, not a number.

 -Original Message-
 can't
 see the problem.
 
 service_names=05
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  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).

Re:RE: MTS config

[dgoulet]

Let's see, how about overnight and yes I have reloaded the listener.

Dick Goulet

Reply Separator
Author: Adrian Roe [EMAIL PROTECTED]
Date:   2/25/2003 7:09 AM

Looks fine. We only have the following entries on a 9i database..

dispatchers = (protocol = TCP)(dispatchers = 6)

max_dispatchers = 12

shared_servers = 10

max_shared_servers = 40


Works fine, we ended up commenting out local_listener. How long have you
waited for the dispatchers to register ? It does not happen instantly. Have
you tried lsnrctl reload ?

-Original Message-
Sent: 25 February 2003 14:04
To: Multiple recipients of list ORACLE-L


OK, Someone dope slap me!  I added the following to my init.ora file
(8.1.7.0 on
HP-UX 11.0).  The dispatchers start up just fine, but won't register with
the
listener (also 8.1.7.0).  I've already done the RTFM and MetaLink RTFM but
can't
see the problem.

mts_servers=5
mts_max_dispatchers=10
mts_max_servers=40
service_names=05
# mts_dispatchers=(PROTOCOL=ipc)(DISPATCHERS=2)
mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=4)
local_listener=(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05))
 (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart)))

Thanks for the second set of eyes.  BTW, the end result would be to have all
outside TCP connections use MTS only.

Dick Goulet
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the
company. Any review, retransmission, dissemination or other use of, or taking of
any action in reliance upon, this information by persons or entities other than
the intended recipient is prohibited. If you received this in error, please
contact the sender immediately and delete the material from any computer.


==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Adrian Roe
  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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).

Re: MTS / Dedicated

[chao_ping]

S Anandan,
I think for 75 connections, dedicated server is good enough.
75 connection is nothing for a database, and you said your user never 
idle at any time, so dediacted server is better .





Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(ChinaOracle User Group)

=== 2003-01-06 14:28:00 ,you wrote£º===

Dear All,

 I have 75 concurrent MTS user sessions for my database.All users 
never be idle at any time. Can anybody suggest me how many Dispatcher 
process and Shared server process should I have, so that there should not be 
any response delay because of MTS.Or if u think for 75 users Dedicated 
server model will do, please tell me the Idea behind this.

   Waiting for valueble reply!!!

Thanks In Advance.

Regards,
Anandan S









_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail



Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to [EMAIL PROTECTED]
To subscribe:   send a blank email to [EMAIL PROTECTED]
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

= = = = = = = = = = = = = = = = = = = =




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: chao_ping
  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).

moving from dedicated connections to MTS

[Yechiel Adar]

Hello all

First a little background.

We work with oracle 8.1.6.3.4 on NT or win2000 servers.
The technical people have just move an application server behind a firewall.
The application servers access a database that is a central repository of
user connections (i.e. all applications on the intranet access this database
for each page for each user). They saw that the application works fine for a
while and then they get access denied. They track it down to the port
numbers in the firewall. We are working with dedicated connections and it
seems that the port numbers for each connections are climbing up until they
exceeded the range of open ports in the firewall. They said that they had
the same problems in another server, they brought an outside guy (of course
without telling the DBA group) and he solved the problem. They brought me
the init.ora file of that database (I can not access it via the firewall)
and showed me the parameters that made the difference. The guy put in:
mts_dispatchers= ... port=8000) (5 dispatchers). Since they want me to do it
on a central and essential database I want to ask you guys:

1) Any gotcha moving from dedicated connections to MTS?
2) Is each dispatcher assigned for the current sql command and then released
or is it assigned for the duration of the session?
3) What is the ratio of users per dispatcher?
4) Is there a way to tell oracle to reuse port numbers for dedicated
connections that were closed?
5) Anything else you care to share.

Sorry if my questions are somewhat trivial but we need a decision tomorrow
morning (in 18 hours) as they start doing some training session on the
system on Sunday and time is short.

TIA

Yechiel Adar
Mehish

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  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).

RE: moving from dedicated connections to MTS

[DENNIS WILLIAMS]

Yechiel - This is an inexperienced reply, but since I will be facing your
situation soon, I thought I would share my ideas also.
  1. Most application servers can do connection pooling, so why use MTS as a
second layer on top of connection pooling?
  2. I believe Oracle uses a range of ports, so the firewall needs to have
those open. I did some quick searches on Metalink and Google and saw a
wealth of information, but couldn't easily summarize what I found.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, November 19, 2002 10:24 AM
To: Multiple recipients of list ORACLE-L


Hello all

First a little background.

We work with oracle 8.1.6.3.4 on NT or win2000 servers.
The technical people have just move an application server behind a firewall.
The application servers access a database that is a central repository of
user connections (i.e. all applications on the intranet access this database
for each page for each user). They saw that the application works fine for a
while and then they get access denied. They track it down to the port
numbers in the firewall. We are working with dedicated connections and it
seems that the port numbers for each connections are climbing up until they
exceeded the range of open ports in the firewall. They said that they had
the same problems in another server, they brought an outside guy (of course
without telling the DBA group) and he solved the problem. They brought me
the init.ora file of that database (I can not access it via the firewall)
and showed me the parameters that made the difference. The guy put in:
mts_dispatchers= ... port=8000) (5 dispatchers). Since they want me to do it
on a central and essential database I want to ask you guys:

1) Any gotcha moving from dedicated connections to MTS?
2) Is each dispatcher assigned for the current sql command and then released
or is it assigned for the duration of the session?
3) What is the ratio of users per dispatcher?
4) Is there a way to tell oracle to reuse port numbers for dedicated
connections that were closed?
5) Anything else you care to share.

Sorry if my questions are somewhat trivial but we need a decision tomorrow
morning (in 18 hours) as they start doing some training session on the
system on Sunday and time is short.

TIA

Yechiel Adar
Mehish

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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).

RE: moving from dedicated connections to MTS

[Anderson, Brian]

 Doc: 125021.1 talks about firewalls.

Look for  USE_SHARED_SOCKET  to keep the dedicated connections.

 -Original Message-
 From: Yechiel Adar [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, November 19, 2002 11:24 AM
 To: Multiple recipients of list ORACLE-L
 Subject: moving from dedicated connections to MTS
 
 
 Hello all
 
 First a little background.
 
 We work with oracle 8.1.6.3.4 on NT or win2000 servers.
 The technical people have just move an application server 
 behind a firewall.
 The application servers access a database that is a central 
 repository of
 user connections (i.e. all applications on the intranet 
 access this database
 for each page for each user). They saw that the application 
 works fine for a
 while and then they get access denied. They track it down to the port
 numbers in the firewall. We are working with dedicated 
 connections and it
 seems that the port numbers for each connections are climbing 
 up until they
 exceeded the range of open ports in the firewall. They said 
 that they had
 the same problems in another server, they brought an outside 
 guy (of course
 without telling the DBA group) and he solved the problem. 
 They brought me
 the init.ora file of that database (I can not access it via 
 the firewall)
 and showed me the parameters that made the difference. The guy put in:
 mts_dispatchers= ... port=8000) (5 dispatchers). Since they 
 want me to do it
 on a central and essential database I want to ask you guys:
 
 1) Any gotcha moving from dedicated connections to MTS?
 2) Is each dispatcher assigned for the current sql command 
 and then released
 or is it assigned for the duration of the session?
 3) What is the ratio of users per dispatcher?
 4) Is there a way to tell oracle to reuse port numbers for dedicated
 connections that were closed?
 5) Anything else you care to share.
 
 Sorry if my questions are somewhat trivial but we need a 
 decision tomorrow
 morning (in 18 hours) as they start doing some training session on the
 system on Sunday and time is short.
 
 TIA
 
 Yechiel Adar
 Mehish
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Yechiel Adar
   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).
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anderson, Brian
  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).

RE: moving from dedicated connections to MTS

[Reardon, Bruce (CALBBAY)]

Or get a firewall that understands the Net8 protocol and open that protocol rather 
than specific ports.

Also, some further Metalink references that should help:

On Metalink check out the following note:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=132729.1
This is the Technical Library Connection Manager and Firewalls  index.

eg check out:
How to enable USE_SHARED_SOCKET on WINNT and Windows 2000 124140.1 
Oracle And Firewalls : Answers To Frequently Asked Questions 2084440.6 
Oracle Connectivity with Firewalls 125021.1 
Firewalls, Windows NT and Redirections 66382.1 
Solving Firewall problems on NT 68652.1 

In particular, with a normal connection you come in on the listener port (often 1521 
or 1526) but the listener then selects a random port for communication
from the server back to the client.  

So the summary is - you shouldn't need to use MTS just to get Oracle to work with a 
firewall

Regards,
Bruce Reardon

-Original Message-
Sent: Wednesday, 20 November 2002 4:30 AM

 Doc: 125021.1 talks about firewalls.

Look for  USE_SHARED_SOCKET  to keep the dedicated connections.

 -Original Message-
 From: Yechiel Adar [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, November 19, 2002 11:24 AM
 
 Hello all
 
 First a little background.
 
 We work with oracle 8.1.6.3.4 on NT or win2000 servers.
 The technical people have just move an application server 
 behind a firewall.
 The application servers access a database that is a central 
 repository of
 user connections (i.e. all applications on the intranet 
 access this database
 for each page for each user). They saw that the application 
 works fine for a
 while and then they get access denied. They track it down to the port
 numbers in the firewall. We are working with dedicated 
 connections and it
 seems that the port numbers for each connections are climbing 
 up until they
 exceeded the range of open ports in the firewall. They said 
 that they had
 the same problems in another server, they brought an outside 
 guy (of course
 without telling the DBA group) and he solved the problem. 
 They brought me
 the init.ora file of that database (I can not access it via 
 the firewall)
 and showed me the parameters that made the difference. The guy put in:
 mts_dispatchers= ... port=8000) (5 dispatchers). Since they 
 want me to do it
 on a central and essential database I want to ask you guys:
 
 1) Any gotcha moving from dedicated connections to MTS?
 2) Is each dispatcher assigned for the current sql command 
 and then released
 or is it assigned for the duration of the session?
 3) What is the ratio of users per dispatcher?
 4) Is there a way to tell oracle to reuse port numbers for dedicated
 connections that were closed?
 5) Anything else you care to share.
 
 Sorry if my questions are somewhat trivial but we need a 
 decision tomorrow
 morning (in 18 hours) as they start doing some training session on the
 system on Sunday and time is short.
 
 TIA
 
 Yechiel Adar
 Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
  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).

How can I tell if MTS is activated

[Pablo Rodriguez]

Oracle 8i

How can I tell if MTS is activated?

Which parameters should I look at? (in init.ora and
listener.ora)


thanks
Pablo



___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  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).

RE: How can I tell if MTS is activated

[Farnsworth, Dave]

To see how many dispatchers/shared servers are started up with the RDBMS,  check the 
value of 'mts_dispatchers' and 'mts_servers' in the init.ora.  
You can also tell by looking in the alert.log(default location is  
$ORACLE_HOME/rdbms/log).
Sample:  
PMON started
DBWR started
LGWR started
RECO started
Thu Sep 14 09:24:15 1995
starting up 4 shared server(s) ...
starting up 4 dispatcher(s) for network
See Note:1012480.6 on Metastink for mor info on MTS Processes

Dave

-Original Message-
Sent: Wednesday, November 06, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L


Oracle 8i

How can I tell if MTS is activated?

Which parameters should I look at? (in init.ora and
listener.ora)


thanks
Pablo



___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  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).

RE: How can I tell if MTS is activated -- more problems

[Pablo Rodriguez]

Dave,

   I've seen these processes (ora_S00... and
ora_d00..) but all connections are being made through
dedicated processes.

Here's my configuration:

mts_listener_address = (ADDRESS=(PROTOCOL=TCP)
(HOST=10.20.81.78) (PORT=1521))
mts_service  = PRUE1
mts_dispatchers  = tcp,2
mts_max_dispatchers  = 10
mts_servers  = 6
mts_max_servers  = 100


The listener has been started before the RDBMS:

listener.ora

LISTENER =
  (ADDRESS_LIST=
   
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PRUE1)))
SID_LIST_LISTENER=
   (SID_LIST=
(SID_DESC=
  (GLOBAL_DBNAME=PRUE1)
  (SID_NAME=PRUE1)
  (ORACLE_HOME=/u01/app/oracle/product/8.1.7)
 )
   )


lsnrctl services

LSNRCTL for Linux: Version 8.1.7.0.0 - Production on
06-NOV-2002 16:40:58

(c) Copyright 1998 Oracle Corporation.  All rights
reserved.

Connecting to
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
Services Summary...
  PRUE1 has 2 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
The command completed successfully


BUT the user processes are not using MTS.

Why aren't they using MTS?
What's wrong in this configuration?


thanks for your help.





--
To see how many dispatchers/shared servers are started
up with the RDBMS,  check the value of
'mts_dispatchers' and 'mts_servers' in the init.ora.  
You can also tell by looking in the alert.log(default
location is  $ORACLE_HOME/rdbms/log).
Sample:  
PMON started
DBWR started
LGWR started
RECO started
Thu Sep 14 09:24:15 1995
starting up 4 shared server(s) ...
starting up 4 dispatcher(s) for network
See Note:1012480.6 on Metastink for mor info on MTS
Processes

Dave

-Original Message-
Sent: Wednesday, November 06, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L


Oracle 8i

How can I tell if MTS is activated?

Which parameters should I look at? (in init.ora and
listener.ora)


thanks
Pablo



___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  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).
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  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 

___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  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).

Re:RE: How can I tell if MTS is activated -- more problems

[dgoulet]

What does your TNSNAMES.ORA file look like?  If there is a line in there
'(server=dedicated)' you might as well turn MTS off.

Dick Goulet

Reply Separator
Author: =?iso-8859-1?q?Pablo=20Rodriguez?= [EMAIL PROTECTED]
Date:   11/6/2002 11:39 AM

Dave,

   I've seen these processes (ora_S00... and
ora_d00..) but all connections are being made through
dedicated processes.

Here's my configuration:

mts_listener_address = (ADDRESS=(PROTOCOL=TCP)
(HOST=10.20.81.78) (PORT=1521))
mts_service  = PRUE1
mts_dispatchers  = tcp,2
mts_max_dispatchers  = 10
mts_servers  = 6
mts_max_servers  = 100


The listener has been started before the RDBMS:

listener.ora

LISTENER =
  (ADDRESS_LIST=
   
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PRUE1)))
SID_LIST_LISTENER=
   (SID_LIST=
(SID_DESC=
  (GLOBAL_DBNAME=PRUE1)
  (SID_NAME=PRUE1)
  (ORACLE_HOME=/u01/app/oracle/product/8.1.7)
 )
   )


lsnrctl services

LSNRCTL for Linux: Version 8.1.7.0.0 - Production on
06-NOV-2002 16:40:58

(c) Copyright 1998 Oracle Corporation.  All rights
reserved.

Connecting to
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
Services Summary...
  PRUE1 has 2 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
The command completed successfully


BUT the user processes are not using MTS.

Why aren't they using MTS?
What's wrong in this configuration?


thanks for your help.





--
To see how many dispatchers/shared servers are started
up with the RDBMS,  check the value of
'mts_dispatchers' and 'mts_servers' in the init.ora.  
You can also tell by looking in the alert.log(default
location is  $ORACLE_HOME/rdbms/log).
Sample:  
PMON started
DBWR started
LGWR started
RECO started
Thu Sep 14 09:24:15 1995
starting up 4 shared server(s) ...
starting up 4 dispatcher(s) for network
See Note:1012480.6 on Metastink for mor info on MTS
Processes

Dave

-Original Message-
Sent: Wednesday, November 06, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L


Oracle 8i

How can I tell if MTS is activated?

Which parameters should I look at? (in init.ora and
listener.ora)


thanks
Pablo



___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  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).
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  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 

___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

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

Re: How can I tell if MTS is activated -- more problems

[Ray Stell]

On Wed, Nov 06, 2002 at 11:39:06AM -0800, Pablo Rodriguez wrote:
 Dave,
 
I've seen these processes (ora_S00... and
 ora_d00..) but all connections are being made through
 dedicated processes.
 
 Here's my configuration:
 
 mts_listener_address = (ADDRESS=(PROTOCOL=TCP)
 (HOST=10.20.81.78) (PORT=1521))
 mts_service  = PRUE1
 mts_dispatchers  = tcp,2


I think this is old syntax for mts_dispatchers, v7ish, maybe.  Look at the docs on
where you are (I have not been following the thread).  Seems like this happened to 
me when moving from oracle 7 - 8.  Maybe:

mts_dispatchers = (PROTOCOL=TCP)(DISPATCHERS=1)





 mts_max_dispatchers  = 10
 mts_servers  = 6
 mts_max_servers  = 100
 
 
 The listener has been started before the RDBMS:
 
 listener.ora
 
 LISTENER =
   (ADDRESS_LIST=

 (ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
 (ADDRESS=(PROTOCOL=ipc)(KEY=PRUE1)))
 SID_LIST_LISTENER=
(SID_LIST=
 (SID_DESC=
   (GLOBAL_DBNAME=PRUE1)
   (SID_NAME=PRUE1)
   (ORACLE_HOME=/u01/app/oracle/product/8.1.7)
  )
)
 
 
 lsnrctl services
 
 LSNRCTL for Linux: Version 8.1.7.0.0 - Production on
 06-NOV-2002 16:40:58
 
 (c) Copyright 1998 Oracle Corporation.  All rights
 reserved.
 
 Connecting to
 (ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
 Services Summary...
   PRUE1 has 2 service handler(s)
 DEDICATED SERVER established:0 refused:0
   LOCAL SERVER
 DEDICATED SERVER established:0 refused:0
   LOCAL SERVER
 The command completed successfully
 
 
 BUT the user processes are not using MTS.
 
 Why aren't they using MTS?
 What's wrong in this configuration?
 
 
 thanks for your help.
 
 
 
 
 
 --
 To see how many dispatchers/shared servers are started
 up with the RDBMS,  check the value of
 'mts_dispatchers' and 'mts_servers' in the init.ora.  
 You can also tell by looking in the alert.log(default
 location is  $ORACLE_HOME/rdbms/log).
 Sample:  
 PMON started
 DBWR started
 LGWR started
 RECO started
 Thu Sep 14 09:24:15 1995
 starting up 4 shared server(s) ...
 starting up 4 dispatcher(s) for network
 See Note:1012480.6 on Metastink for mor info on MTS
 Processes
 
 Dave
 
 -Original Message-
 Sent: Wednesday, November 06, 2002 10:59 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Oracle 8i
 
 How can I tell if MTS is activated?
 
 Which parameters should I look at? (in init.ora and
 listener.ora)
 
 
 thanks
 Pablo
 
 
 
 ___
 Yahoo! Messenger
 Nueva versi?n: Webcam, voz, y mucho m?s ?Gratis! 
 Desc?rgalo ya desde http://messenger.yahoo.es
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
   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).
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Farnsworth, Dave
   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 
 
 ___
 Yahoo! Messenger
 Nueva versi?n: Webcam, voz, y mucho m?s ?Gratis! 
 Desc?rgalo ya desde http://messenger.yahoo.es
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
   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).

-- 
===
Ray

Re: How can I tell if MTS is activated -- more problems

[Scott Stefick]

Pablo,

init.ora -- Look at the dispatchers=... parameter (You can comment it 
out if you don't want MTS)
listener.ora -- Look for (SERVER = DEDICATED) vs. (SERVER = SHARED)
In SQLPLUS -- SQL SELECT servers_started FROM v$mts;

-Scott Stefick

 -Original Message-
 Sent: Wednesday, November 06, 2002 10:59 AM
 To: Multiple recipients of list ORACLE-L


 Oracle 8i

 How can I tell if MTS is activated?

 Which parameters should I look at? (in init.ora and
 listener.ora)


 thanks
 Pablo



**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Stefick
 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).

RE: How can I tell if MTS is activated -- more problems

[Molina, Gerardo]

Another place to look is how connections are made to the database.

Do you know if the connections are bypassing the tnsnames.ora altogether and
using their own connect string wherein they could be specifying a dedicated
server?

First thing to determine is whether connections are in fact using
tnsnames.ora.  The developers should be able to answer this question.

For example, an application could be using JDBC to connect to db and the
connection could specify a complete connect string and not use tnsnames.ora
at all.

HTH,
Gerardo

-Original Message-
Sent: Wednesday, November 06, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Dave,

   I've seen these processes (ora_S00... and
ora_d00..) but all connections are being made through
dedicated processes.

Here's my configuration:

mts_listener_address = (ADDRESS=(PROTOCOL=TCP)
(HOST=10.20.81.78) (PORT=1521))
mts_service  = PRUE1
mts_dispatchers  = tcp,2
mts_max_dispatchers  = 10
mts_servers  = 6
mts_max_servers  = 100


The listener has been started before the RDBMS:

listener.ora

LISTENER =
  (ADDRESS_LIST=
   
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PRUE1)))
SID_LIST_LISTENER=
   (SID_LIST=
(SID_DESC=
  (GLOBAL_DBNAME=PRUE1)
  (SID_NAME=PRUE1)
  (ORACLE_HOME=/u01/app/oracle/product/8.1.7)
 )
   )


lsnrctl services

LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 06-NOV-2002 16:40:58

(c) Copyright 1998 Oracle Corporation.  All rights
reserved.

Connecting to
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
Services Summary...
  PRUE1 has 2 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
The command completed successfully


BUT the user processes are not using MTS.

Why aren't they using MTS?
What's wrong in this configuration?


thanks for your help.





--
To see how many dispatchers/shared servers are started
up with the RDBMS,  check the value of
'mts_dispatchers' and 'mts_servers' in the init.ora.  
You can also tell by looking in the alert.log(default
location is  $ORACLE_HOME/rdbms/log).
Sample:  
PMON started
DBWR started
LGWR started
RECO started
Thu Sep 14 09:24:15 1995
starting up 4 shared server(s) ...
starting up 4 dispatcher(s) for network
See Note:1012480.6 on Metastink for mor info on MTS
Processes

Dave

-Original Message-
Sent: Wednesday, November 06, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L


Oracle 8i

How can I tell if MTS is activated?

Which parameters should I look at? (in init.ora and
listener.ora)


thanks
Pablo



___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  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).
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  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 

___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  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

RE: MTS process HIGH CPU

[Gogala, Mladen]

That process has an oracle session associated with it.
Before killing it, it would be nice to see what that 
session is doing. You could do it by joining v$process and
v$session. The SPID column in v$process is System PID and
ADDR column corresponds to the PADDR in V$SESSION table.

 -Original Message-
 From: Seema Singh [mailto:oracledbam;hotmail.com]
 Sent: Monday, November 04, 2002 2:09 PM
 To: Multiple recipients of list ORACLE-L
 Subject: MTS process HIGH CPU
 
 
 Hi
 I am using MTS in 8.1.6.I am wondering one of MTS process is 
 locked 2 table 
 since morning and this process is taking more CPU.Can I kill 
 that process 
 like ora_s000_prod by using alter system and then unix kill command?
 Thx
 -Seema
 
 
 
 
 
 
 _
 Choose an Internet access plan right for you -- try MSN! 
 http://resourcecenter.msn.com/access/plans/default.asp
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Seema Singh
   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).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  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).

MTS process HIGH CPU

[Seema Singh]

Hi
I am using MTS in 8.1.6.I am wondering one of MTS process is locked 2 table 
since morning and this process is taking more CPU.Can I kill that process 
like ora_s000_prod by using alter system and then unix kill command?
Thx
-Seema






_
Choose an Internet access plan right for you -- try MSN! 
http://resourcecenter.msn.com/access/plans/default.asp

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
 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).

Problem with Oracle manager for MTS

[Thanh-truc Nguyen]

Hello,

We are on Intel pentium 4 windows 2000 SP2 server.
We tried to install oracle 8.1.6 client and no thing happened
where we clicked on the SETUP button.
We applied the patch 1507768 and every thing was okay, we
could connect to the database (8.1.7.0 in AIX) via sqlplus.
Now when we try to create a service for Microsoft transaction
server we got this warning (in french) that we don't get on
any other server :
Le chiffrement des mots de passe n'est pas pris en charge
lorsque la variable locale est la France. Le motde passe sera
stocké en toutes lettres dans la de registre.
In english :
The encryption of the password isn't supported where
environment variable is set to France. The password will be
written into the register's base without encryption.

We can then create the service but the database ID isn't shown
in the service's property and there isn't any enregistrement
in the table MTS_PROXY_INFO.

We've opened an Itar since last week but they don't find any
thing and I find nothing in the internet.

Any help will be appreciated.

Best regards,

Thanh-truc Nguyen


Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 
€/mn) ; tél : 08 92 68 13 50 (0,34€/mn)



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?Q?Thanh-truc_Nguyen?  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: Problem with Oracle manager for MTS

[Yechiel Adar]

Have you checked the regional settings on the server.
Make sure you install the client with language=English USA.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 25, 2002 1:08 PM


Hello,

We are on Intel pentium 4 windows 2000 SP2 server.
We tried to install oracle 8.1.6 client and no thing happened
where we clicked on the SETUP button.
We applied the patch 1507768 and every thing was okay, we
could connect to the database (8.1.7.0 in AIX) via sqlplus.
Now when we try to create a service for Microsoft transaction
server we got this warning (in french) that we don't get on
any other server :
Le chiffrement des mots de passe n'est pas pris en charge
lorsque la variable locale est la France. Le motde passe sera
stocké en toutes lettres dans la de registre.
In english :
The encryption of the password isn't supported where
environment variable is set to France. The password will be
written into the register's base without encryption.

We can then create the service but the database ID isn't shown
in the service's property and there isn't any enregistrement
in the table MTS_PROXY_INFO.

We've opened an Itar since last week but they don't find any
thing and I find nothing in the internet.

Any help will be appreciated.

Best regards,

Thanh-truc Nguyen


Accédez au courrier électronique de La Poste : www.laposte.net ; 3615
LAPOSTENET (0,13 ?/mn) ; tél : 08 92 68 13 50 (0,34?/mn)



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =so-8859-1?Q?Thanh-truc_Nguyen?  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: Problem with Oracle manager for MTS

[Thanh-truc Nguyen]

Hello,

Thank you for your help. I'll check it.

Best regards,

Thanh-truc Nguyen

-- Debut du message initial ---

De : [EMAIL PROTECTED]
A  : Multiple recipients of list ORACLE-L ORACLE-
[EMAIL PROTECTED]
Copies :
Date   : Thu, 25 Jul 2002 08:33:30 -0800
Objet  : Re: Problem with Oracle manager for MTS

 Have you checked the regional settings on the server.
 Make sure you install the client with language=English USA.

 Yechiel Adar
 Mehish


Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 
€/mn) ; tél : 08 92 68 13 50 (0,34€/mn)



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?Q?Thanh-truc_Nguyen?  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

How to use these MTS TUning Scripts

[Bunyamin Karadeniz]

How can I use these scripts below to tune MTS ?
Bunyamin

SQL select paddr,type,queued,wait,totalq, 
  2  decode(totalq,0,0,wait/totalq) AVG WAIT from v$queue;

PADDRTYPE   QUEUED   WAIT TOTALQ   AVG WAIT
 -- -- -- -- --
00   COMMON  0  131585196771 ,002531957
140E11EC DISPATCHER  0 136409 548604 ,248647476
140E1514 DISPATCHER  0 178022 977429 ,182132922
140E183C DISPATCHER  0 4381852406714 ,182067749
140E1B64 DISPATCHER  0 2771101054844 ,262702352
140E1E8C DISPATCHER  0 146121 671815 ,217501842


SQL select name NAME, paddr,requests, 
  2  (busy/(busy + idle)) * 100 %TIME BUSY from v$shared_server;

NAME PADDR  REQUESTS %TIME BUSY
  -- --
S000 140DD2CC2004637 15,3597284
S001 140DD5F41380026 9,76323755
S002 140DD91C 862050   5,642241
S003 140DDC44 532685 2,77508729
S004 140DDF6C 261459 1,34762108
S005 140DE294 107879 ,521803133
S006 140DE5BC  35905 ,227110307
S007 140DE8E4  14320 ,102182328
S008 140DEC0C   4316  ,04232294
S009 140DEF34   1527 ,013207575
S010 140DF25C436 ,006863212

NAME PADDR  REQUESTS %TIME BUSY
  -- --
S011 140DF584 40 ,006196229
S012 140DF8AC  9 ,004030979
S013 140DFBD4  8 ,003254756
S014 140DFEFC  5 ,001988269
S015 140E0224  9  ,00106223
S016 140E054C  5 ,68091
S017 140E0874  5 ,000136184
S018 140E0B9C  5 ,27237
S019 140E0EC4  7 ,68092

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bunyamin Karadeniz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

MTS performance is too bad.

[Bunyamin Karadeniz]

I have changed my 8.1.7.3.2 database to MTS on 
win2000. But performance is too bad. 
I have 800 MB of shared pool and not setted 
large_pool_size. 
50 dispathers, 100 processes and 750 max processes. 


What can I do ? Have you got an idea. How can 
I check the mts performance?

Bunyamin 

RE: MTS performance is too bad.

[Wong, Bing]

What is your 
maximum MTS servers?

  -Original Message-From: Bunyamin Karadeniz 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 26, 2002 
  9:49 AMTo: Multiple recipients of list ORACLE-LSubject: 
  MTS performance is too bad.
  I have changed my 8.1.7.3.2 database to MTS on 
  win2000. But performance is too bad. 
  I have 800 MB of shared pool and not setted 
  large_pool_size. 
  50 dispathers, 100 processes and 750 max 
  processes. 
  
  What can I do ? Have you got an idea. How 
  can I check the mts performance?
  
  Bunyamin 

Re: MTS performance is too bad.

[Suzy Vordos]

Do consider setting large_pool_size.  Here's a script to get you
started.  MTS has bugs under 8i where the dispatcher hangs, especially
when connections use JDBC thin.

col name format a10
col network format a40
col status format a14

PROMPT *** MTS DISPATCHER STATISTICS ***
select name,owned,status,
   (busy/(busy + idle)) * 100 % busy
from v$dispatcher
/

PROMPT *** MTS SHARED SERVER STATISTICS ***
select name,status,requests,
   (busy /(busy + idle)) * 100 % busy
from v$shared_server
/

PROMPT *** MTS QUEUE STATUS AND WAITS ***
select paddr, type, queued, wait, totalq,
   decode(totalq,0,0,wait/totalq) AVG WAIT
from v$queue
/

PROMPT *** CURRENT MTS CONNECTIONS ***
select s.username, c.dispatcher, c.server, c.status
from v$circuit c, v$session s
where c.saddr = s.saddr
/

PROMPT *** MTS STATISTICS ***
select maximum_connections max_conn,
   servers_started, servers_terminated, servers_highwater
from v$mts
/

 Bunyamin Karadeniz wrote:
 
 I have changed my 8.1.7.3.2 database to MTS on win2000. But
 performance is too bad.
 I have 800 MB of shared pool and not setted large_pool_size.
 50 dispathers, 100 processes and 750 max processes.
 
 What can I do ?  Have you got an idea. How can I check the mts
 performance?
 
 Bunyamin
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: MTS performance is too bad.

[Jared . Still]

Change back to dedicated servers.

Jared





Bunyamin Karadeniz [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/26/2002 09:49 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:MTS performance is too bad.


I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is 
too bad. 
I have 800 MB of shared pool and not setted large_pool_size. 
50 dispathers, 100 processes and 750 max processes. 
 
What can I do ?  Have you got an idea. How can I check the mts 
performance?
 
Bunyamin 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: MTS performance is too bad.

[Johnson, Michael]

Everything I have seen from experience
tells me to avoid using MTS if you can !

FWIW.

Mike

-Original Message-
Sent: Wednesday, June 26, 2002 1:06 PM
To: Multiple recipients of list ORACLE-L


Change back to dedicated servers.

Jared





Bunyamin Karadeniz [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/26/2002 09:49 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:MTS performance is too bad.


I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is 
too bad. 
I have 800 MB of shared pool and not setted large_pool_size. 
50 dispathers, 100 processes and 750 max processes. 
 
What can I do ?  Have you got an idea. How can I check the mts 
performance?
 
Bunyamin 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson, Michael 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

MTS and Dedicated Server

[Eriovaldo Andrietta]

Hi friends :

I just finished to install my database with shared server option, so i have
some parameters like mts_

My question :

1.) How can I do for to take out this option and put the database in
Dedicated Mode ?
2.) What can I do for use two kinds of options simultaneity: Shared and
Dedicated ?


I think that i need jut to take out the parameters with mts_ at the begin
and reestart the instance , right ?

Regards

Eriovaldo



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eriovaldo Andrietta
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: MTS and Dedicated Server

[Ganesh Raja]

Yes you just need to do that. Then your server will only accept Dedicated
connections.

All DBA Operations should be performed on a dedicated connection to the
database so if you have enabled MTS you can still connect to a dedicated
server process via the listener by saying srvr = dedicated in the tns entry.

HTH

Best Regards,
Ganesh R
Tel  : +971 (4)  397 3337  Ext 420
Fax  : +971 (4)  397 6262
HP   : +971 (50) 745 6019

Live to learn... forget... and learn again. 




-Original Message-
Sent: Sunday, May 19, 2002 5:18 PM
To: Multiple recipients of list ORACLE-L



Hi friends :

I just finished to install my database with shared server option, so i have
some parameters like mts_

My question :

1.) How can I do for to take out this option and put the database in
Dedicated Mode ?
2.) What can I do for use two kinds of options simultaneity: Shared and
Dedicated ?


I think that i need jut to take out the parameters with mts_ at the begin
and reestart the instance , right ?

Regards

Eriovaldo



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eriovaldo Andrietta
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ganesh Raja
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: MTS and Dedicated Server

[Nirmal Kumar Muthu Kumaran]

Title: RE: MTS and Dedicated Server





Hi...
1) Just comment or remove the init.ora parameters related with mts.
2) Configure the database as MTS. By default all connections uses dispatchers.
 If you want to made a dedicated connection, configure ur tnsnames.ora accordingly.
 Means add the attribue SHARED_SERVER = YES in the CONNECTION_DATA tns parameter.


HTH.


Nirmal.


-Original Message-
From: Eriovaldo Andrietta [SMTP:[EMAIL PROTECTED]]
Sent: 08 ÑÈíÚ ÇáÇæá, 1423 04:18 PM
To: Multiple recipients of list ORACLE-L
Subject: MTS and Dedicated Server



Hi friends :


I just finished to install my database with shared server option, so i have
some parameters like mts_


My question :


1.) How can I do for to take out this option and put the database in
Dedicated Mode ?
2.) What can I do for use two kinds of options simultaneity: Shared and
Dedicated ?



I think that i need jut to take out the parameters with mts_ at the begin
and reestart the instance , right ?


Regards


Eriovaldo




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eriovaldo Andrietta
 INET: [EMAIL PROTECTED]


Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists

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).

MTS questions

[Jared . Still]

Hey list,

It's been awhile since I've used MTS, and some questions have come
up regarding it.

The question revolves around sniped sessions, and the need to 
remove these things automatically in some systems, since they
consume resources.  Such as a DW where sessions may not
be created very frequently.

Doing this with dedicated servers is no problem. 

Doing so with MTS is another matter.  When I kill a sniped session, I
first kill the OS process ( or thread ) and then kill the session, if it 
is
still around.  I kill the OS process first due to an infamous problem with
Oracle.  When you kill a session that is holding locks, there's a chance
that this session will never go away until the DB is bounced.  And it
continues to hold the lock until the DB is bounced.

I've had this happen on multiple versions of Oracle, on Solaris, DG/UX
and Windoze NT.

The question is:  What is the process that appears in V$PROCESS for
an idle session that is connected via MTS?  I'm guessing it's the 
dispatcher.  I don't have anyway to check this however.

Any help in this would be greatly appreciated.

Thanks,

Jared


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: shared pool memory issue on OPS (non-MTS)

[Sherman, Paul R.]

Jonathon,

Currently we do not pin anything in the shared pool. Still nothing from
Oracle on this yet.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]


-Original Message-
Sent: Thursday, May 02, 2002 7:43 PM
To: Multiple recipients of list ORACLE-L



That certainly sounds like the solution to the immediate
problem.  (Mind you, those initial numbers look like
generated values, not manual settings).

However, it doesn't answer the question of why
one of the machines has the problem.

Do you think it;s possible that lots of material
gets loaded and KEEP'ed in this instance before
the other instance starts up, making this instance
the resource master for a very large dictionary cache ?



Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 02 May 2002 22:44


|Check out the following two values:
|
|Resource Current  MaxInitial  Limit
|Name  Utilization   UtilizationAllocation   Value
|----   ----  
|lm_ress252143  256732 177599   UNLIMITED
|lm_locks  278106  288642 189208   UNLIMITED
|
|Notice that Current/Max Utilization is much higher than Initial
|Allocation?
|
|This means that (messages to alert.log or not), the DLM is
overflowing its
|allocated space in the SGA and invading the Shared Pool.  Increase
your
|LM_RESS and LM_LOCKS parameter values...
|


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Paul R.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: shared pool memory issue on OPS (non-MTS)

[Jonathan Lewis]

What do the v$resource_limit numbers look like
on the other node ?

Is there any other way that the bad node could
have become the master for all the dictionary
cache information ?  Does one node start up
a few minutes before the other ? Is there
anything that makes one node the preferred
not for user access ?


Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 03 May 2002 14:40


|Jonathon,
|
|Currently we do not pin anything in the shared pool. Still nothing
from
|Oracle on this yet.
|
|Thank you,
|
|Paul Sherman
|DBAElcom, Inc.
|voice -  781-501-4143 (direct #)
|fax-  781-278-8341 (secure)
|email - [EMAIL PROTECTED]
|
|
|-Original Message-
|Sent: Thursday, May 02, 2002 7:43 PM
|To: Multiple recipients of list ORACLE-L
|
|


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

e: shared pool memory issue on OPS (non-MTS)

[Sherman, Paul R.]

Hello,
We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non mts)
on version  8.1.7.2.1 32 bit, we were encountering ora-4031 errors on one of
the instances, so we increased the amount of shared pool memory from 100mb
to 200mb on both nodes in the cluster. Since the shared pool memory was
increased the  instance on the node that had the error is no longer
encountering it. But now the instance on the other node that was not having
any issue, is able to keep only 1% of the shared pool memory free and has
hung 2 times. We are working with Oracle, but would appreciate any ideas. We
know that we have 'bind variable' issues, but not enough to get us into the
situation that we now face.


Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Paul R.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: shared pool memory issue on OPS (non-MTS)

[Anjo Kolk]

Any messages in the alert file, like dynamic lock allocation or resource
allocation ?
In Oracle8 locks and resources for OPS are dynamically allocated from the
shared pool after the initial values of _LM* are used.
You can monitor that in v$resource_limit.

Anjo.

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 02, 2002 9:03 PM


 Hello,
 We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non
mts)
 on version  8.1.7.2.1 32 bit, we were encountering ora-4031 errors on one
of
 the instances, so we increased the amount of shared pool memory from 100mb
 to 200mb on both nodes in the cluster. Since the shared pool memory was
 increased the  instance on the node that had the error is no longer
 encountering it. But now the instance on the other node that was not
having
 any issue, is able to keep only 1% of the shared pool memory free and has
 hung 2 times. We are working with Oracle, but would appreciate any ideas.
We
 know that we have 'bind variable' issues, but not enough to get us into
the
 situation that we now face.


 Thank you,

 Paul Sherman
 DBAElcom, Inc.
 voice -  781-501-4143 (direct #)
 fax-  781-278-8341 (secure)
 email - [EMAIL PROTECTED]

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Sherman, Paul R.
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjo Kolk
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: shared pool memory issue on OPS (non-MTS)

[Rodrigues, Bryan]

No messages in the alert log about dynamic lock allocation, the node that is
having the issue has a small load on it right now and the memory is still
being used up.

Thanks

-Original Message-
Sent: Thursday, May 02, 2002 3:29 PM
To: Multiple recipients of list ORACLE-L


Any messages in the alert file, like dynamic lock allocation or resource
allocation ?
In Oracle8 locks and resources for OPS are dynamically allocated from the
shared pool after the initial values of _LM* are used.
You can monitor that in v$resource_limit.

Anjo.

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 02, 2002 9:03 PM


 Hello,
 We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non
mts)
 on version  8.1.7.2.1 32 bit, we were encountering ora-4031 errors on one
of
 the instances, so we increased the amount of shared pool memory from 100mb
 to 200mb on both nodes in the cluster. Since the shared pool memory was
 increased the  instance on the node that had the error is no longer
 encountering it. But now the instance on the other node that was not
having
 any issue, is able to keep only 1% of the shared pool memory free and has
 hung 2 times. We are working with Oracle, but would appreciate any ideas.
We
 know that we have 'bind variable' issues, but not enough to get us into
the
 situation that we now face.


 Thank you,

 Paul Sherman
 DBAElcom, Inc.
 voice -  781-501-4143 (direct #)
 fax-  781-278-8341 (secure)
 email - [EMAIL PROTECTED]

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Sherman, Paul R.
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjo Kolk
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodrigues, Bryan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: shared pool memory issue on OPS (non-MTS)

[Tim Gorman]

What does V$RESOURCE_LIMIT say?  You can probably post that as a reply...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 02, 2002 2:27 PM


 No messages in the alert log about dynamic lock allocation, the node that
is
 having the issue has a small load on it right now and the memory is still
 being used up.

 Thanks

 -Original Message-
 Sent: Thursday, May 02, 2002 3:29 PM
 To: Multiple recipients of list ORACLE-L


 Any messages in the alert file, like dynamic lock allocation or resource
 allocation ?
 In Oracle8 locks and resources for OPS are dynamically allocated from the
 shared pool after the initial values of _LM* are used.
 You can monitor that in v$resource_limit.

 Anjo.

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, May 02, 2002 9:03 PM


  Hello,
  We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non
 mts)
  on version  8.1.7.2.1 32 bit, we were encountering ora-4031 errors on
one
 of
  the instances, so we increased the amount of shared pool memory from
100mb
  to 200mb on both nodes in the cluster. Since the shared pool memory was
  increased the  instance on the node that had the error is no longer
  encountering it. But now the instance on the other node that was not
 having
  any issue, is able to keep only 1% of the shared pool memory free and
has
  hung 2 times. We are working with Oracle, but would appreciate any
ideas.
 We
  know that we have 'bind variable' issues, but not enough to get us into
 the
  situation that we now face.
 
 
  Thank you,
 
  Paul Sherman
  DBAElcom, Inc.
  voice -  781-501-4143 (direct #)
  fax-  781-278-8341 (secure)
  email - [EMAIL PROTECTED]
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Sherman, Paul R.
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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).
 


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Anjo Kolk
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Rodrigues, Bryan
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: shared pool memory issue on OPS (non-MTS)

[Jonathan Lewis]

Trivial checks that you've probably gone through,
but are there messages for
Dynamic resource allocation
Dynamic lock allocation
in the alert log.

Are you using partitioned views

Do you see lots of waits for DFS Lock handle
on the instance that isn't having the memory
problem



Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 02 May 2002 19:22


|Hello,
|We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster
(non mts)
|on version  8.1.7.2.1 32 bit, we were encountering ora-4031 errors on
one of
|the instances, so we increased the amount of shared pool memory from
100mb
|to 200mb on both nodes in the cluster. Since the shared pool memory
was
|increased the  instance on the node that had the error is no longer
|encountering it. But now the instance on the other node that was not
having
|any issue, is able to keep only 1% of the shared pool memory free and
has
|hung 2 times. We are working with Oracle, but would appreciate any
ideas. We
|know that we have 'bind variable' issues, but not enough to get us
into the
|situation that we now face.
|
|
|Thank you,
|
|Paul Sherman
|DBAElcom, Inc.
|voice -  781-501-4143 (direct #)
|fax-  781-278-8341 (secure)
|email - [EMAIL PROTECTED]
|
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Sherman, Paul R.
|  INET: [EMAIL PROTECTED]
|
|Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|San Diego, California-- Public Internet access / Mailing
Lists
|
|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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: shared pool memory issue on OPS (non-MTS)

[Rodrigues, Bryan]

138  0

D4F7E8A8 MR139  0

D4F7E8F0 MR140  0

D4F7E938 MR141  0

D4F7E980 MR142  0

D4F7E9C8 MR143  0

D4F7EA10 MR144  0

D4F7EA58 MR145  0


ADDR TYID1ID2

 -- -- --

D4F7EAA0 MR146  0

D4F7EAE8 MR147  0

D4F7EB30 MR155  0

D4F7EB78 MR156  0

D4F7EBC0 MR157  0

D4F7EC08 MR158  0

D4F7EC50 MR159  0

D4F7EC98 MR160  0

D4F7ECE0 MR161  0

D4F7ED28 MR162  0

D4F7ED70 MR163  0

D4F7EDB8 MR164  0

D4F7EE00 MR165  0

D4F7EE48 MR166  0

D4F7EE90 MR167  0

D4F7EED8 MR168  0

D4F7EF20 MR169  0

D4F7EF68 MR170  0

D4F7EFB0 MR171  0

D4F7EFF8 MR172  0

D4F7F040 MR173  0

D4F7F088 MR174  0

D4F7F0D0 MR175  0

D4F7F118 MR176  0

D4F7F160 MR177  0

D4F7F1A8 MR178  0

D4F7F1F0 MR179  0

D4F7F238 MR180  0

D4F7F280 MR181  0

D4F7F2C8 MR182  0

D4F7F310 MR183  0

D4F7F358 MR184  0

D4F7F3A0 MR185  0

D4F7F3E8 MR186  0

D4F7F430 MR187  0

D4F7F478 MR188  0

D4F7F4C0 MR189  0

D4F7F508 MR190  0

D4F7F550 MR191  0

D4F7F598 MR192  0

D4F7F5E0 MR193  0

D4F7F628 MR194  0

D4F7F670 MR195  0

D4F7F6B8 MR196  0

D4F7F700 MR197  0

D4F7F748 MR198  0

D4F7F790 MR199  0


ADDR TYID1ID2

 -- -- --

D4F7F7D8 MR200  0

D4F7F820 MR201  0

D4F7F868 MR202  0

D4F7F8B0 MR203  0

D4F7F8F8 MR204  0

D4F7F940 MR205  0

D4F7F988 MR206  0

D4F7F9D0 MR207  0

D4F7FA18 MR208  0

D4F7FA60 MR209  0

D4F7FAA8 MR210  0

D4F7FAF0 MR211  0

D4F7FB38 MR212  0

D4F7FB80 MR213  0

D4F7FBC8 MR214  0

D4F7FC10 MR215  0

D4F7FC58 MR216  0

D4F7FCA0 MR217  0

D4F7FCE8 MR218  0

D4F7FD30 MR219  0

D4F7FD78 MR220  0

D4F7FDC0 MR221  0

D4F7FE08 MR222  0

D4F7FE50 MR223  0

D4F7FE98 MR224  0

D4F7FEE0 MR225  0

D4F7FF28 MR226  0

D4F7FF70 MR227  0

D4F7FFB8 MR228  0

D4F8 MR229  0

D4F80048 MR230  0

D4F80090 MR231  0

D4F800D8 MR232  0

D4F80120 MR233  0

D4F80168 MR234  0

D4F801B0 MR235  0

D4F801F8 MR236  0

D4F80240 MR237  0

D4F80288 MR238  0

D4F802D0 MR239  0

D4F80318 RT  2  2

D4F80360 RT  2  3

D4F803A8 TS 36  109075491

D4F80828 TS130   71305640

D4F80870 TS 45  465568526


233 rows selected.

Please let me know what you see

-Original Message-
Sent: Thursday, May 02, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L


What does V$RESOURCE_LIMIT say?  You can probably post that as a reply...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 02, 2002 2:27 PM


 No messages in the alert log about dynamic lock allocation, the node that
is
 having the issue has a small load on it right now and the memory is still
 being used up.

 Thanks

 -Original Message-
 Sent: Thursday, May 02, 2002 3:29 PM
 To: Multiple recipients of list ORACLE-L


 Any messages in the alert file, like dynamic lock allocation or resource
 allocation ?
 In Oracle8 locks and resources for OPS are dynamically allocated from the
 shared pool after the initial values of _LM* are used.
 You can monitor that in v$resource_limit.

 Anjo.

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, May 02, 2002 9:03 PM


  Hello,
  We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non
 mts)
  on version  8.1.7.2.1 32 bit, we were encountering ora-4031 errors on
one
 of
  the instances, so we increased the amount of shared pool memory from
100mb
  to 200mb on both nodes in the cluster. Since the shared pool memory

RE: shared pool memory issue on OPS (non-MTS)

[Rodrigues, Bryan]

Here is the results from v$resource limit on the node with the problem.

RESOURCE_NAME  CURRENT_UTILIZATION MAX_UTILIZATION
INITIAL_AL LIMIT_VALU
-- --- ---
-- --
processes   52  54
800800
sessions52  56
885885
enqueue_locks  233 242
11081  11081
enqueue_resources  233 261
7870   7870
_lm_procs   52  53
801801
lm_ress 252143  256732
177599  UNLIMITED
lm_locks278106  288642
189208  UNLIMITED
lm_cache_ress25822   25920
0  UNLIMITED
dml_locks0  42
7250   7250
temporary_table_locks0   2
UNLIMITED  UNLIMITED
transactions 0   9
973973

RESOURCE_NAME  CURRENT_UTILIZATION MAX_UTILIZATION
INITIAL_AL LIMIT_VALU
-- --- ---
-- --
sort_segment_locks   0   5
UNLIMITED  UNLIMITED
max_rollback_segments9   9
195195
distributed_transactions 0   0
5  5
mts_max_servers  0   0
20 20
parallel_max_servers 1   1
6  6

16 rows selected.

Please disregard previous message with the contents of v$resource table.


-Original Message-
Sent: Thursday, May 02, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L


What does V$RESOURCE_LIMIT say?  You can probably post that as a reply...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 02, 2002 2:27 PM


 No messages in the alert log about dynamic lock allocation, the node that
is
 having the issue has a small load on it right now and the memory is still
 being used up.

 Thanks

 -Original Message-
 Sent: Thursday, May 02, 2002 3:29 PM
 To: Multiple recipients of list ORACLE-L


 Any messages in the alert file, like dynamic lock allocation or resource
 allocation ?
 In Oracle8 locks and resources for OPS are dynamically allocated from the
 shared pool after the initial values of _LM* are used.
 You can monitor that in v$resource_limit.

 Anjo.

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, May 02, 2002 9:03 PM


  Hello,
  We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non
 mts)
  on version  8.1.7.2.1 32 bit, we were encountering ora-4031 errors on
one
 of
  the instances, so we increased the amount of shared pool memory from
100mb
  to 200mb on both nodes in the cluster. Since the shared pool memory was
  increased the  instance on the node that had the error is no longer
  encountering it. But now the instance on the other node that was not
 having
  any issue, is able to keep only 1% of the shared pool memory free and
has
  hung 2 times. We are working with Oracle, but would appreciate any
ideas.
 We
  know that we have 'bind variable' issues, but not enough to get us into
 the
  situation that we now face.
 
 
  Thank you,
 
  Paul Sherman
  DBAElcom, Inc.
  voice -  781-501-4143 (direct #)
  fax-  781-278-8341 (secure)
  email - [EMAIL PROTECTED]
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Sherman, Paul R.
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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).
 


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Anjo Kolk
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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

Re: shared pool memory issue on OPS (non-MTS)

[Anjo Kolk]

.
 
  Anjo.
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Thursday, May 02, 2002 9:03 PM
 
 
   Hello,
   We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non
  mts)
   on version  8.1.7.2.1 32 bit, we were encountering ora-4031 errors on
 one
  of
   the instances, so we increased the amount of shared pool memory from
 100mb
   to 200mb on both nodes in the cluster. Since the shared pool memory
was
   increased the  instance on the node that had the error is no longer
   encountering it. But now the instance on the other node that was not
  having
   any issue, is able to keep only 1% of the shared pool memory free and
 has
   hung 2 times. We are working with Oracle, but would appreciate any
 ideas.
  We
   know that we have 'bind variable' issues, but not enough to get us
into
  the
   situation that we now face.
  
  
   Thank you,
  
   Paul Sherman
   DBAElcom, Inc.
   voice -  781-501-4143 (direct #)
   fax-  781-278-8341 (secure)
   email - [EMAIL PROTECTED]
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Sherman, Paul R.
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   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).
  
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Anjo Kolk
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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).
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Rodrigues, Bryan
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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).

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Tim Gorman
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Rodrigues, Bryan
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjo Kolk
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Re: shared pool memory issue on OPS (non-MTS)

[Tim Gorman]

.
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Thursday, May 02, 2002 9:03 PM
 
 
   Hello,
   We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non
  mts)
   on version  8.1.7.2.1 32 bit, we were encountering ora-4031 errors on
 one
  of
   the instances, so we increased the amount of shared pool memory from
 100mb
   to 200mb on both nodes in the cluster. Since the shared pool memory
was
   increased the  instance on the node that had the error is no longer
   encountering it. But now the instance on the other node that was not
  having
   any issue, is able to keep only 1% of the shared pool memory free and
 has
   hung 2 times. We are working with Oracle, but would appreciate any
 ideas.
  We
   know that we have 'bind variable' issues, but not enough to get us
into
  the
   situation that we now face.
  
  
   Thank you,
  
   Paul Sherman
   DBAElcom, Inc.
   voice -  781-501-4143 (direct #)
   fax-  781-278-8341 (secure)
   email - [EMAIL PROTECTED]
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Sherman, Paul R.
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   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).
  
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Anjo Kolk
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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).
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Rodrigues, Bryan
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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).

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Tim Gorman
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Rodrigues, Bryan
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Re: shared pool memory issue on OPS (non-MTS)

[Tim Gorman]

Check out the following two values:

Resource Current  MaxInitial  Limit
Name  Utilization   UtilizationAllocation   Value
----   ----  
lm_ress252143  256732 177599   UNLIMITED
lm_locks  278106  288642 189208   UNLIMITED

Notice that Current/Max Utilization is much higher than Initial
Allocation?

This means that (messages to alert.log or not), the DLM is overflowing its
allocated space in the SGA and invading the Shared Pool.  Increase your
LM_RESS and LM_LOCKS parameter values...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 02, 2002 3:58 PM


 Here is the results from v$resource limit on the node with the problem.

 RESOURCE_NAME  CURRENT_UTILIZATION MAX_UTILIZATION
 INITIAL_AL LIMIT_VALU
 -- --- ---
 -- --
 processes   52  54
 800800
 sessions52  56
 885885
 enqueue_locks  233 242
 11081  11081
 enqueue_resources  233 261
 7870   7870
 _lm_procs   52  53
 801801
 lm_ress 252143  256732
 177599  UNLIMITED
 lm_locks278106  288642
 189208  UNLIMITED
 lm_cache_ress25822   25920
 0  UNLIMITED
 dml_locks0  42
 7250   7250
 temporary_table_locks0   2
 UNLIMITED  UNLIMITED
 transactions 0   9
 973973

 RESOURCE_NAME  CURRENT_UTILIZATION MAX_UTILIZATION
 INITIAL_AL LIMIT_VALU
 -- --- ---
 -- --
 sort_segment_locks   0   5
 UNLIMITED  UNLIMITED
 max_rollback_segments9   9
 195195
 distributed_transactions 0   0
 5  5
 mts_max_servers  0   0
 20 20
 parallel_max_servers 1   1
 6  6

 16 rows selected.

 Please disregard previous message with the contents of v$resource table.


 -Original Message-
 Sent: Thursday, May 02, 2002 4:54 PM
 To: Multiple recipients of list ORACLE-L


 What does V$RESOURCE_LIMIT say?  You can probably post that as a reply...

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, May 02, 2002 2:27 PM


  No messages in the alert log about dynamic lock allocation, the node
that
 is
  having the issue has a small load on it right now and the memory is
still
  being used up.
 
  Thanks
 
  -Original Message-
  Sent: Thursday, May 02, 2002 3:29 PM
  To: Multiple recipients of list ORACLE-L
 
 
  Any messages in the alert file, like dynamic lock allocation or resource
  allocation ?
  In Oracle8 locks and resources for OPS are dynamically allocated from
the
  shared pool after the initial values of _LM* are used.
  You can monitor that in v$resource_limit.
 
  Anjo.
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Thursday, May 02, 2002 9:03 PM
 
 
   Hello,
   We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non
  mts)
   on version  8.1.7.2.1 32 bit, we were encountering ora-4031 errors on
 one
  of
   the instances, so we increased the amount of shared pool memory from
 100mb
   to 200mb on both nodes in the cluster. Since the shared pool memory
was
   increased the  instance on the node that had the error is no longer
   encountering it. But now the instance on the other node that was not
  having
   any issue, is able to keep only 1% of the shared pool memory free and
 has
   hung 2 times. We are working with Oracle, but would appreciate any
 ideas.
  We
   know that we have 'bind variable' issues, but not enough to get us
into
  the
   situation that we now face.
  
  
   Thank you,
  
   Paul Sherman
   DBAElcom, Inc.
   voice -  781-501-4143 (direct #)
   fax-  781-278-8341 (secure)
   email - [EMAIL PROTECTED]
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Sherman, Paul R.
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   To REMOVE yourself from this mailing

RE: shared pool memory issue on OPS (non-MTS)

[Scott]

Bryan, There have been issues with this hanging
problem with OPS in some releases. I am not sure if
this is the problem, but applications that heavily use
the rowcache in an OPS environment can have
performance problems if the shared_pool is loaded and
cause sudden hangs when the row cache object is being
flushed from the shared pool. This problems should
have been fixed with 8171 but it appears that the fix
is in 8173. 

Hope this helps,

Scott


--- Rodrigues, Bryan [EMAIL PROTECTED] wrote:
 No messages in the alert log about dynamic lock
 allocation, the node that is
 having the issue has a small load on it right now
 and the memory is still
 being used up.
 
 Thanks
 
 -Original Message-
 Sent: Thursday, May 02, 2002 3:29 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Any messages in the alert file, like dynamic lock
 allocation or resource
 allocation ?
 In Oracle8 locks and resources for OPS are
 dynamically allocated from the
 shared pool after the initial values of _LM* are
 used.
 You can monitor that in v$resource_limit.
 
 Anjo.
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Sent: Thursday, May 02, 2002 9:03 PM
 
 
  Hello,
  We are working on (2) HP 9000 64 bit HP-UX 11.0 in
 an OPS cluster (non
 mts)
  on version  8.1.7.2.1 32 bit, we were encountering
 ora-4031 errors on one
 of
  the instances, so we increased the amount of
 shared pool memory from 100mb
  to 200mb on both nodes in the cluster. Since the
 shared pool memory was
  increased the  instance on the node that had the
 error is no longer
  encountering it. But now the instance on the other
 node that was not
 having
  any issue, is able to keep only 1% of the shared
 pool memory free and has
  hung 2 times. We are working with Oracle, but
 would appreciate any ideas.
 We
  know that we have 'bind variable' issues, but not
 enough to get us into
 the
  situation that we now face.
 
 
  Thank you,
 
  Paul Sherman
  DBAElcom, Inc.
  voice -  781-501-4143 (direct #)
  fax-  781-278-8341 (secure)
  email - [EMAIL PROTECTED]
 
  --
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
  --
  Author: Sherman, Paul R.
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
  San Diego, California-- Public Internet
 access / Mailing Lists
 


  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).
 
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Anjo Kolk
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 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).
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Rodrigues, Bryan
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 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).


__
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: shared pool memory issue on OPS (non-MTS)

[Jonathan Lewis]

That certainly sounds like the solution to the immediate
problem.  (Mind you, those initial numbers look like
generated values, not manual settings).

However, it doesn't answer the question of why
one of the machines has the problem.

Do you think it;s possible that lots of material
gets loaded and KEEP'ed in this instance before
the other instance starts up, making this instance
the resource master for a very large dictionary cache ?



Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 02 May 2002 22:44


|Check out the following two values:
|
|Resource Current  MaxInitial  Limit
|Name  Utilization   UtilizationAllocation   Value
|----   ----  
|lm_ress252143  256732 177599   UNLIMITED
|lm_locks  278106  288642 189208   UNLIMITED
|
|Notice that Current/Max Utilization is much higher than Initial
|Allocation?
|
|This means that (messages to alert.log or not), the DLM is
overflowing its
|allocated space in the SGA and invading the Shared Pool.  Increase
your
|LM_RESS and LM_LOCKS parameter values...
|


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

MTS Question

[Hussain Ahmed Qadri]

Title: MTS Question






MTS configuration, 8.1.7, NT4


Is there anything wrong when we have a negative value, exponential in nature(e.g. -1.838E+09), in the BYTES column of 
V$SHARED_SERVER. The bytes column shows the total number of bytes in all messages that have been processed by a particular server.

Just to give an idea, given below is an example row


NAME STATUS MESSAGES BYTES 
  -- --
S001 EXEC 6903137 -1.838E+09


The value of status column is switching between Exec(meaning this server is executing a SQL) or WAIT (common)(meaning its idle)... Does any of this help in explaining the effect of -ve value.

Regards,




Hussain Ahmed Qadri
Database Administrator
Shaukat Khanum Memorial Cancer Hospital  Research Centre
[EMAIL PROTECTED]
www.shaukatkhanum.org.pk

Re: MTS on 8.1.7.5

[Suzy Vordos]

It works great unless client connections use JDBC thin.  There is a bug
that causes them to appear hung due to unacceptable SLOOO response. 
Supposedly the bug was fixed in 8.1.5.2  8.1.6.3, but we still
experienced problems as of 8.1.7.0.  Haven't tested this under 8.1.7.2
or 8.1.7.3. 

Tracy Rahmlow wrote:
 
 Anybody using multi-threaded server on 8.1.7?  I tried it in the past with poor
 results on 7.3.4 and thought about giving it another chance (actually we are
 having memory issues due to the upgrade from 7.3.4 to 8.1.7)  Any good websites
 with detailed information/scripts for monitoring?  TIA
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Tracy Rahmlow
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

winmail.dat

Re: MTS on 8.1.7.5

[Suzy Vordos]

It works great unless client connections use JDBC thin.  There is a bug
that causes them to appear hung due to unacceptable SLOOO response. 
Supposedly the bug was fixed in 8.1.5.2  8.1.6.3, but we still
experienced problems as of 8.1.7.0.  Haven't tested this under 8.1.7.2
or 8.1.7.3. 

Tracy Rahmlow wrote:
 
 Anybody using multi-threaded server on 8.1.7?  I tried it in the past with poor
 results on 7.3.4 and thought about giving it another chance (actually we are
 having memory issues due to the upgrade from 7.3.4 to 8.1.7)  Any good websites
 with detailed information/scripts for monitoring?  TIA
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Tracy Rahmlow
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

MTS on 8.1.7.5

[Tracy Rahmlow]

Anybody using multi-threaded server on 8.1.7?  I tried it in the past with poor
results on 7.3.4 and thought about giving it another chance (actually we are
having memory issues due to the upgrade from 7.3.4 to 8.1.7)  Any good websites
with detailed information/scripts for monitoring?  TIA


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tracy Rahmlow
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: MTS on 8.1.7.5

[DENNIS WILLIAMS]

Tracy - I'm not using MTS, but usually the first question is how many
users/connections do you have?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, March 06, 2002 4:55 PM
To: Multiple recipients of list ORACLE-L


Anybody using multi-threaded server on 8.1.7?  I tried it in the past with
poor
results on 7.3.4 and thought about giving it another chance (actually we are
having memory issues due to the upgrade from 7.3.4 to 8.1.7)  Any good
websites
with detailed information/scripts for monitoring?  TIA


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tracy Rahmlow
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle MTS and ORA-24777

[Mercadante, Thomas F]

All,

We are writing a Web Application using VB/ADO/COM+.  Some of the data that
we display on the web pages come from another Oracle database, and we are
getting this data using database links.

So far, everything is going fine.

When we are in the middle of performing an update, and at the end of the
update we wish to query across the database link again (to display a new
screen), we are getting ORA-24777 which is telling me that the application
is using dedicated connections, and that I need to use Oracle Multi-Threaded
server connections to query across the link.  If we do not query across the
db link, everything is fine.

I set MTS up on my machine (NT, 817).  The dispatcher and server processes
are up and running, but I cannot for the life of me connect via a shared
server (V$SESSION.SERVER column=DEDICATED).  I am also running through
Oracle Name server, if this matters.

Anybody got an idea of what I'm missing?

Thanks in advanced

Tom Mercadante
Oracle Certified Professional
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: Oracle MTS and ORA-24777

[Sherman, Paul R.]

Thomas,

I've had success with the following, but not 100%; it seems that sometimes
the PC used can play a role in whether or not you get a dedicated or shared
session; I have not yet had time to chase this down, as it would involve a
level 16 trace.

IPMQA_SHARED.NORWOOD.US.CATALINK.COM =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = phoenix)(PORT = 1530))
)
(CONNECT_DATA =
  (SERVICE_NAME=IPMQA)
  (SRVR=SHARED) - here's what works most of the time
)
  )

Thank you,

Paul Sherman
DBA
voice -  781-501-4143 (office)
fax-  781-278-8341 (office)
email - [EMAIL PROTECTED]


-Original Message-
Sent: Monday, February 25, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L


All,

We are writing a Web Application using VB/ADO/COM+.  Some of the data that
we display on the web pages come from another Oracle database, and we are
getting this data using database links.

So far, everything is going fine.

When we are in the middle of performing an update, and at the end of the
update we wish to query across the database link again (to display a new
screen), we are getting ORA-24777 which is telling me that the application
is using dedicated connections, and that I need to use Oracle Multi-Threaded
server connections to query across the link.  If we do not query across the
db link, everything is fine.

I set MTS up on my machine (NT, 817).  The dispatcher and server processes
are up and running, but I cannot for the life of me connect via a shared
server (V$SESSION.SERVER column=DEDICATED).  I am also running through
Oracle Name server, if this matters.

Anybody got an idea of what I'm missing?

Thanks in advanced

Tom Mercadante
Oracle Certified Professional
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Paul R.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: How to backup MTS database with RMAN

[kevin wang]

Title: How to backup MTS database with RMAN




Hi, Hulmet,
I tried. To use RMAN on MTS database 
environment, both database server machine and the RMAN machine(the machine you 
run RMAN on it) should use dedicated server mode instead of shared mode. It 
means the tnsnames.ora file on these two machines(or one machine) 
should
contain SERVER=DEDICATED line. Maybe only 
application box can use shared-mode(server=shared).
example: 
SHAGGY = (DESCRIPTION 
= (ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.25)(PORT = 
1521)) ) (CONNECT_DATA 
= (SERVICE_NAME = 
SHAGGY) (server = 
dedicated) ) )

Kevin Wang

  - Original Message - 
  From: 
  Daiminger, Helmut 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, December 19, 2001 5:25 
  AM
  Subject: How to backup MTS database with 
  RMAN
  
  Hi! 
  Since I'm pretty new to RMAN I have a rather basic 
  question: is it possible to backup databases running in multithreaded server 
  mode with RMAN? Or does this have to be dedicated server mode?
  $ rman target sys/@kpmgi rcvcat rman/x@admserv 
  Recovery Manager: Release 8.1.7.2.0 - 
  Production 
  RMAN-06005: connected to target database: 
  KPMGI (DBID=3995384462) RMAN-06008: 
  connected to recovery catalog database 
  RMAN register database; 
  RMAN-03022: compiling command: 
  register RMAN-03023: executing 
  command: register RMAN-08006: 
  database registered in recovery catalog RMAN-03023: executing command: full resync RMAN-03026: error recovery releasing channel 
  resources RMAN-00571: 
  === RMAN-00569: === ERROR MESSAGE STACK 
  FOLLOWS === RMAN-00571: 
  === RMAN-07005: error during channel cleanup 
  RMAN-07004: unhandled exception during 
  command execution on channel default RMAN-10035: exception raised in RPC: ORA-19550: cannot use 
  backup/restore functions while using dispatcher RMAN-10031: ORA-19550 occurred during call to 
  DBMS_BACKUP_RESTORE.CFILEUSECURRENT RMAN-03008: error while performing automatic resync of recovery 
  catalog RMAN-07004: unhandled 
  exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-19550: 
  cannot use backup/restore functions while using dispatcher RMAN-10031: ORA-19550 occurred during call to 
  DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT 
  Do I just have to take out mts_dispatchers = 
  "(protocol=TCP)" from the init.ora file? 
  This is 8.1.7.2.0 on Sun Solaris. 
  Thanks, Helmut 

How to backup MTS database with RMAN

[Daiminger, Helmut]

Title: How to backup MTS database with RMAN





Hi!


Since I'm pretty new to RMAN I have a rather basic question: is it possible to backup databases running in multithreaded server mode with RMAN? Or does this have to be dedicated server mode?


$ rman target sys/@kpmgi rcvcat rman/x@admserv


Recovery Manager: Release 8.1.7.2.0 - Production


RMAN-06005: connected to target database: KPMGI (DBID=3995384462)
RMAN-06008: connected to recovery catalog database


RMAN register database;


RMAN-03022: compiling command: register
RMAN-03023: executing command: register
RMAN-08006: database registered in recovery catalog
RMAN-03023: executing command: full resync
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-07005: error during channel cleanup
RMAN-07004: unhandled exception during command execution on channel default
RMAN-10035: exception raised in RPC: ORA-19550: cannot use backup/restore functions while using dispatcher
RMAN-10031: ORA-19550 occurred during call to DBMS_BACKUP_RESTORE.CFILEUSECURRENT
RMAN-03008: error while performing automatic resync of recovery catalog
RMAN-07004: unhandled exception during command execution on channel default
RMAN-10035: exception raised in RPC: ORA-19550: cannot use backup/restore functions while using dispatcher
RMAN-10031: ORA-19550 occurred during call to DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT



Do I just have to take out mts_dispatchers = (protocol=TCP) from the init.ora file?


This is 8.1.7.2.0 on Sun Solaris.


Thanks,
Helmut

RE: How to backup MTS database with RMAN

[Mercadante, Thomas F]

Title: How to backup MTS database with RMAN



Helmut,

From 
the Oracle Documentation:

To use RMAN with an MTS 
database:
Net8 configuration varies greatly 
from system to system. The following procedure illustrates only one method. 

This scenario assumes that the 
following net service name in the tnsnames.ora file connects to the target 
database using the MTSarchitecture, where inst1 is a value of the 
SERVICE_NAMES initialization parameter: 

inst1_mts = 
(description= 
(address=(protocol=tcp)(host=inst1_host)(port1521)) 
(connect_data=(service_name=inst1)(server=shared)) ) 

 1.Create a net service 
name in the tnsnames.ora file that connects to the non-shared SID. For example, 
enter: 
 inst1_ded 
= 
(description= 
(address=(protocol=tcp)(host=inst1_host)(port1521)) 
(connect_data=(service_name=inst1)(server=dedicated)) 
)
 2.Connect using 
SQL*Plus using both the MTS and dedicated service names to confirm the mode of 
each session. For example, toconnect 
to a dedicated session you can issue: 

 SQL 
connect sys/oracle@inst1_ded 
Connected. SQL SELECT server FROM v$session 
WHERE sid = (SELECT DISTINCT sid FROM v$mystat);

 
SERVER  
- DEDICATED 1 
row selected.

To connect to an MTS session, you can 
issue: 

SQL connect 
sys/oracle@inst1_mtsConnected.SQL SELECT server FROM v$session WHERE 
sid = (SELECT DISTINCT sid FROM v$mystat);

SERVER 
-SHARED 1 row selected.
 Connect to the target database 
(and optionally the recovery catalog) using the dedicated service name. For 
example, enter: 

% rman target sys/oracle@inst1_ded 
catalog rman/rman@rcat
HTH
Tom 
Mercadante Oracle Certified 
Professional 

  -Original Message-From: Daiminger, Helmut 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 
  19, 2001 8:25 AMTo: Multiple recipients of list 
  ORACLE-LSubject: How to backup MTS database with 
  RMAN
  Hi! 
  Since I'm pretty new to RMAN I have a rather basic 
  question: is it possible to backup databases running in multithreaded server 
  mode with RMAN? Or does this have to be dedicated server mode?
  $ rman target sys/@kpmgi rcvcat 
  rman/x@admserv 
  Recovery Manager: Release 8.1.7.2.0 - 
  Production 
  RMAN-06005: connected to target database: 
  KPMGI (DBID=3995384462) RMAN-06008: 
  connected to recovery catalog database 
  RMAN register database; 
  RMAN-03022: compiling command: 
  register RMAN-03023: executing 
  command: register RMAN-08006: 
  database registered in recovery catalog RMAN-03023: executing command: full resync RMAN-03026: error recovery releasing channel 
  resources RMAN-00571: 
  === RMAN-00569: === ERROR MESSAGE STACK 
  FOLLOWS === RMAN-00571: 
  === RMAN-07005: error during channel cleanup 
  RMAN-07004: unhandled exception during 
  command execution on channel default RMAN-10035: exception raised in RPC: ORA-19550: cannot use 
  backup/restore functions while using dispatcher RMAN-10031: ORA-19550 occurred during call to 
  DBMS_BACKUP_RESTORE.CFILEUSECURRENT RMAN-03008: error while performing automatic resync of recovery 
  catalog RMAN-07004: unhandled 
  exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-19550: 
  cannot use backup/restore functions while using dispatcher RMAN-10031: ORA-19550 occurred during call to 
  DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT 
  Do I just have to take out mts_dispatchers = 
  "(protocol=TCP)" from the init.ora file? 
  This is 8.1.7.2.0 on Sun Solaris. 
  Thanks, Helmut 

e: using MTS on oracle OPS, running on HP-UX

[Sherman, Paul R.]

Hello,

Anyone out there try and implement MTS on OPS ? We are using 64-bit HP-UX,
rev 11.0, and the OPS is 8.1.6.3.0. We look to go with MTS after we are at
8.1.7.2.1, sometime next month.

Thank you,

Paul Sherman
DBA
voice -  781-501-4143 (office)
fax-  781-278-8341 (office)
email - [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Paul R.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: using MTS on oracle OPS, running on HP-UX

[Wong, Bing]

Why do you need to use MTS?  Do you run out of memory?

-Original Message-
Sent: Wednesday, December 19, 2001 9:09 AM
To: Multiple recipients of list ORACLE-L


Hello,

Anyone out there try and implement MTS on OPS ? We are using 64-bit HP-UX,
rev 11.0, and the OPS is 8.1.6.3.0. We look to go with MTS after we are at
8.1.7.2.1, sometime next month.

Thank you,

Paul Sherman
DBA
voice -  781-501-4143 (office)
fax-  781-278-8341 (office)
email - [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Paul R.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Wong, Bing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: How to backup MTS database with RMAN

[kevin wang]

Title: How to backup MTS database with RMAN



Hi, Hulmet,
I tried. To use RMAN on MTS database 
environment, both database server machine and the RMAN machine(the machine you 
run RMAN on it) should use dedicated server mode instead of shared mode. It 
means the tnsnames.ora file on these two machines(or one machine) 
should
contain SERVER=DEDICATED line. Maybe only 
application box can use shared-mode(server=shared).
example: 
SHAGGY = (DESCRIPTION 
= (ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.25)(PORT = 
1521)) ) (CONNECT_DATA 
= (SERVICE_NAME = 
SHAGGY) (server = 
dedicated) ) )

Kevin Wang




  - Original Message - 
  From: 
  Daiminger, Helmut 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, December 19, 2001 5:25 
  AM
  Subject: How to backup MTS database with 
  RMAN
  
  Hi! 
  Since I'm pretty new to RMAN I have a rather basic 
  question: is it possible to backup databases running in multithreaded server 
  mode with RMAN? Or does this have to be dedicated server mode?
  $ rman target sys/@kpmgi rcvcat rman/x@admserv 
  Recovery Manager: Release 8.1.7.2.0 - 
  Production 
  RMAN-06005: connected to target database: 
  KPMGI (DBID=3995384462) RMAN-06008: 
  connected to recovery catalog database 
  RMAN register database; 
  RMAN-03022: compiling command: 
  register RMAN-03023: executing 
  command: register RMAN-08006: 
  database registered in recovery catalog RMAN-03023: executing command: full resync RMAN-03026: error recovery releasing channel 
  resources RMAN-00571: 
  === RMAN-00569: === ERROR MESSAGE STACK 
  FOLLOWS === RMAN-00571: 
  === RMAN-07005: error during channel cleanup 
  RMAN-07004: unhandled exception during 
  command execution on channel default RMAN-10035: exception raised in RPC: ORA-19550: cannot use 
  backup/restore functions while using dispatcher RMAN-10031: ORA-19550 occurred during call to 
  DBMS_BACKUP_RESTORE.CFILEUSECURRENT RMAN-03008: error while performing automatic resync of recovery 
  catalog RMAN-07004: unhandled 
  exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-19550: 
  cannot use backup/restore functions while using dispatcher RMAN-10031: ORA-19550 occurred during call to 
  DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT 
  Do I just have to take out mts_dispatchers = 
  "(protocol=TCP)" from the init.ora file? 
  This is 8.1.7.2.0 on Sun Solaris. 
  Thanks, Helmut 

Reg. MTS Connections..

[Arul kumar]

Hi DBAs,

I wud like to know the advantages of using MTS connections.

While querying V$session, i found the SERVER column showing

DEDICATED
NONE

values for some sessions. What does this mean? and which type of
connection is good?
Is there any recommendations like which type of application shud use
such type of connections.

Any doc or ppt avail. in the net ?

Thanks in advance.

Arul.


*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arul kumar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Dumb MTS Concepts Question

[Bill Buchan]

I've not used MTS before and am just reading up on it.  Anyone help me out 
with the following?

In a dedicated server environment each PGA has a UGA where things like 
cursor state and session data is held.
In a MTS environment, this UGA is in the large pool in the SGA instead.

This is just moving memory resources around, not reducing them?  How does 
MTS manage to support more concurrent users - I can't see how the actual 
UGA gets any smaller, cursor state etc. will still need to be preserved 
whether or not the session is active.

Thanks
- Bill


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Buchan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: Dumb MTS Concepts Question

[Christian Trassens]

Yes the resources move around. However when you use
MTS, you share the server sessions. Therefore, it is
possible depending the kind of the application that
Oracle will share the UGA of those shared server
sessions for all the users. In other words, if your
application is an OLTP one, you will find that a few
shared servers serves a lot of users. 

Regards.


--- Bill Buchan [EMAIL PROTECTED] wrote:
 
 I've not used MTS before and am just reading up on
 it.  Anyone help me out 
 with the following?
 
 In a dedicated server environment each PGA has a UGA
 where things like 
 cursor state and session data is held.
 In a MTS environment, this UGA is in the large pool
 in the SGA instead.
 
 This is just moving memory resources around, not
 reducing them?  How does 
 MTS manage to support more concurrent users - I
 can't see how the actual 
 UGA gets any smaller, cursor state etc. will still
 need to be preserved 
 whether or not the session is active.
 
 Thanks
 - Bill
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Bill Buchan
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 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).


=
Eng. Christian Trassens
Senior DBA
Systems Engineer
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : 541149816062

__
Do You Yahoo!?
Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

oracle 8i and mts problem

[daniel szabo]

Hello there, Oracle users!I am new here, as new to the Oracle 
technology. We are developping a =software which must be transaction 
compliant, and we're on microsoft =platform, and thatswy we're using sql2000 
and microsoft transaction =server for our application server 
components.=20But one of our clients wants to use oracle 8i db as the 
resource =manager. We had to make the proper work mts with oracle. I red all 
of =the oracle documentation within this topic, and i successfully installed 
=the Oracle Services for MTS on our development machine at the workplace. 
=(created the mts_proxy_info table, granted the specific roles to a 
=specific db user, the specific privileges, the xa views, and so on), and 
=it is working nicely, the log says "accepting new enlistment request", 
=everything is wonderful.But at the client, i repeated all of the 
steps (the only difference is, =that they have the server on a HP-UX machine 
instead of winnt), and when =i wanted to start the oracle services for MTS 
on the Application server, =the log says this: "incorrect password, or 
username". I really don't =undestand it, because i can connect through the 
OLEDB driver with the =specified username, password and Service 
name.=20If anybody had an idea i would be very happythanks in 
advance,daniel szabo

mts parameters

[Saurabh Sharma]

hi all,
do the setting up of following mts 
parameters means, i'm using mts architecture.

mts_dispatchers 
string 
(ADDRESS=(PARTIAL=YES)(PROTOCOmts_listener_address 
stringmts_max_dispatchers 
integer 
5mts_max_servers 
integer 
20mts_multiple_listeners 
boolean 
FALSEmts_servers 
integer 
1mts_service 
string APEX

by mts configuration, the doc 
says..

The multi-threaded 
server architecture eliminates the need for a dedicated server process for 
each connection. A small number of 
shared server processes can perform the same amount of processing as many 
dedicated server processes.

but all the connections made to 
server are dedicated. what does this means. what is then i'm 
using..

Saurabh Sharma

[EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html

BEGIN:VCARD
VERSION:2.1
N:Sharma;Saurabh
FN:Saurabh Sharma
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20010808T095228Z
END:VCARD

Re: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

[chao_ping]

hi, 
have u made it? i also encounted the same problem of oracle 817 on solaris,
if i specify server=shared in tnsnames.ora, then it gives out 12520 error code.

- Original Message - 
From: Harvinder Singh [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 11:36 PM
Subject: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED


 
 Hi,
 
 I have configured the server to use MTS and still dedicated connections r
 used.
 What might be the reasondatabase is 8.1.6.3.4
 
 
 
 LSNRCTL services
 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
 Services Summary...
   ora2000   has 6 service handler(s)
 DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
   D004 machine: ORA2000, pid: 1956
   (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
 DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
   D003 machine: ORA2000, pid: 1952
   (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
 DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
   D002 machine: ORA2000, pid: 1948
   (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
 DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
   D001 machine: ORA2000, pid: 1944
   (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
 DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
   D000 machine: ORA2000, pid: 1940
   (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
   PLSExtProchas 1 service handler(s)
 DEDICATED SERVER established:0 refused:0
   LOCAL SERVER
   ora2000   has 6 service handler(s)
 DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
   D004 machine: ORA2000, pid: 1956
   (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
 DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
   D003 machine: ORA2000, pid: 1952
   (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
 DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
   D002 machine: ORA2000, pid: 1948
   (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
 DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
   D001 machine: ORA2000, pid: 1944
   (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
 DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
   D000 machine: ORA2000, pid: 1940
   (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
   ora2000   has 1 service handler(s)
 DEDICATED SERVER established:0 refused:0
   LOCAL SERVER
   ora2000   has 6 service handler(s)
 DEDICATED SERVER established:76 refused:0
   LOCAL SERVER
 The command completed successfully
 
 
 init.ora looks like:
 
 mts_dispatchers = TCP,5
 mts_max_dispatchers=50 
 mts_servers=20  
 mts_max_servers=50 
 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000)
 (Port=1521))) 
 
 
 Thanks
 Harvinder
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Harvinder Singh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).
•æ¬zǞ¶¨}øœ‰©ND‹±@Bm§ÿðÃ
+iöªr‰€ºØh­ÈZ¢˜§€ƒDMÈZ¢˜§Éòj(r‰œœV­
+r5ëp¢¹z»âqëçÎwó9ÔPóŸ9ßÎtçTšœ8ž‚€š–'è®xšæå‰Â'µêçz֜që,üÆ¢–)à.+-±:Õ*.®Ç¥}úèšØb²f¢–)à–+-±éÝjq
+j)fzˁëh.+-êî}«\ŠÜœ¢ièµá$ì¥éeŠx(|¸¬´k«¹©ÝŠ{azg¬±¨à؊w%¹×š–)Þr‰íj)âž
+I@ND‹º+¶§jg¨~f¢–)à–+-ʋ°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ‡³Ü¢iš×讋az¸§~ŠæjبžX¤z˛±Êân)à

RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

[Anderson, Brian]

I'm betting you have epc_disabled in your listener.ora file.

(ENVS='EPC_DISABLED=TRUE')

This was put in to disable oracle trace in 8.0.5, but I was told it
caused problems for 8.1.6.  I hadn't looked on metalink for details, but
after removing the epc_disabled line from my listener.ora, my MTS works
fine under 8.1.6.3.  I was having the same trouble getting only
dedicated connections.

I just looked so I guess I'll have to try double quotes.

HTH

Brian

***
upgrade question 8.06 to 8.1.6 (EPC_DISABLED) 

Hello, 
friday i upgraded 8.0.6 to 8.1.6. thanks to you for the help l I became
succesfull. The only issue i had was with the listener having this
EPC_DISABLED=TRUE. the following is my current litsener configuration
for 816. How can I enable EPC_DISABLED=TRUE for 8.1.6? When epc was
enabled i received the following error message so i had to comment it
out. 
=== 
TNS-12500: TNS:listener failed to start a dedicated server process 
TNS-12533: TNS:illegal ADDRESS parameters 
TNS-12560: TNSrotocol adapter error 
TNS-00503: Illegal ADDRESS parameter 
= 
LISTENER = (ADDRESS_LIST = 
(ADDRESS = 
(PROTOCOL = IPC) 
(KEY = listener)) 

(ADDRESS = 
(PROTOCOL = IPC) 
(KEY = prod)) 

(ADDRESS = 
(PROTOCOL = tcp) 
(HOST = chihpdv2) 
(PORT = 1521)) 
) 
CONNECT_TIMEOUT_LISTENER = 90 
SID_LIST_LISTENER = (SID_LIST = 
(SID_DESC = 
(SID_NAME = prod) 
(ORACLE_HOME = /home/oracle/product/8.1.6) 
# (ENVS='EPC_DISABLED=TRUE') 
) 
) 







use double quotes  around the environment string. 




 -Original Message-
 From: chao_ping [mailto:[EMAIL PROTECTED]]
 Sent: Monday, August 06, 2001 2:46 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
 
 
 hi, 
 have u made it? i also encounted the same problem of 
 oracle 817 on solaris,
 if i specify server=shared in tnsnames.ora, then it gives 
 out 12520 error code.
 
 - Original Message - 
 From: Harvinder Singh [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, July 25, 2001 11:36 PM
 Subject: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
 
 
  
  Hi,
  
  I have configured the server to use MTS and still dedicated 
 connections r
  used.
  What might be the reasondatabase is 8.1.6.3.4
  
  
  
  LSNRCTL services
  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
  Services Summary...
ora2000   has 6 service handler(s)
  DISPATCHER established:0 refused:0 current:0 max:1022 
 state:ready
D004 machine: ORA2000, pid: 1956
(ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
  DISPATCHER established:0 refused:0 current:0 max:1022 
 state:ready
D003 machine: ORA2000, pid: 1952
(ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
  DISPATCHER established:0 refused:0 current:0 max:1022 
 state:ready
D002 machine: ORA2000, pid: 1948
(ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
  DISPATCHER established:0 refused:0 current:0 max:1022 
 state:ready
D001 machine: ORA2000, pid: 1944
(ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
  DISPATCHER established:0 refused:0 current:0 max:1022 
 state:ready
D000 machine: ORA2000, pid: 1940
(ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
PLSExtProchas 1 service handler(s)
  DEDICATED SERVER established:0 refused:0
LOCAL SERVER
ora2000   has 6 service handler(s)
  DISPATCHER established:0 refused:0 current:0 max:1022 
 state:ready
D004 machine: ORA2000, pid: 1956
(ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
  DISPATCHER established:0 refused:0 current:0 max:1022 
 state:ready
D003 machine: ORA2000, pid: 1952
(ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
  DISPATCHER established:0 refused:0 current:0 max:1022 
 state:ready
D002 machine: ORA2000, pid: 1948
(ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
  DISPATCHER established:0 refused:0 current:0 max:1022 
 state:ready
D001 machine: ORA2000, pid: 1944
(ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
  DISPATCHER established:0 refused:0 current:0 max:1022 
 state:ready
D000 machine: ORA2000, pid: 1940
(ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
ora2000   has 1 service handler(s)
  DEDICATED SERVER established:0 refused:0
LOCAL SERVER
ora2000   has 6 service handler(s)
  DEDICATED SERVER established:76 refused:0
LOCAL SERVER
  The command completed successfully
  
  
  init.ora looks like:
  
  mts_dispatchers = TCP,5
  mts_max_dispatchers=50 
  mts_servers=20  
  mts_max_servers=50 
  LOCAL_LISTENER = (ADDRESS_LIST

Re: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

[Christian Trassens]

Probably your clients or the users have in their
sqlnet.ora the parameter use_dedicated_server=TRUE or
in the entry of the tnsnames.ora a clause like
(SERVER=DEDICATED).

Also issue an netstat to see if everything is alright.
If you find any problem with the ports of the
dispatchers, try forcing them in the parameter
mts_dispatcher.

Regards.


--- Harvinder Singh [EMAIL PROTECTED]
wrote:
 Hi,
 
 I have configured the server to use MTS and still
 dedicated connections r
 used.
 What might be the reasondatabase is 8.1.6.3.4
 
 
 
 LSNRCTL services
 Connecting to
 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
 Services Summary...
   ora2000   has 6 service handler(s)
 DISPATCHER established:0 refused:0 current:0
 max:1022 state:ready
   D004 machine: ORA2000, pid: 1956
  
 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
 DISPATCHER established:0 refused:0 current:0
 max:1022 state:ready
   D003 machine: ORA2000, pid: 1952
  
 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
 DISPATCHER established:0 refused:0 current:0
 max:1022 state:ready
   D002 machine: ORA2000, pid: 1948
  
 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
 DISPATCHER established:0 refused:0 current:0
 max:1022 state:ready
   D001 machine: ORA2000, pid: 1944
  
 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
 DISPATCHER established:0 refused:0 current:0
 max:1022 state:ready
   D000 machine: ORA2000, pid: 1940
  
 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
   PLSExtProchas 1 service handler(s)
 DEDICATED SERVER established:0 refused:0
   LOCAL SERVER
   ora2000   has 6 service handler(s)
 DISPATCHER established:0 refused:0 current:0
 max:1022 state:ready
   D004 machine: ORA2000, pid: 1956
  
 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
 DISPATCHER established:0 refused:0 current:0
 max:1022 state:ready
   D003 machine: ORA2000, pid: 1952
  
 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
 DISPATCHER established:0 refused:0 current:0
 max:1022 state:ready
   D002 machine: ORA2000, pid: 1948
  
 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
 DISPATCHER established:0 refused:0 current:0
 max:1022 state:ready
   D001 machine: ORA2000, pid: 1944
  
 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
 DISPATCHER established:0 refused:0 current:0
 max:1022 state:ready
   D000 machine: ORA2000, pid: 1940
  
 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
   ora2000   has 1 service handler(s)
 DEDICATED SERVER established:0 refused:0
   LOCAL SERVER
   ora2000   has 6 service handler(s)
 DEDICATED SERVER established:76 refused:0
   LOCAL SERVER
 The command completed successfully
 
 
 init.ora looks like:
 
 mts_dispatchers = TCP,5
 mts_max_dispatchers=50 
 mts_servers=20  
 mts_max_servers=50 
 LOCAL_LISTENER = (ADDRESS_LIST = (Address =
 (Protocol = TCP) (Host=ora2000)
 (Port=1521))) 
 
 
 Thanks
 Harvinder
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Harvinder Singh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 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).


=
Eng. Christian Trassens
Senior DBA
Systems Engineer
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : 541149816062

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

[Harvinder Singh]

Hi,

I have configured the server to use MTS and still dedicated connections r
used.
What might be the reasondatabase is 8.1.6.3.4



LSNRCTL services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...
  ora2000   has 6 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D004 machine: ORA2000, pid: 1956
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D003 machine: ORA2000, pid: 1952
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D002 machine: ORA2000, pid: 1948
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D001 machine: ORA2000, pid: 1944
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D000 machine: ORA2000, pid: 1940
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
  PLSExtProchas 1 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
  ora2000   has 6 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D004 machine: ORA2000, pid: 1956
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D003 machine: ORA2000, pid: 1952
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D002 machine: ORA2000, pid: 1948
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D001 machine: ORA2000, pid: 1944
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D000 machine: ORA2000, pid: 1940
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
  ora2000   has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
  ora2000   has 6 service handler(s)
DEDICATED SERVER established:76 refused:0
  LOCAL SERVER
The command completed successfully


init.ora looks like:

mts_dispatchers = TCP,5
mts_max_dispatchers=50 
mts_servers=20  
mts_max_servers=50 
LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000)
(Port=1521))) 


Thanks
Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

[Austin, Steve S]

Check the client's sqlnet.ora.  It can override the server config with
USE_DEDICATED_SERVER=ON setting.

Steve

-Original Message-
Sent: Wednesday, July 25, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L



Hi,

I have configured the server to use MTS and still dedicated connections r
used.
What might be the reasondatabase is 8.1.6.3.4



LSNRCTL services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...
  ora2000   has 6 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D004 machine: ORA2000, pid: 1956
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D003 machine: ORA2000, pid: 1952
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D002 machine: ORA2000, pid: 1948
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D001 machine: ORA2000, pid: 1944
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D000 machine: ORA2000, pid: 1940
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
  PLSExtProchas 1 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
  ora2000   has 6 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D004 machine: ORA2000, pid: 1956
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D003 machine: ORA2000, pid: 1952
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D002 machine: ORA2000, pid: 1948
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D001 machine: ORA2000, pid: 1944
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D000 machine: ORA2000, pid: 1940
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
  ora2000   has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
  ora2000   has 6 service handler(s)
DEDICATED SERVER established:76 refused:0
  LOCAL SERVER
The command completed successfully


init.ora looks like:

mts_dispatchers = TCP,5
mts_max_dispatchers=50 
mts_servers=20  
mts_max_servers=50 
LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000)
(Port=1521))) 


Thanks
Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Austin, Steve S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

[Harvinder Singh]

this option is not set so i assume default is OFF...
any other clue...

-Original Message-
Sent: Wednesday, July 25, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L


Check the client's sqlnet.ora.  It can override the server config with
USE_DEDICATED_SERVER=ON setting.

Steve

-Original Message-
Sent: Wednesday, July 25, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L



Hi,

I have configured the server to use MTS and still dedicated connections r
used.
What might be the reasondatabase is 8.1.6.3.4



LSNRCTL services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...
  ora2000   has 6 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D004 machine: ORA2000, pid: 1956
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D003 machine: ORA2000, pid: 1952
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D002 machine: ORA2000, pid: 1948
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D001 machine: ORA2000, pid: 1944
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D000 machine: ORA2000, pid: 1940
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
  PLSExtProchas 1 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
  ora2000   has 6 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D004 machine: ORA2000, pid: 1956
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D003 machine: ORA2000, pid: 1952
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D002 machine: ORA2000, pid: 1948
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D001 machine: ORA2000, pid: 1944
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D000 machine: ORA2000, pid: 1940
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
  ora2000   has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
  ora2000   has 6 service handler(s)
DEDICATED SERVER established:76 refused:0
  LOCAL SERVER
The command completed successfully


init.ora looks like:

mts_dispatchers = TCP,5
mts_max_dispatchers=50 
mts_servers=20  
mts_max_servers=50 
LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000)
(Port=1521))) 


Thanks
Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Austin, Steve S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

[Durinda.Jones]

A couple of things I would check.  I don't believe you need the ADDRESS_LIST
parameter, unless you will have multiples.  I would remove the spaces in the
parameter.  I would make sure that the HOST equals the machine name,
possibly make the entry upper case.  As foolish as it sounds, I've seen
these things make a difference.

Set it up to look like this and see if it helps.  LOCAL_LISTENER =
(Address=(Protocol=TCP)(Host=ORA2000)(Port=1521)) 

I recently had a problem where the HOST wasn't the same as the machine name.
Fixed that and the problem went away.

Hope this helps out,
Durinda

-Original Message-
Sent: Wednesday, July 25, 2001 1:11 PM
To: Multiple recipients of list ORACLE-L


this option is not set so i assume default is OFF...
any other clue...

-Original Message-
Sent: Wednesday, July 25, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L


Check the client's sqlnet.ora.  It can override the server config with
USE_DEDICATED_SERVER=ON setting.

Steve

-Original Message-
Sent: Wednesday, July 25, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L



Hi,

I have configured the server to use MTS and still dedicated connections r
used.
What might be the reasondatabase is 8.1.6.3.4



LSNRCTL services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...
  ora2000   has 6 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D004 machine: ORA2000, pid: 1956
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D003 machine: ORA2000, pid: 1952
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D002 machine: ORA2000, pid: 1948
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D001 machine: ORA2000, pid: 1944
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D000 machine: ORA2000, pid: 1940
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
  PLSExtProchas 1 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
  ora2000   has 6 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D004 machine: ORA2000, pid: 1956
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D003 machine: ORA2000, pid: 1952
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D002 machine: ORA2000, pid: 1948
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D001 machine: ORA2000, pid: 1944
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D000 machine: ORA2000, pid: 1940
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
  ora2000   has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
  ora2000   has 6 service handler(s)
DEDICATED SERVER established:76 refused:0
  LOCAL SERVER
The command completed successfully


init.ora looks like:

mts_dispatchers = TCP,5
mts_max_dispatchers=50 
mts_servers=20  
mts_max_servers=50 
LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000)
(Port=1521))) 


Thanks
Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Austin, Steve S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

[Harvinder Singh]

i tried removing the spaces but it didn't help..if the client and server
r on the same machine ...
will it use ipc instead of tcp and if so do i have to configure dispacher
for ipc and mention ipc in local_listener.

-H

-Original Message-
Sent: Wednesday, July 25, 2001 3:09 PM
To: Multiple recipients of list ORACLE-L


A couple of things I would check.  I don't believe you need the ADDRESS_LIST
parameter, unless you will have multiples.  I would remove the spaces in the
parameter.  I would make sure that the HOST equals the machine name,
possibly make the entry upper case.  As foolish as it sounds, I've seen
these things make a difference.

Set it up to look like this and see if it helps.  LOCAL_LISTENER =
(Address=(Protocol=TCP)(Host=ORA2000)(Port=1521)) 

I recently had a problem where the HOST wasn't the same as the machine name.
Fixed that and the problem went away.

Hope this helps out,
Durinda

-Original Message-
Sent: Wednesday, July 25, 2001 1:11 PM
To: Multiple recipients of list ORACLE-L


this option is not set so i assume default is OFF...
any other clue...

-Original Message-
Sent: Wednesday, July 25, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L


Check the client's sqlnet.ora.  It can override the server config with
USE_DEDICATED_SERVER=ON setting.

Steve

-Original Message-
Sent: Wednesday, July 25, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L



Hi,

I have configured the server to use MTS and still dedicated connections r
used.
What might be the reasondatabase is 8.1.6.3.4



LSNRCTL services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...
  ora2000   has 6 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D004 machine: ORA2000, pid: 1956
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D003 machine: ORA2000, pid: 1952
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D002 machine: ORA2000, pid: 1948
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D001 machine: ORA2000, pid: 1944
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D000 machine: ORA2000, pid: 1940
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
  PLSExtProchas 1 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
  ora2000   has 6 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D004 machine: ORA2000, pid: 1956
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D003 machine: ORA2000, pid: 1952
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D002 machine: ORA2000, pid: 1948
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D001 machine: ORA2000, pid: 1944
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
  D000 machine: ORA2000, pid: 1940
  (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
  ora2000   has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
  ora2000   has 6 service handler(s)
DEDICATED SERVER established:76 refused:0
  LOCAL SERVER
The command completed successfully


init.ora looks like:

mts_dispatchers = TCP,5
mts_max_dispatchers=50 
mts_servers=20  
mts_max_servers=50 
LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000)
(Port=1521))) 


Thanks
Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Austin, Steve S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists