Month: February 2023

Problematic Statistics of the Application Objects in your Oracle Database

Posted by on in 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…

Read More Problematic Statistics of the Application Objects in your Oracle Database

Oracle Automated DB Maintenance Tasks

Posted by on in 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';…

Read More Oracle Automated DB Maintenance Tasks

%d bloggers like this: