Hi All,
Any negative impact of truncating following tables before upgrade?
WRI$_OPTSTAT_HISTHEAD_HISTORY;
WRI$_OPTSTAT_HISTGRM_HISTORY;
Do these tables have impact on current stats , performance and SPM?
Thanks
Nitin
On Fri, Dec 29, 2017 at 8:10 AM, Nitin Saxena <ntnsxn7@xxxxxxxxx> wrote:
Hi John,
I did discuss with oracle again and they came with NO answer. In past I
have been running those post upgrade scripts in restrict mode.
Reason for asking is to reduce downtime. So that if it is possible to run
those scripts then we can run in parallel and reduce downtime. I am in
charge for that system.
Testing the way but to mimic prod I wanted to try RAT(Real Application
Testing or Database Replay) which I did in non prod environment. But
running a capture against such a critical system is scary .
Thanks for responding to my questions.
Thanks
Nitin
On Fri, Dec 29, 2017 at 12:14 AM, John Hallas <
john.hallas@xxxxxxxxxxxxxxxxxx> wrote:
If Oracle support say it is OK then take their word over mine.
I am not really sure why you are asking the question anyway. It is your
system - you are in charge.
Testing is the only way to be sure but I appreciate that it would be
difficult to test with application load in a non-prod environment. Which is
one of the reasons why I said NO.
On 27 December 2017 at 16:44, Nitin Saxena <ntnsxn7@xxxxxxxxx> wrote:
The reason I asked Oracle Support says it is fine to run following when
users are making changes.
@?/rdbms/admin/utlu112s.sql
@?/rdbms/admin/catuppst.sql
@?/rdbms/admin/catbundle.sql psu apply
@?/rdbms/admin/utlrp
Please guide or share any experience . This is to reduce the downtime.
Thanks
Nitin
On Wed, Dec 27, 2017 at 5:44 AM, John Hallas <
john.hallas@xxxxxxxxxxxxxxxxxx> wrote:
In a word NO.
The application may or may not continue to work but these scripts
should be run with no users logged in or applications running
John
On 25 December 2017 at 01:35, Nitin Saxena <ntnsxn7@xxxxxxxxx> wrote:
Hello All,
I am battling a upgrade currently. Current production is 11.1.0.7,
which is obsolete and version number can tell that we couldn't upgrade
this
database due to no downtime provided.
Current Challenges-
Compressed objects are not supported with Goldengate classical extract
which is the only extract mode compatible with 11.1 database version.
Compressed Objects are not supported with Logical standby , so logical
transient upgrade is also crossed from list.
Compressed objects are not supported with Streams on 11.1.
We have 26 such table and the biggest one is 1 TB and second biggest
500GB , Rest are tiny ones.
We can't uncompress tables due to exclusive lock on tables and we
don't have space on current box , more over it may be change sql plans on
uncompressed .
Finally we have proposed cold upgrade by shutting down primary for 12
odd minutes.
I have one question :
Can I run following sqls when application is UP and running fine?
@?/rdbms/admin/utlu112s.sql
@?/rdbms/admin/catuppst.sql
@?/rdbms/admin/catbundle.sql psu apply
Thanks
--
Nitin
--
*Technology Manager - Databases and System Management*
Wm Morrison Supermarkets PLC
Tel 0845 611 4589 (Int. 7949 4589)
Mob: 07876 790540
E-mail: john.hallas@xxxxxxxxxxxxxxxxxx
------------------------------
Wm Morrison Supermarkets Plc is registered in England with number
358949. The registered office of the company is situated at Gain Lane,
Bradford, West Yorkshire BD3 7DL. This email and any attachments are
intended for the addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by
replying to the email that you have received in error and then destroy the
email.
If you are not the intended recipient, you must not use, disclose, copy
or rely on the email or its attachments in any way.
This email does not constitute a contract in writing for the purposes
of the Law of Property (Miscellaneous Provisions) Act 1989.
Our Standard Terms and Conditions of Purchase, as may be amended from
time to time, apply to any contract that we enter into. The current version
of our Standard Terms and Conditions of Purchase is available at:
http://www.morrisons.co.uk/gscop
Although we have taken steps to ensure the email and its attachments
are virus-free, we cannot guarantee this or accept any responsibility, and
it is the responsibility of recipients to carry out their own virus checks.
------------------------------
--
Cheers
Nitin
--
*Technology Manager - Databases and System Management*
Wm Morrison Supermarkets PLC
Tel 0845 611 4589 (Int. 7949 4589)
Mob: 07876 790540
E-mail: john.hallas@xxxxxxxxxxxxxxxxxx
------------------------------
Wm Morrison Supermarkets Plc is registered in England with number 358949.
The registered office of the company is situated at Gain Lane, Bradford,
West Yorkshire BD3 7DL. This email and any attachments are intended for the
addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by
replying to the email that you have received in error and then destroy the
email.
If you are not the intended recipient, you must not use, disclose, copy
or rely on the email or its attachments in any way.
This email does not constitute a contract in writing for the purposes of
the Law of Property (Miscellaneous Provisions) Act 1989.
Our Standard Terms and Conditions of Purchase, as may be amended from
time to time, apply to any contract that we enter into. The current version
of our Standard Terms and Conditions of Purchase is available at:
http://www.morrisons.co.uk/gscop
Although we have taken steps to ensure the email and its attachments are
virus-free, we cannot guarantee this or accept any responsibility, and it
is the responsibility of recipients to carry out their own virus checks.
------------------------------
--
Cheers
Nitin
