Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter view compile

422323Nov 9 2006 — edited Nov 10 2006

Hi,

I compiling a view, and it very very long time (more 4 hours)
I want to know where is it.

I show the v$session_wait, and it take

User I/O db file sequential read 146 WAITED SHORT TIME -1 17383

When i see what it do, in sql_area, i don't see it. No row return.

If i drop this view and i recreate it, there than faster than compile ?

Thanks for your help

Christophe

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2006

Added on Nov 9 2006

#general-database-discussions

4 comments

550 views