Index and Stats Gather Scripts
Check for index owned by sys when table owned by SCOTT –View problem indexes, verify…
Read moreAugust 2022
User Session Scripts
LOCK A USER: UNLOCK A USER: CHECK STATUS OF USERS: CHECK AND GET SID &…
Read moreDaily Archive Generation Script
Daily Archivelog Generation and size: ARCHIVELOG GENERATION ON DAILY BASIS COUNT
Read moreGolden Gate Error while loading shared libraries.
Error ./ggsci: error while loading shared libraries: libnnz19.so: cannot open shared object file: No such…
Read moreORA-15032: not all alterations performed in Oracle ASM !!
The ORA-15032 error in Oracle is related to issues with the disk groups and ASM.…
Read moreProtected: Important parameters for 19c DB Upgrade
There is no excerpt because this is a protected post.
Read more18c New Features
Automatic In-Memory Oracle In-Memory was introduced in version 12c as a way to accelerate performance…
Read moreDatabase in restricted mode.
Restrict Mode in which Oracle database allow making connection with special rights such as DBA,…
Read more