Home 2022 August

Monthly Archives: August 2022

person using macbook pro

Index and Stats Gather Scripts

0
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')...
monitor displaying computer application

User Session Scripts

0
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...
monitor displaying computer application

Daily Archive Generation Script

0
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 daily_summary; ARCHIVELOG GENERATION ON...

Golden Gate Error while loading shared libraries.

0
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...

ORA: 15032 Disk Group Mount Issue.

0
SQL> ALTER DISKGROUP DATA MOUNT;ALTER DISKGROUP DATA MOUNT*ERROR at line 1:ORA-15032: not all alterations performedORA-15017: diskgroup "DATA" cannot be mountedORA-15040: diskgroup is incomplete SOLUTIONS: 1. Check...

Protected: Important parameters for 19c DB Upgrade

0
Configurable parameters: alter system set "_bct_buffer_allocation_max"=<PI 2613> scope=spfile sid='*'; alter system set "_bct_public_dba_buffer_maxsize"=<PI 2613> scope=spfile sid='*'; alter system set "_bct_public_dba_buffer_size"=<PI 2613> scope=spfile sid='*';...

18c New Features

0
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...
railings around hatch on asphalt carriageway

Database in restricted mode.

0
Restrict Mode in which Oracle database allow making connection with special rights such as DBA, SYSDBA to perform the maintenance activity like rebuilding index,...