User Session Scripts
LOCK A USER: UNLOCK A USER: CHECK STATUS OF USERS: CHECK AND GET SID &…
Read moreLOCK A USER: UNLOCK A USER: CHECK STATUS OF USERS: CHECK AND GET SID &…
Read moreDaily Archivelog Generation and size: ARCHIVELOG GENERATION ON DAILY BASIS COUNT
Read moreError ./ggsci: error while loading shared libraries: libnnz19.so: cannot open shared object file: No such…
Read moreThe ORA-15032 error in Oracle is related to issues with the disk groups and ASM.…
Read moreThere is no excerpt because this is a protected post.
Read moreAutomatic In-Memory Oracle In-Memory was introduced in version 12c as a way to accelerate performance…
Read moreRestrict Mode in which Oracle database allow making connection with special rights such as DBA,…
Read moreThe Oracle COALESCE() function accepts a list of arguments and returns the first one that…
Read moreThe view v$sql contains almost of queries which are executed in your Oracle DB. Basicallyyou…
Read moreInstall JDK, PYTHON, SCALA Set path for JDK and Python3 Install & Configure Cassandra Load…
Read moreThere is no excerpt because this is a protected post.
Read moreNode server2 got evicted from the Cluster due to NIC hardware failure oracle@server2 /home/oracle06:19:25 :…
Read moreISSUE: – WHILE RUNNING DATAPATCH VERBOSE WE ARE GETTING FOLLOWING ERROR -> Error at line…
Read moreIssue: PDB went into restricted mode Investigation su - oracle export ORACLE_HOME=/u01/oracle/product/19/db export ORACLE_SID= cp9494…
Read moreIssues: ORA-10567: Redo is inconsistent with data block on standb Error: Solution: 1) At the…
Read moreTo perform the export/import first we need to create a backup directory at the OS…
Read moreThere is no excerpt because this is a protected post.
Read moreBy using Optimized Incremental Backup to disk backup strategy, an up to date copy of…
Read moreOverview of Triggers A database trigger is a compiled stored program unit, written in either…
Read moreDataGuard_Conf_Primary-_with-ASMDownload DataGuard_Conf_Standby_with-ASMDownload
Read moreThe ORA-01000 error indicates that the maximum number of open cursors allowed in the database…
Read moreOracle Database automatically locks a resource on behalf of a transaction to prevent other transactions…
Read moreCharacter Data Types: • CHAR Data Type • VARCHAR2 Data Type • VARCHAR Data Type…
Read moreTo check the total, active, and inactive sessions in an Oracle database, you can query…
Read moreAdding partitions 11g/12c Dropping partition 11g/12c Truncate partitions Merge partition Make a partition ready only…
Read more