SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Compare database configuration from two different environments

muttleychessSep 1 2020 — edited Sep 18 2020

I have two different environments, a test environment (HML) and a production environment (PRD),

in the HML environment a given routine is taking 2 hours to finish,

while the same routine and with the same data takes 15 minutes,

I would like to know if you have some way to compare the physical part using query, example to know CPUs ... ETC,

everything that can change the performance, because the objects of the two environments are apparently equals

I don't know which version of the bank they are using too

TIA

This post has been answered by Paulzip on Sep 4 2020

Jump to Answer

Added on Sep 1 2020

21 comments

1,554 views