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 12c
A LOT OF FALSE ‘Global Cache Blocks Lost’ ALERTS REPORTED BY ENTERPRISE MANAGER CLOUD CONTROL 13C RELEASE 4
SYMPTOMS The alert message looks like EM Event: Warning:TEST_PDB1 – Total global cache block lost is 15. Host=db-test01.local Target type=Database Instance Target name=TEST_PDB1 Categories=Error Message=Total global cache block lost is… 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 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 »
Automatically and Manual Purging Alert Log and Trace files with ADRCI
Automatically purging Sometimes we are facing with space related issues due to the huge number of trace file generation. Automatic purging can help us in this situations if set short… Read more »
ALTER TABLE … MOVE PARTITION ONLINE license trap
The new features of Oracle 12c I had looked closer at possibility to move partitions online. You can move the partition while it is being accessed by DMLs and queries,… Read more »
SQL Plan Management and Auto Capture
SQL Plan Management (SPM) is an Oracle database feature that allows you to establish a set of SQL execution plans that will be used even if the database is subject… Read more »
Why should you use the most recent version of OPatch?
Opatch. A tool nobody really loves but everybody has to use (at least those of you who patch or aren’t in our cloud deployment). Opatch gets distributed via MOS. And… Read more »