Re: truncate hangs for a long time

On 9 Jun 2005 09:46:19 -0700, "Tom76" <rbhuma_at_ford.com> 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.

Becasue the object is in use by a different session.

--
Sybrand Bakker, Senior Oracle DBA