3 min read
LOCK A USER: alter user SCOTT account lock; UNLOCK A USER: alter user SCOTT account unlock; CHECK STATUS OF USERS:...
3 min read
1 min read
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...
1 min read
Error ./ggsci: error while loading shared libraries: libnnz19.so: cannot open shared object file: No such file or directory Solution export...
2 min read
The ORA-15032 error in Oracle is related to issues with the disk groups and ASM. This error indicates that some...
This content is password protected. To view it please enter your password below: Password:
Automatic In-Memory Oracle In-Memory was introduced in version 12c as a way to accelerate performance by storing columnar-compressed database segments...
2 min read
Restrict Mode in which Oracle database allow making connection with special rights such as DBA, SYSDBA to perform the maintenance...
1 min read
The Oracle COALESCE() function accepts a list of arguments and returns the first one that evaluates to a non-null value. The following...
1 min read
The view v$sql contains almost of queries which are executed in your Oracle DB. Basicallyyou have privileges to query this...
4 min read
Install JDK, PYTHON, SCALASet path for JDK and Python3Install & Configure CassandraLoad Data In CassandraInstall & Configure SparkSet Path for...
5 min read
This content is password protected. To view it please enter your password below: Password:
3 min read
Node server2 got evicted from the Cluster due to NIC hardware failure oracle@server2 /home/oracle06:19:25 : olsnodes -nserver1 1server2 2server3 3...
3 min read
ISSUE: - WHILE RUNNING DATAPATCH VERBOSE WE ARE GETTING FOLLOWING ERROR -> Error at line 255138: script md/admin/sdordfm.plb- ORA-20002: ORA-06502:...
1 min read
Issue: PDB went into restricted mode Investigation su - oracle export ORACLE_HOME=/u01/oracle/product/19/db export ORACLE_SID= cp9494 $ORACLE_HOME/OPatch/datapatch -verbose If you get...
1 min read
Issues: ORA-10567: Redo is inconsistent with data block on standb Error: Thu May 21 18:24:10 2022 Errors in file /u02/diag/rdbms/prod/prod1/trace/prod1_pr0s_12697.trc...
1 min read
To perform the export/import first we need to create a backup directory at the OS level as well as Database...
3 min read
This content is password protected. To view it please enter your password below: Password:
5 min read
By using Optimized Incremental Backup to disk backup strategy, an up to date copy of the database is always available...
5 min read
Overview of Triggers A database trigger is a compiled stored program unit, written in either PL/SQL or Java, that Oracle...
1 min read
DataGuard_Conf_Primary-_with-ASMDownload DataGuard_Conf_Standby_with-ASMDownload
1 min read
The ORA-01000 error indicates that the maximum number of open cursors allowed in the database session has been exceeded. This...
4 min read
Oracle Database automatically locks a resource on behalf of a transaction to prevent other transactions from doing something that requires...
4 min read
Character Data Types: • CHAR Data Type • VARCHAR2 Data Type • VARCHAR Data Type • NUMBER Data Type CHAR...
2 min read
To check the total, active, and inactive sessions in an Oracle database, you can query the V$SESSION view. Checking Total...
Adding partitions 11g/12c -- SYNTAX : ALTER TABLE <SCHEMA_NAME>.<TABLE_NAME> ADD PARTITION <PARTITION_NAME> VALUES LESS THAN < HIGH_VALUE> TABLESPACE <TABLESPACE_NAME >...
