Re: Help wanted - Hangs up when creating index

Hi Jonathan,

Thank you for your help. But how to release the lock. I found sometimes it is waiting for library cache lock and sometimes it is waiting for latch free event. I don't know how to release them.

Sometimes somebody simply interupted the oracle session left a unix process there which is still holding the locks and resources. How do you handle such problems?

Any comments from other people?

Regards
Lane

Jonathan Lewis wrote:

> Have a look in the v$system_event view for
> library cache locks against the table.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Lane Shen wrote in message <38632512.18EC2F70_at_direct.ca>...
> >We are using Oracle8i 8.1.5 on HPUX with partition option. We have a SQL
> >
> >statement to create table using partition method to store the primary
> >key. After we created the new database, everyting was working fine
> >including the statement mentioned above. After the database was running
> >for some days, the statement could not work any more. It kept running
> >forever. We seperated the statement to two parts. One is to create table
> >
> >and one is to alter table adding primary key constraint. The table was
> >created but the other one to add constraint hanged there. Then we don't
> >add this constraint, instead we created unique index on it. It still
> >hanged. We tried to create non-unique index. It was the same thing.
> >
> >Any body encountered such problem before? Any body can help?
> >
> >Thanks in advance
> >Lane
> >
> >
> >
Received on Fri Dec 24 1999 - 20:57:24 CST