In this article, we’ll discuss 5 new features and functionality of Oracle Database 19c that will have you not just ready, but excited for your next Oracle database upgrade. 1.…

Check for index owned by sys when table owned by SCOTT select count (*) from dba_indexes where TABLE_NAME in (select object_name from dba_objects where OBJECT_TYPE in ('TABLE') and owner =…

LOCK A USER: alter user SCOTT account lock; UNLOCK A USER: alter user SCOTT account unlock; CHECK STATUS OF USERS: select username,ACCOUNT_STATUS from dba_users where username like '%SCOTT%'; CHECK AND…

Daily Archivelog Generation and size: with daily_summary as ( select trunc(COMPLETION_TIME,'DD') Day, thread#, round(sum(BLOCKSBLOCK_SIZE)/1048576) MB,count() Archives_Generated from v$archived_log where dest_id=1 group by trunc(COMPLETION_TIME,'DD'),thread# ) select round(sum(mb)/(max(day) - min(day))) AVG_DAILY_MB from…

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…

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…