bulk delete sql_plan baselines

Posted on Tue 22 September 2015 in Databases • 1 min read

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:

vResult Binary_Integer;

for …

Continue reading

Oracle Dashboard with graphite, collectd and pyorastats

Posted on Wed 21 January 2015 in databases • 1 min read

Oracle Dashboard

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 …

Continue reading