Title: RE: Maximo
Thanks
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 turnedMTS on
and found the performance is 4 times slower
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
:[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
Title: RE: Maximo
Hi
James,
No we didn't use MTS.
We were on an NT server and it seemed to do a lot better when we analyzed
everything using compute stats and analyzing all indexed columns and setting
up histograms for it. Also check all the indexes and their columns, we
Title: 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
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