THE FAILED LOGINS METRIC QUERY IS VERY SLOW BECAUSE OF SYS.AUD$ TABLE SIZE
Failed Logins metric in Oracle Enterprise Manage Cloud Control 13c is too slow.
SYS.AUD$ TABLE IS VERY LARGE
How to clean up SYS.AUD$ table
HOW TO RESCHEDULE THE AUTOMATIC OPTIMIZER STATISTICS COLLECTION JOB
The post provides a number of steps to follow to run the Automatic Optimizer Statistics Collection Job with another time schedule.
HOW TO KNOW WHETHER THE DATABASE COLLECTS STATISTICS REGULARLY
The post provides a number of steps to follow to find out if statistics are collected on a regular basis in the Oracle database.
dx4nqvbtu06bx: THE RECURRING QUERY IN THE 11.2.0.4 TARGET DATABASE IS EXTREMELY SLOW AND USES LOTS OF TEMPORARY SPACE
ORA-1652 error is continuously reported in the alert log file. The error is caused by the query with SQL_ID dx4nqvbtu06bx.