I think I've seen this when the table is very highly fragmented. Do a select count(*) from sys.uet$ (or maybe its sys.fet$). If the number is rapdily going down, then the hang is probably Oracle cleaning up the deallocated extents. If you did a trunacte with the REUSE clause it would probably finish immediately.


-----Original Message-----
From: Fabio Aneas [mailto:[Email Address Removed]
Sent: Thursday, January 31, 2002 8:51 AM
To: LazyDBA.com Discussion
Subject: 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 documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page