truncate hangs for a long time

From: Tom76 <rbhuma_at_ford.com>
Date: 9 Jun 2005 09:46:19 -0700
Message-ID: <1118335579.428434.280500@g47g2000cwa.googlegroups.com>

DB version:9.2.0.4
OS: Linux

i am truncating a table but it hangs for a long time. sid=40(for example)
for sid=40, in the waits view, "row cache lock" is the wait. in the locked object view, this sid=40 is locking two objects, one I am truncating and the other is sys.MLOG$.
i queried the row cache lock and the parameter for the cache_id is "dc_object_ids".
select also hangs. i estimate more than million rows in the table.

can somebody tell what is going on here and why is the truncate take long time. thanks in advance. Received on Thu Jun 09 2005 - 11:46:19 CDT