Skip to Main Content
Forums

SQL & PL/SQL

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!

Question on Mat View refresh

Johnny BMar 30 2020 — edited Apr 20 2020

Hi all,

Have a materialized view defined as refresh fast on commit:

CREATE MATERIALIZED VIEW mat_vw_name REFRESH FAST ON COMMIT WITH ROWID AS

Importing data to the table that is part of the mat view using SQL Loader. The query is taking a long time to process.

Do I need to perform anything after the bulk import is done? Is the mat view running after the bulk import?

Is there a way to see if any process is running in the background?

Thanks in advance.

Johnny

using: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
This post has been answered by Johnny B on Apr 20 2020
Jump to Answer
Comments
Post Details
Added on Mar 30 2020
2 comments
147 views