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 my 2019 online training classes here!
Practical Linux Performance & Application Troubleshooting training (new),
Advanced Oracle SQL Tuning training,
Advanced Oracle Troubleshooting training.
In addition to the online classes, all attendees will receive personal downloadable video recordings too!