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
Daily Archivelog Generation and size: ARCHIVELOG GENERATION ON DAILY BASIS COUNT
Error ./ggsci: error while loading shared libraries: libnnz19.so: cannot open shared object file: No such file or directory Solution export LD_LIBRARY_PATH=$ORACLE_HOME/libldd ggsci ORACLE Set DB Env which is configured for GG Setup For 19c: Trigger below commands for the fix ln -s /u01/oracle/product/19/db/lib/libnnz19.so libnnz19.soln -s /u01/oracle/product/19/db/lib/libclntsh.so.19.1 libclntsh.so.19.1ln -s /u01/oracle/product/19/db/lib/libclntshcore.so.19.1 libclntshcore.so.19.1 ./ggsci For 11g: Trigger below … Read more
The ORA-15032 error in Oracle is related to issues with the disk groups and ASM. This error indicates that some of the requested alterations to the disk group could not be completed. The reasons for this error can vary, but it often involves problems with disk group configurations, permissions, or the state of the ASM … Read more
There is no excerpt because this is a protected post.
Automatic In-Memory Oracle In-Memory was introduced in version 12c as a way to accelerate performance by storing columnar-compressed database segments into memory. In 18c, Oracle furthers development on In-Memory by introducing Automatic In-Memory (AIM). AIM works by building a heat map of the in-memory enabled objects and makes room for those objects that are more … Read more
Restrict Mode in which Oracle database allow making connection with special rights such as DBA, SYSDBA to perform the maintenance activity like rebuilding index, remove fragmentation etc. DBA can start database in restricted mode for planned maintenance activity. So, no other user such as application users will be able to connect with database until they … Read more