Index and Stats Gather Scripts
Check for index owned by sys when table owned by SCOTT –View problem indexes, verify…
Read moreasrblogger
User Session Scripts
LOCK A USER: UNLOCK A USER: CHECK STATUS OF USERS: CHECK AND GET SID &…
Read moreDaily Archive Generation Script
Daily Archivelog Generation and size: ARCHIVELOG GENERATION ON DAILY BASIS COUNT
Read moreGolden Gate Error while loading shared libraries.
Error ./ggsci: error while loading shared libraries: libnnz19.so: cannot open shared object file: No such…
Read moreORA-15032: not all alterations performed in Oracle ASM !!
The ORA-15032 error in Oracle is related to issues with the disk groups and ASM.…
Read moreProtected: Important parameters for 19c DB Upgrade
There is no excerpt because this is a protected post.
Read more18c New Features
Automatic In-Memory Oracle In-Memory was introduced in version 12c as a way to accelerate performance…
Read moreDatabase in restricted mode.
Restrict Mode in which Oracle database allow making connection with special rights such as DBA,…
Read moreCOALESCE Function
The Oracle COALESCE() function accepts a list of arguments and returns the first one that…
Read moreCheck history of Executed queries
The view v$sql contains almost of queries which are executed in your Oracle DB. Basicallyyou…
Read moreCASSANDRA-SPARK INSTALLATION AND CONNECTION
Install JDK, PYTHON, SCALA Set path for JDK and Python3 Install & Configure Cassandra Load…
Read moreProtected: Invalid Sys object after applying PSU patch
There is no excerpt because this is a protected post.
Read moreCluster failed to start due to ASM password file Issue (ORA-01017: invalid username/password)
Node server2 got evicted from the Cluster due to NIC hardware failure oracle@server2 /home/oracle06:19:25 :…
Read moreWHILE RUNNING DATAPATCH VERBOSE WE ARE GETTING FOLLOWING ERROR ORA-20002, ORA-04088, ORA-00604, ORA-20002
ISSUE: – WHILE RUNNING DATAPATCH VERBOSE WE ARE GETTING FOLLOWING ERROR -> Error at line…
Read morePDB went in restricted mode in Oracle 19c
Issue: PDB went into restricted mode Investigation su - oracle export ORACLE_HOME=/u01/oracle/product/19/db export ORACLE_SID= cp9494…
Read moreORA-10567: Redo is inconsistent with data block on standby !!
Issues: ORA-10567: Redo is inconsistent with data block on standb Error: Solution: 1) At the…
Read moreExport from 11g and import to 19c
To perform the export/import first we need to create a backup directory at the OS…
Read moreProtected: Fixing a Corrupt Database Home.
There is no excerpt because this is a protected post.
Read moreRecovery using datafile copy – SWITCH DATAFILE TO COPY
By using Optimized Incremental Backup to disk backup strategy, an up to date copy of…
Read moreTrigger – Oracle Database Objects
Overview of Triggers A database trigger is a compiled stored program unit, written in either…
Read morePhysical Standby Configuration with ASM.
DataGuard_Conf_Primary-_with-ASMDownload DataGuard_Conf_Standby_with-ASMDownload
Read moreORA-01000: Maximum Open Cursors Exceeded
The ORA-01000 error indicates that the maximum number of open cursors allowed in the database…
Read moreOracle Database Locking Mechanism – 3
Oracle Database automatically locks a resource on behalf of a transaction to prevent other transactions…
Read moreDetailed explanation of Built-In Data Type in SQL
Character Data Types: • CHAR Data Type • VARCHAR2 Data Type • VARCHAR Data Type…
Read moreHow to check Total, Active and Inactive sessions in Oracle database ?
To check the total, active, and inactive sessions in an Oracle database, you can query…
Read more