February 2023 – Radu Pârvu's Site

Problematic Statistics of the Application Objects in your Oracle Database

Posted by rparvuon 11/02/202315/02/2023in 19c, db, Oracle, SQL DeveloperLeave a comment

One of the often asked questions is to find out the status of the statistics of the application owned schemas. In this article, I will list the SQL code that I used for this purpose. As well, I will publish…

Oracle Automated DB Maintenance Tasks

Posted by rparvuon 01/02/202302/02/2023in 19c, db, Oracle, techLeave a comment

This is a short article on how to manage the automated Oracle database maintenance tasks. Make sure the needed rights are in place by running the check: SELECT grantee, privilegeFROM dba_tab_privsWHERE owner = 'SYS'AND table_name = 'DBMS_AUTO_TASK_ADMIN'AND privilege = 'EXECUTE';…