Re: Inserts waiting on gc buffer busy on Node2. Waiting for Undo block of Node1

Ajay

1. What is the state column value in v$session_wait when the sessions were waiting?
2. Were you able to turn on trace in any session? Would you please share few lines showing waiting sessions.
3. You could also dump the block and see what kind of undo is in that block.. alter system dump datafile file_id block block_id;

-- 
Riyaj Shamsudeen
The Pythian Group www.pythian.com
orainternals.wordpress.com

On Mon, Jun 2, 2008 at 10:12 AM, Ajay Thotangare <ajayoraclel_at_yahoo.com>
wrote:



> I am deleting from a table "TABLEA" from node1. At the same time also

> inserting records in same table from Node2. Session on Node2 are waiting on

> "gc buffer busy" wait. P1 value points to Undo of Node1.

> TABLEA is a huge table and delete takes long time. Its not a partitioned

> table but has about 28 million records. delete operation will delete about

> 200K records.I am committing at the end of delete operation.

> Any idea why my inserts are waiting on Undo block of Node1 ? moreover all

> sessions waits on same block. All sessions points to same undo file and same

> undo block.

> what can be done in this case to resolve the problem?

> Any help appreciated

>

>


--
http://www.freelists.org/webpage/oracle-l