Thursday, August 22, 2019

How to change location for the redo log files in physical standby database

›
Short background: After a cold restore of the database files from standbyserver1 to standbyserver2, the redo logfiles where incorrectly re...
Wednesday, August 21, 2019

How to create a compressed index using advanced index compression

›
Applicable for Oracle 12.1 and onwards. Basic syntax: CREATE INDEX MYIDX1 ON MYTABLE(COL1, COL2) COMPRESS ADVANCED LOW; The above st...
Tuesday, August 20, 2019

How to add a semicolon (or any other character) at the end of a line using vi

›
Open your text file in vi, and type :%s/$/;/g this will add a semicolon at the end of each line in your file.
Friday, August 9, 2019

How to find the number of executions for a specific SQL ID during a day

›
This query will gather data from DBA_HIST_ACTIVE_SESS_HISTORY for a specific day, and count the number of executions within that day: sel...
Thursday, August 8, 2019

How to find audit information about SELECT statements

›
This article is based on setup in a database running classical auditing in version 18.6.0.0.0, but should be possible to use in older versi...

How to put a mounted standby database in Real-Time Query mode

›
The database is currently mounted as a normal physical standby database: SQL> select open_mode from v$database; OPEN_MODE ---------...
Monday, August 5, 2019

How to work around RMAN-08120: warning: archived log not deleted, not yet applied by standby

›
Problem scenario: * You have a primary database with two standby databases. * One of them is functional, the other one is about to be...