OraFAQ Forum: Replication » Materialized view

Home » Server Options » Replication » Materialized view - background process

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Materialized view - background process [message #483083]

Thu, 18 November 2010 04:43

satishpuglia
Messages: 2
Registered: November 2009
Location: delhi

Junior Member

Hi,
which background process use by Oracle server for materialized view ?

thank you

[EDITED by LF: fixed typos; the originals were "meterlized"]

[Updated on: Tue, 11 January 2011 15:52] by Moderator

Report message to a moderator

Re: meterlized view [message #483085 is a reply to message #483083]

Thu, 18 November 2010 05:12

Michel Cadot
Messages: 67650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I assume you mean to refresh the view, it depends.
If you do it calling dbms_snapshot, dbms_refresh... package, it is your server process (the one attached to your session).
If it is a job, it one of Jxxx processes you can see on your server.

Regards
Michel

[Updated on: Thu, 18 November 2010 05:13]

Report message to a moderator

Re: meterlized view [message #488827 is a reply to message #483083]

Tue, 11 January 2011 06:29

dataentryoutsourcing
Messages: 3
Registered: December 2010
Location: GUJARAT

Junior Member

Actually, oracle creates a set of background processes for each instance and Job Queue Processes are used to refresh the materialized views.

Report message to a moderator

Previous Topic:	Syncronize database server data
Next Topic:	Replication of table for DML from source to destination DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 23 18:04:31 CST 2021