How to Kill Session in Oracle 19c

As an Oracle DBA, there may be times when you need to terminate a session. For example, an application developer might accidentally run a resource-intensive query multiple times or face network issues during a large update operation. In such scenarios, they might ask the DBA to kill the session to avoid further impact on the … Read more

ORA-16855: Transport Lag Has Exceeded Specified Threshold in Data Guard !!

The ORA-16855 error indicates that the transport lag (the delay in sending redo data from the primary to the standby database) has exceeded the specified threshold. Cause: The current apply lag has exceeded the value specified by the ApplyLagThreshold configurable property. This can be due to either a significant transport lag or poor performance of … Read more