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…
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…
HOW TO AUTO-PURGE STATSPACK SNAPSHOTS
You must clear statspack snapshots regularly to keep under control the growth of a tablespace occupation allocated…
HOW TO CHECK MEMORY USAGE PER PROCESS IN LINUX
A bash script, reporting how much memory a process is using at the time.
GENERATING MULTIPLE STATSPACK REPORTS QUICKLY
A bash script for generating multiple STATSPACK reports.
GENERATING MULTIPLE AWR REPORTS QUICKLY
A bash script for generating multiple AWR reports.
HOW TO MATCH OS PROCESS WITH ORACLE SESSION
What is a particular OS Oracle process (PID) executing in an Oracle database?