3 min read
Check for index owned by sys when table owned by SCOTT select count (*) from dba_indexes where TABLE_NAME in (select...
Month: August 2022
3 min read
3 min read
LOCK A USER: alter user SCOTT account lock; UNLOCK A USER: alter user SCOTT account unlock; CHECK STATUS OF USERS:...
1 min read
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...
1 min read
Error ./ggsci: error while loading shared libraries: libnnz19.so: cannot open shared object file: No such file or directory Solution export...
2 min read
The ORA-15032 error in Oracle is related to issues with the disk groups and ASM. This error indicates that some...
This content is password protected. To view it please enter your password below: Password:
Automatic In-Memory Oracle In-Memory was introduced in version 12c as a way to accelerate performance by storing columnar-compressed database segments...
2 min read
Restrict Mode in which Oracle database allow making connection with special rights such as DBA, SYSDBA to perform the maintenance...
