What background process refreshes materialized views?

Answer Posted / mathavan

Job Queue processes

Is This Answer Correct ?    31 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1515


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2180


how can you enable flashback feature?

540


What are the steps you will take to improve performance of a poor performing query?

2423


how can you create a user-defined lock?

590






What is the importance of a recovery model? : sql server DBA

557


how does an oracle clusterware manage crs resources?

573


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2112


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1526


What are the different types of upgrades that can be performed in sql server? : sql server DBA

686


what is the use of recording information about current session?

574


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

587


what is asm?

615


If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

566


Why would you use sql agent? : sql server DBA

582