Monthly Archives: August 2022
Protected: 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='*';...
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,...