In my experience MTS was (I've stopped using it) 4 - 6 TIMES
slower than using a dedicated connection. This was consistently
measured during our "nightwork batch processing" over multiple
nights over multiple weeks. Using MTS, one stream was taking
4 - 6 hours to complete. Whenever we ran it via a dedicated
connection the run times shrunk to right around 1 HOUR!
At the time I had 32 servers and only 1 - 4 single threaded
job streams running against the instance.
FWIW - Solaris V2.6 & Oracle V7.3.4.5
[EMAIL PROTECTED] wrote:
>
> James,
>
> In general I notice that MTS can slow things down IF there are not enough
> shared servers running so that at least one server is constantly idle.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "James Xing" <[EMAIL PROTECTED]>
> Date: 5/24/2001 9:36 AM
>
> RE: MaximoThanks Chris,
> Did you turn on MTS on your production server? Is that recommended?
> In our environment, the system was fine on dev server which is not using
> MTS, another DBA who is in charge of production server turned MTS on and
> found the performance is 4 times slower.
>
> James
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, Chris
> Sent: Wednesday, May 23, 2001 8:28 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Maximo
>
> ON all the maximo installations I have done, the biggest problems have
> been with maxencrypt a table that holds the encrypted key that allows
> everyone in the base. There is a script that will reset this if the users
> cannot get into the system. Make sure that the character set in the client
> is set to the same as the base. If users cannot get into the base due to
> bad password and you *know* the user/password are correct, then something
> happened to the maxencrypt and/or the character sets are not the same. I am
> hoping that 4i eliminates that table, but since I haven't seen it, I don't
> know if it does.
>
> I don't know about the current version, but when I worked with it about a
> year ago, the indexes were terrible. We dropped and created a number of
> indexes to improve things. We used cost base optimization (oracle v7 at the
> time) and and a job that analyzed every couple weeks on the big tables and
> every month on the others.
>
> If you have to do an import of the base, you will need to run the
> maxora??.sql script that creates a couple views under sys. I am sorry that
> I cannot remember the script at this moment. I'll check with some of my
> old comrades and see if they can remember it.
>
> If you're moving to production, you probably have all the columns defined
> and sized. If not, sometimes the column changes do not get registered in
> the maxsyscols table and you'll need to update it.
>
> Otherwise, the system really does quite well once it is running. If I can
> think of anything else I'll re-reply.
>
> --Chris
> [EMAIL PROTECTED]
>
> -----Original Message-----
> From: James Xing [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 22, 2001 6:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Maximo
>
> Hi Group,
>
> I have a Maximo system moving into production, using Oracle 816/Sun
> solaris
> If anyone has experience, from DBA point of view, what I should be care
> of?
> anything to change/check? any particular table?
>
> Thanks
> James
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: James Xing
> 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).
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD><TITLE>RE: Maximo</TITLE>
> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
> <META content="MSHTML 5.50.4522.1800" name=GENERATOR></HEAD>
> <BODY>
> <DIV><SPAN class=004183216-24052001><FONT face=Arial color=#0000ff size=2>Thanks
>
> Chris, </FONT></SPAN></DIV>
> <DIV><SPAN class=004183216-24052001><FONT face=Arial color=#0000ff size=2>Did
> you turn on MTS on your production server? Is that
> recommended?</FONT></SPAN></DIV>
> <DIV><SPAN class=004183216-24052001><FONT face=Arial color=#0000ff size=2>In our
>
> environment, the system was fine on dev server which is not using
> MTS, another DBA who is in charge of production server turned MTS on
> and found the performance is 4 times slower. </FONT> </SPAN></DIV>
> <DIV><SPAN class=004183216-24052001><FONT face=Arial color=#0000ff
> size=2></FONT></SPAN> </DIV>
> <DIV><SPAN class=004183216-24052001><FONT face=Arial color=#0000ff
> size=2>James</FONT></SPAN></DIV>
> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
> size=2>-----Original Message-----<BR><B>From:</B> [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]<B>On Behalf Of </B>Bowes, Chris<BR><B>Sent:</B>
> Wednesday, May 23, 2001 8:28 AM<BR><B>To:</B> Multiple recipients of list
> ORACLE-L<BR><B>Subject:</B> RE: Maximo<BR><BR></FONT></DIV>
> <P><FONT size=2>ON all the maximo installations I have done, the biggest
> problems have been with maxencrypt a table that holds the encrypted key that
> allows everyone in the base. There is a script that will reset this if
> the users cannot get into the system. Make sure that the character
>
> set in the client is set to the same as the base. If users cannot get
> into the base due to bad password and you *know* the user/password are
> correct, then something happened to the maxencrypt and/or the character sets
> are not the same. I am hoping that 4i eliminates that table, but since I
>
> haven't seen it, I don't know if it does.</FONT></P>
> <P><FONT size=2>I don't know about the current version, but when I worked with
>
> it about a year ago, the indexes were terrible. We dropped and created a
>
> number of indexes to improve things. We used cost base optimization
> (oracle v7 at the time) and and a job that analyzed every couple weeks on the
> big tables and every month on the others.</FONT></P>
> <P><FONT size=2>If you have to do an import of the base, you will need to run
> the maxora??.sql script that creates a couple views under sys. I am
> sorry that I cannot remember the script at this moment. I'll check
>
> with some of my old comrades and see if they can remember it.
> </FONT></P>
> <P><FONT size=2>If you're moving to production, you probably have all the
> columns defined and sized. If not, sometimes the column changes do not
> get registered in the maxsyscols table and you'll need to update
> it.</FONT></P>
> <P><FONT size=2>Otherwise, the system really does quite well once it is
> running. If I can think of anything else I'll re-reply.</FONT> </P>
> <P><FONT size=2>--Chris</FONT> <BR><FONT size=2>[EMAIL PROTECTED]</FONT>
> </P><BR>
> <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: James
>
> Xing [<A
> href="mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]
> </A>]</FONT>
> <BR><FONT size=2>Sent: Tuesday, May 22, 2001 6:15 PM</FONT> <BR><FONT
> size=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT
> size=2>Subject: Maximo</FONT> </P><BR>
> <P><FONT size=2>Hi Group,</FONT> </P>
> <P><FONT size=2>I have a Maximo system moving into production, using Oracle
> 816/Sun solaris</FONT> <BR><FONT size=2>If anyone has experience, from DBA
> point of view, what I should be care of?</FONT> <BR><FONT size=2>anything to
> change/check? any particular table?</FONT> </P>
> <P><FONT size=2>Thanks</FONT> <BR><FONT size=2>James</FONT> </P>
> <P><FONT size=2>-- </FONT><BR><FONT size=2>Please see the official ORACLE-L
> FAQ: <A target=_blank
> href="http://www.orafaq.com";>http://www.orafaq.com</A></FONT> <BR><FONT
> size=2>-- </FONT><BR><FONT size=2>Author: James Xing</FONT> <BR><FONT
> size=2> INET: [EMAIL PROTECTED]</FONT> </P>
> <P><FONT size=2>Fat City Network Services -- (858)
> 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=2>San Diego,
> California -- Public Internet access
>
> / Mailing Lists</FONT> <BR><FONT
> size=2>--------------------------------------------------------------------</F
> ONT>
> <BR><FONT size=2>To REMOVE yourself from this mailing list, send an E-Mail
> message</FONT> <BR><FONT size=2>to: [EMAIL PROTECTED] (note EXACT spelling
> of 'ListGuru') and in</FONT> <BR><FONT size=2>the message BODY, include a line
>
> containing: UNSUB ORACLE-L</FONT> <BR><FONT size=2>(or the name of mailing
> list you want to be removed from). You may</FONT> <BR><FONT size=2>also
> send the HELP command for other information (like subscribing).</FONT>
> </P></BLOCKQUOTE></BODY></HTML>
>
> --
> 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).
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED] 10641 Scripps Summit Ct
858-831-2229 San Diego, CA 92131
The future is here. It is just not evenly distributed.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
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).
