Day: August 28, 2022

Check for index owned by sys when table owned by SCOTT –View problem indexes, verify table_owner is SCOTT (if INDEX_OWNER and TABLE_OWNER are sys, then you have 2 tables with 2 owners, but same table name, see steps below) INDEX_OWNER INDEX_NAME TABLE_NAME TABLE_OWNER –get the columns for the index and its tablespace INDEX_NAME COLUMN_NAME TABLESPACE_NAME … Read more

LOCK A USER: UNLOCK A USER: CHECK STATUS OF USERS: CHECK AND GET SID & SERIAL# ID OF SPECIFIC INACTIVE AND ACTIVE SESSION CHECK AND KILL ALL SYS USER RUNNING WITH LIBRARY CACHE MUTEX WAIT EVENTS TO ESTABLISH NEW CONNECTION ERROR: MAX PROCESS EXCEED CHECK COUNT OF SPECIFIC USER USER ACTIVE FOR MORE THAT 45 … Read more