real time performance issues
Posted by:
mmmm mmmm
Date: March 28, 2020 02:26AM
1) What steps do you use to resolve a real time performance issue? for example a stored procedure is running slow while consuming a lot of CPU, and memory.
2) How do you resolve a performance issue where a new stored procedure (A) is running slow and if adding a new B-TREE index resolves the issue but it causes store procedure (B) to slow down? It's like the chicken n egg problem.
What tools, utilities or programs do you use to troubleshoot and resolve these 2 issues? if you could provide examples, it would be the best.
Subject
Written By
Posted
real time performance issues
March 28, 2020 02:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.