Whenever there is a suspicion on system hang, please do
hanganalyze/system state dump. Cycles/chains/blocking sessions will
help in determining the cause of the hang.
Tom76 wrote:
> 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 Mon Jun 13 2005 - 06:09:31 CDT
