August 2022

3 min read

Oracle

Index and Stats Gather Scripts

asrblogger

Check for index owned by sys when table owned by SCOTT select count (*) from dba_indexes where TABLE_NAME in (select...

3 min read

Oracle

User Session Scripts

asrblogger

LOCK A USER: alter user SCOTT account lock; UNLOCK A USER: alter user SCOTT account unlock; CHECK STATUS OF USERS:...

1 min read

Oracle

Daily Archive Generation Script

asrblogger

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

Oracle

Golden Gate Error while loading shared libraries.

asrblogger

Error ./ggsci: error while loading shared libraries: libnnz19.so: cannot open shared object file: No such file or directory Solution export...

2 min read

ORA-15032: not all alterations performed in Oracle ASM !!

asrblogger

The ORA-15032 error in Oracle is related to issues with the disk groups and ASM. This error indicates that some...

5 min read

Oracle

Protected: Important parameters for 19c DB Upgrade

asrblogger

This content is password protected. To view it please enter your password below: Password:

2 min read

Oracle

18c New Features

asrblogger

Automatic In-Memory Oracle In-Memory was introduced in version 12c as a way to accelerate performance by storing columnar-compressed database segments...