Monthly Archives: August 2022
Index and Stats Gather Scripts
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')...
User Session Scripts
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 Archive Generation Script
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.
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.
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
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
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...
Database in restricted mode.
Restrict Mode in which Oracle database allow making connection with special rights such as DBA, SYSDBA to perform the maintenance activity like rebuilding index,...