Re: Pro-active validation/verification of two applications merge

Hi Nenad,

Yes, shared memory, both the cache of the code (Library cache) and that of the data (buffer pool), are in my to-do-list verifications.

Thanks very much for the other consolidation points that weren’t on my to-do list.

Hi Clay,

My client is not using Quest Software. But one of the points that were indeed in my plan is to use RAT (Real Application Testing) to capture workload in application B and replay it in an ISO-A application. Particularly, when integrating applications from B category running lower Oracle version than that used in applications of category A.

Best regards

Mohamed

Le dim. 6 févr. 2022 à 17:30, Noveljic Nenad <nenad.noveljic_at_vontobel.com> a écrit :

> Hi Mohamed,
>
>
>
> In case you want to put both applications in the same database, from the
> performance perspective, I’d also consider the load on the shared pool
> (hard parses).
>
>
>
> But the consolidation isn’t only about the performance. It’s also
> important to consider security, life cycle and RTO/RPO requirements :
>
> - Does one of those application gets high privileges that enable it to
> access or change the data of another application?
> - If both of the applications use public synonyms, there might naming
> conflicts.
> - Life Cycle:
> - Do both applications follow the same Oracle life cycle?
> - Do they have conflicting downtime requirements?
> - Point-in-time-recovery: can you afford to lose data in the
> application B if you need to recover the database because of the
> application A?
> - Duplication for test/dev environments: is there a requirement to
> refresh only data for only one application, while not overwriting the
> other’s test data?
> - What would be the overhead of orchestrating multiple application
> teams for database changes?
>
>
>
> Best regards,
>
>
>
> Nenad
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Mohamed Houri
> *Sent:* Sonntag, 6. Februar 2022 15:16
> *To:* ORACLE-L <oracle-l_at_freelists.org>
> *Subject:* Pro-active validation/verification of two applications merge
>
>
>
> **** E-Mail from outside Vontobel:* Do not click on links or open
> attachments unless you know the content is safe. ***
>
> Hello,
>
>
>
> If you have an application A running Oracle database into which you are
> going to merge another application B running Oracle as well, how would you
> proceed, proactively, to have an idea of whether application A is going to
> merge the volume and activity of B without any problem?
>
> The two applications can be on the same Oracle version as well as on two
> different versions.
>
> I am thinking of the following criteria
>
> · CPU time
>
> · DB time
>
> · IOPS
>
> · Transactions/Redo
>
> Thanks
>
> Mohamed
>
>
>
>
>
>
> --
>
> Houri Mohamed
>
> Oracle DBA-Developer-Performance & Tuning
>
> Visit My - Blog <http://www.hourim.wordpress.com/>
>
> Let's Connect - <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin
> Profile <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*
>
> My Twitter <https://twitter.com/MohamedHouri> - MohamedHouri
> <https://twitter.com/MohamedHouri>
>
> ____________________________________________________
>
> Please consider the environment before printing this e-mail.
>
> Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
>
>
> Important Notice
>
> This message is intended only for the individual named. It may contain
> confidential or privileged information. If you are not the named addressee
> you should in particular not disseminate, distribute, modify or copy this
> e-mail. Please notify the sender immediately by e-mail, if you have
> received this message by mistake and delete it from your system.
> Without prejudice to any contractual agreements between you and us which
> shall prevail in any case, we take it as your authorization to correspond
> with you by e-mail if you send us messages by e-mail. However, we reserve
> the right not to execute orders and instructions transmitted by e-mail at
> any time and without further explanation.
> E-mail transmission may not be secure or error-free as information could
> be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also
> processing of incoming e-mails cannot be guaranteed. All liability of
> Vontobel Holding Ltd. and any of its affiliates (hereinafter collectively
> referred to as "Vontobel Group") for any damages resulting from e-mail use
> is excluded. You are advised that urgent and time sensitive messages should
> not be sent by e-mail and if verification is required please request a
> printed version.
> Please note that all e-mail communications to and from the Vontobel Group
> are subject to electronic storage and review by Vontobel Group. Unless
> stated to the contrary and without prejudice to any contractual agreements
> between you and Vontobel Group which shall prevail in any case,
> e-mail-communication is for informational purposes only and is not intended
> as an offer or solicitation for the purchase or sale of any financial
> instrument or as an official confirmation of any transaction.
> The legal basis for the processing of your personal data is the legitimate
> interest to develop a commercial relationship with you, as well as your
> consent to forward you commercial communications. You can exercise, at any
> time and under the terms established under current regulation, your rights.
> If you prefer not to receive any further communications, please contact
> your client relationship manager if you are a client of Vontobel Group or
> notify the sender. Please note for an exact reference to the affected group
> entity the corporate e-mail signature. For further information about data
> privacy at Vontobel Group please consult www.vontobel.com.
>

-- 

Houri Mohamed

Oracle DBA-Developer-Performance & Tuning

Visit My         - Blog <http://www.hourim.wordpress.com/>

Let's Connect -
<http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin
Profile <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*

My Twitter <https://twitter.com/MohamedHouri>      - MohamedHouri
<https://twitter.com/MohamedHouri>

--
http://www.freelists.org/webpage/oracle-l