arallelism

[81]Hi All, I have created the below MV with parall......

Subject: Parallelism in MV
Os info: linux
Oracle info: 11.2.0.3
Message: Hi All,
I have created the below MV with parallelism for MV refresh and for MV
creation. But when I issue normal select query against this also using
parallelism to fetch the result(I have found it from the explain plan).
Could you guys please explain the concept behind this??
Normal select Query:
select * from name_MV;
MV DDL:
CREATE MATERIALIZED VIEW name_MV
parallel
NOLOGGING
BUILD IMMEDIATE
REFRESH FAST ON DEMAND
as
select /*+ PARALLEL(8) */ MBR.rowid ECM_MEMBER_ROWID,ADDR.rowid
ECM_MEMBER_ADDRESS_ROWID,ADDR.ECM_ADDRESS_ID_SK,ADDR.START_DATE,ADDR.EN
D_DATE,ADDR.SPECTRUM_RAN_CLEANSE,MBR.MBR_FIRST_NAME,MBR.MBR_LAST_NAME,A
DDR.HP_CC_ID,
ADDR.SPECTRUM_UNABLE_TO_CLEANSE,ADDR.IS_UNDELIVERABLE,ADDR.VERIMOVE_UPD
ATE_DATE from table1 MBR, table2 ADDR where MBR.ECM_RECIPIENT_ID =
ADDR.ECM_RECIPIENT_ID;


Subject: Re: Parallelism in MV
Message: You probably already have a default degree of parallelism
setup on the table.
See this article:
.html
Regards
Tim




Visible links

Hidden links: