Randolf Geist has written a good article about systematic troubleshooting of a PL/SQL memory allocation & CPU utilization problem – and he has used some of my tools too!
NB! Check out 2020 online training classes here!
Advanced Oracle Troubleshooting training,
Advanced Oracle SQL Tuning training,
Practical Linux Performance & Application Troubleshooting training.
In addition to the online classes, all attendees will receive personal downloadable video recordings too!