Ed Chen Logic

Converting Standby Database to Snapshot (4/4) - With Flashback Tablespace Disabled

by Ed Chen
March 26, 2013December 12, 2022

Converting Standby Database to Snapshot (3/4) - With Flashback Database DisabledSome standby conversions could be more complicated than usual, especially converting back to physical standby.… Read More »

Converting Standby Database to Snapshot (3/4) - With Flashback Database Disabled

by Ed Chen
March 25, 2013August 5, 2020

Converting Standby Database to Snapshot (2/4) - Convert ManuallyIt would be better to make sure flashback database is enabled before conversion, but it seems not… Read More »

Converting Standby Database to Snapshot (2/4) - Convert Manually

by Ed Chen
March 24, 2013January 20, 2021

Converting Standby Database to Snapshot (1/4) - Convert by Broker We have demonstrated how to convert a physical standby database to a snapshot standby by… Read More »

Converting Standby Database to Snapshot (1/4) - Convert by Broker

by Ed Chen
March 23, 2013August 5, 2020

Converting Standby Database to Snapshot (0/4) - An Overview Before you convert a physical standby database, you must make sure FRA is configured properly. [oracle@standby01… Read More »

Converting Standby Database to Snapshot (0/4) - An Overview

by Ed Chen
March 22, 2013August 5, 2020

The feature of standby conversion can change a standby database into a fully updatable test one. For a more smooth operation, we usually make flashback enabled… Read More »

How to Use Data Pump Network Mode

by Ed Chen
March 11, 2013March 20, 2023

Data pump has a very nice feature since 10g, which can make data imported directly from source to target via network connection without any intermediate… Read More »

How to Comment Out a Huge Block of Shell Code

by Ed Chen
March 10, 2013November 22, 2022

You might want to comment out some lines of shell script code during debug-time, you can just add a pound sign # to the head… Read More »

How Oracle Kill Blocking Sessions

by Ed Chen
March 9, 2013February 13, 2023

After the blocking sessions are identified, DBA should notify the session owners and leave them a chance to exit sessions gracefully by themselves. If things… Read More »

How to Identify Blocking Sessions

by Ed Chen
March 8, 2013April 15, 2023

Here I introduce a sample of PL/SQL code to monitor the blocking sessions every N minutes and output in a formatted report. First of all,… Read More »

How to Kill Sessions Running on Shared Server Processes

by Ed Chen
March 7, 2013February 13, 2023

Kill Dedicated Server Sessions kill session immediate statement does not guarantee that the specified session will be killed immediate, especially when the session is active… Read More »

JavaScript is not enabled. Please enable it and reload the page.