Oracle Dataguard queries check
We will check data guard status in SQL Plus in this article in many ways. Check 1: Check for LAG from V$DATAGUARD_STATS View. Check 2: It is also possible to… Read more »
Tag: Oracle 18c
Oracle Database tracing LDAP from CMU to AD
Oracle Database from 18c and above can authenticate and authorize Microsoft Active Directory users with the database directly without intermediate directories or Oracle Enterprise User Security (like Oracle EUS 12c)…. Read more »
Oracle: How to update all sequences
Do you want update all sequences? make it simple! If you ever do data refreshes from production to development or test environments you may run into an issue where your… Read more »
Oracle 19c-Rman Performance of Block change Tracking (BCT)
In this article we are going to see use of Oracle Block Change Tracking concept in 19c database. 19c-Block Change Tracking(BCT) Oracle 10g introduced the Block change tracking (BCT) feature… Read more »
Major change Oracle 19c: No RAC for Standard Edition anymore!
History Since December 2015, Oracle released Oracle Standard Edition 2 (SE2), replacing the previous Standard Edition (SE) and Standard Edition One (SE1) releases. Customers on versions before 12.1.0.2 (running Standard… Read more »
Move column order Oracle 12c/18c/19c
Since the release of Oracle 12c it is now easier to move columns logically. Oracle 12c added support for making columns invisible and that feature can be used to rearrange… Read more »
Oracle 12c/18c/19c: Advanced Network Compression
Starting with Oracle 12c, Oracle supports Advanced Network Compression. Too bad, it is available as part of Advanced Compression option. Oracle compresses the data to be transmitted over network at… Read more »
How to change hostname in ORACLE ASM
Pre-Tasks If you root then execute su – oracle Then > . oraenv Write down: +ASM Before start with the Oracle Restart process you must stop the listener: [oracle@DB ~]# crs_stat… Read more »
JDBC and UCP New Features in Oracle Database 19c and 18c
Oracle Database 19c and 18c JDBC drivers and Java connection pool (UCP) introduce several new features in the performance, high availability, security, and scalability areas. New connection and security features… Read more »
How to purge the Oracle unified audit trail
The unified audit trail, which resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace, makes this information available in a uniform format in the UNIFIED_AUDIT_TRAIL data… Read more »