Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Prasun.

Asked: March 30, 2017 - 3:50 am UTC

Last updated: March 31, 2017 - 4:32 am UTC

Version: 11.1.2

Viewed 1000+ times

You Asked

We are migrating from 11g to 12c.

We need to the object coverage (Oracle dependencies), as we external applications (mainly Java applications) calling our Oracle package, function procedures.

So what is best way to find calling hierarchy which help our QA team to validate the oracle objects after migration.

We are planning to use oracle hierarchy profiler to get the details. (as dbms_hprof will provide parent child information for any oracle procedure, packages etc).

Please let me know is it correct way, or use views like ALL_DEPENDENCIES and let me know if any way.

Regards,
Prasun

and Connor said...

Not sure what you mean by "We need to the object coverage"

The best way to validate an upgrade would be:

- Run your application before upgrade. Collect relevant metrics
- Upgrade your test system
- Run your application before upgrade. Collect relevant metrics
- Compare before and after for correctness and performance


Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

And

Mr P. Edant, March 30, 2017 - 1:18 pm UTC

Might be worth running the application and colecting metrics in test AFTER the upgrade as well and comparing results.

Just a thought!! :)
Connor McDonald
March 31, 2017 - 4:32 am UTC

LOL - cut and paste fail on my part :-)

- Run your application before upgrade. Collect relevant metrics
- Upgrade your test system
- Run your application AFTER upgrade. Collect relevant metrics
- Compare before and after for correctness and performance

A reader, March 30, 2017 - 3:15 pm UTC

I think the second one "- Run your application before upgrade. Collect relevant metrics" - it's "after upgrade" actually
Connor McDonald
March 31, 2017 - 4:32 am UTC

:-)
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library