Help: truncate table waiting in "free buffer waits" event

Help: truncate table waiting in "free buffer waits" event

 

  

Hi, folks!
I am trying to truncate many tables, however it hangs while truncating one of
them.

It keeps waiting in the "free buffer waits" event. I've issued a select from
v$latchholder and no rows were selected.

Can you help me pointing where else I can dig to understand what is going on?

TIA
Fabio


_______________________________________________________________________________________________
Yahoo! GeoCities
Tenha seu lugar na Web. Construa hoje mesmo sua home page no Yahoo! GeoCities. É fácil e grátis!
http://br.geocities.yahoo.com/
Oracle LazyDBA home page