EXTREME FAILED LOGINS ATTEMPTS CAUSE HIGH LIBRARY CACHE LOCK WAIT TIME
Enormous failed logins attempts causes high concurrency wait class in a database
HOW TO CREATE SIMPLE JAVA PROGRAM FOR QUERING AN ORACLE DATABASE
Simple Java Program to connect Oracle database by using Oracle JDBC thin driver
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 GRANT THE SELECT PRIVILEGE ON A VIEW TO THIRD PARTY USERS
Granting SELECT privilege on a view to other users when underlying objects of such a view do not belong to the owner of the view.
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.
USER WITH "SELECT ANY TABLE" PRIVILEGE GETS "ORA-00942: TABLE OR VIEW DOES NOT EXIST"
A user with SELECT ANY TABLE privilege gets ORA-00942: TABLE OR VIEW DOES NOT EXIST when quering any table.
HOW TO FIND ALL SESSIONS HOLDING A TABLE LOCK
Query to check table lock in Oracle database.
ORA-02049: TIMEOUT: DISTRIBUTED TRANSACTION WAITING FOR LOCK
oerr ora 02049 - The number of seconds specified in the distributed_lock_timeout initialization parameter were exceeded while waiting for a lock or for a begin transaction hash collision to end.