Re:RE: Maximo

From: <dgoulet_at_vicr.com>
Date: Thu, 24 May 2001 11:29:23 -0700
Message-ID: <F001.0030DE2F.20010524112831@fatcity.com>

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><SPAN class=004183216-24052001><FONT face=Arial color=#0000ff size=2>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> </DIV>
<DIV>James</DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left>-----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 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?</FONT> <BR><FONT size=2>anything to 
  change/check? any particular table?</FONT> </P>

Thanks James 
-- 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>&nbsp; INET: james.xing_at_merc-tech-grp.com</FONT> </P>

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

Received on Thu May 24 2001 - 13:29:23 CDT