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