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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

497 views