Automatic In-Memory Oracle In-Memory was introduced in version 12c as a way to accelerate performance by storing columnar-compressed database segments...
asrblogger
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 >...
1 min read
PROBLEM : The attempt to create a password file for a 12.2 database failed : $ orapwd file=$ORACLE_HOME/dbs/orapwprod101 password=oracle OPW-00029:...
1 min read
Splunk is a software platform to search, analyse & visualize the machine generated data gathered from different websites, applications, sensors,...
3 min read
Primary Key Constraints A primary key constraint designates a column as the primary key of a table or view. A...
1 min read
This property specifies connection information used to connect to an Oracle database. The Oracle installer generally places a sample tnsnames.ora...
Identify if Grid ASM is Cluster ware or High Availability Solution Check in OS Platform (Oracle /Redhat Linux) if ];then...
