if any time you have enabled auto capture sqlplan baselines, you can accumulate more of 3000 baselines in few seconds and if you want to disable auto capture again, you must delete all baselines before.

You can do it with this code:

SET SERVEROUTPUT ON;
DECLARE
vResult Binary_Integer;

BEGIN
for …

Oracle Enterprise Manager console for Oracle database is a very nice tool when you have to view the database performance and take any action on querys, session or any other database activity, but some times you only need to show the performance graphs without login to the EM console.

I …