Re: Maximo

From: Charlie Mengler <charliem_at_mwh.com>
Date: Thu, 24 May 2001 12:17:38 -0700
Message-ID: <F001.0030E0E2.20010524121815@fatcity.com>

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

dgoulet_at_vicr.com 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" <james.xing_at_merc-tech-grp.com>
> 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: root_at_fatcity.com [mailto:root_at_fatcity.com]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
> Chris.Bowes_at_Kosa.com
>
> -----Original Message-----
> From: James Xing [mailto:james.xing_at_merc-tech-grp.com]
> 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: james.xing_at_merc-tech-grp.com
>
> 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> <!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>Thanks
>
> Chris, </DIV>
> <DIV>Did
> you turn on MTS on your production server? Is that
> recommended?</DIV>
> <DIV>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.  </DIV>
> <DIV> size=2> </DIV>
> <DIV> size=2>James</DIV>
> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
> <DIV class=OutlookMessageHeader dir=ltr align=left> size=2>-----Original Message----- From: root_at_fatcity.com
> [mailto:root_at_fatcity.com]On Behalf Of Bowes, Chris Sent:
> Wednesday, May 23, 2001 8:28 AM To: Multiple recipients of list
> ORACLE-L Subject: RE: Maximo </DIV>
> 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 Chris.Bowes_at_Kosa.com
> 
> -----Original Message----- From: James
>
> Xing [<A
> href="mailto:james.xing_at_merc-tech-grp.com">mailto:james.xing_at_merc-tech-grp.com
> </A>]
> Sent: Tuesday, May 22, 2001 6:15 PM <FONT
> size=2>To: Multiple recipients of list ORACLE-L <FONT
> size=2>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: <A target=_blank
> href="http://www.orafaq.com">http://www.orafaq.com</A> <FONT
> size=2>-- Author: James Xing <FONT
> size=2>  INET: james.xing_at_merc-tech-grp.com 
> Fat City Network Services    -- (858)
> 538-5051  FAX: (858) 538-5051 San Diego,
> California        -- Public Internet access
>
> / Mailing Lists <FONT
> size=2>--------------------------------------------------------------------</F
> ONT>
> To REMOVE yourself from this mailing list, send an E-Mail
> message to: ListGuru_at_fatcity.com (note EXACT spelling
> of 'ListGuru') and in the message BODY, include a line
>
> containing: UNSUB ORACLE-L (or the name of mailing
> list you want to be removed from).  You may also
> send the HELP command for other information (like subscribing).
> </BLOCKQUOTE></BODY></HTML>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler               Maintenance Warehouse  
charliem_at_mwh.com              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: charliem_at_mwh.com

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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu May 24 2001 - 14:17:38 CDT