Guarantee a select will execute on a standby only within allowable lag
–set the SLA? –Use a logon trigger to set the maximum delay –whenever a user logs into the standby — […]
–set the SLA? –Use a logon trigger to set the maximum delay –whenever a user logs into the standby — […]
The following view shows Data Guard standby lag via a histogram updated every second since the instance was last booted.
I was patching an Oracle ASM grid oracle db standalone infrastructure and ran across the error with opatchauto “Patch Location
Overview Here is the process I used to apply the Oracle 2016 PSU 22191676 to Grid / Oracle Stand Alone
Purpose How to setup a device on Oracle Virtual Box – and use that device for a Oracle stand alone
Want to know for certain if your dataguard standby is in REAL TIME APPLY mode? Here is how – execute
To disable the AUTO TASK space advisor, and sql tuning advisor, and disable weekday maintenance window for auto optimizer stats
When connect to the root container CDB$ROOT: select c.name container, u.username username from v$containers c, cdb_users u where c.con_id=u.con_id order
was attempting to implement the standalone version of Oracle Apex Listener 2 – and getting blank pages. Prior to this
By default the Oracle SQLNet Listener is updated once a minute with newly started instances, PMON does this. If you