Posted inOracle

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…
No Comments
Posted inOracle

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…
No Comments
Posted inOracle

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 furthers development on In-Memory by…
No Comments
Posted inOracle

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, remove fragmentation etc. DBA can start…
No Comments
Posted inOracle SQL

COALESCE Function

The Oracle COALESCE() function accepts a list of arguments and returns the first one that evaluates to a non-null value. The following illustrates the syntax of the Oracle COALESCE() function: COALESCE(e1, e2,…
No Comments