What background process refreshes materialized views?

What background process refreshes materialized views?
by

1 Answer

Answer :

The Job Queue Processes.
by

Related questions

Explain materialized views and how they are used.

Description : Explain materialized views and how they are used.

Last Answer : Materialized views are objects that are reduced sets of information that have been summarized, grouped, or aggregated from base tables. They are typically used in data warehouse or decision support systems.

What is the difference between a view and a materialized view?

Description : What is the difference between a view and a materialized view?

Last Answer : A view is a select that is executed each time an user accesses to it. A materialized view stores the result of this query in memory for faster access purposes.

When a user process fails, what background process cleans up after it?

Description : When a user process fails, what background process cleans up after it?

Last Answer : PMON

When a user process fails, what Oracle background process will clean after it?

Description : When a user process fails, what Oracle background process will clean after it?

Last Answer : PMON

What column differentiates the V$ views to the GV$ views and how?

Description : What column differentiates the V$ views to the GV$ views and how?

Last Answer : The INST_ID column which indicates the instance in a RAC environment the information came from.

What are snap shots and views

Description : What are snap shots and views

Last Answer : Snapshots are mirror or replicas of tables. Views are built using the columns from one or more tables. The Single Table View can be updated but the view with multi table cannot be updated

What are the types of canvas-views?

Description : What are the types of canvas-views?

Last Answer : Content View, Stacked View.

List the built-in routines for the controlling canvas views during run-time?

Description : List the built-in routines for the controlling canvas views during run-time?

Last Answer : Find_canvas Get-Canvas_property Get_view_property Hide_View Replace_content_view Scroll_view Set_canvas_property Set_view_property Show_view Alert

What is relation between the window and canvas views?

Description : What is relation between the window and canvas views?

Last Answer : Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc.,) and boilerplate objects (boxes, lines, images etc.,) that operators interact with us they run your form . Each canvas views displayed in a window.

Explain about stacked canvas views?

Description : Explain about stacked canvas views?

Last Answer : Stacked canvas view is displayed in a window on top of, or "stacked" on the content canvas view assigned to that same window. Stacked canvas views obscure some part of the underlying content canvas view, and or often shown and hidden programmatically.

Explain about horizontal, Vertical tool bar canvas views?

Description : Explain about horizontal, Vertical tool bar canvas views?

Last Answer : Tool bar canvas views are used to create tool bars for individual windows. Horizontal tool bars are display at the top of a window, just under its menu bar. Vertical Tool bars are displayed along the left side of a window

What are the two types of views available in the object navigator(specific to report 2.5)?

Description : What are the two types of views available in the object navigator(specific to report 2.5)?

Last Answer : View by structure and view by type .

Which of the two views should objects according to possession?

Description : Which of the two views should objects according to possession?

Last Answer : view by structure.

How does one get the view definition of fixed views/tables?

Description : How does one get the view definition of fixed views/tables?

Last Answer : Query v$fixed_view_definition. Example: SELECT * FROM v$fixed_view_definition WHERE view_name='V$SESSION';

What are the advantages of views?

Description : What are the advantages of views?

Last Answer : Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table. - Hide data complexity. - Simplify commands for the user. - Present the data in a different perspective from that of the base table. - Store complex queries.

What is the difference between normal views and RAC views?

Description : What is the difference between normal views and RAC views?

Last Answer : RAC views has the prefix ‘G’. For example, GV$SESSION instead of V$SESSION

Name two specific RAC background processes

Description : Name two specific RAC background processes

Last Answer : RAC processes are: LMON, LMDx, LMSn, LKCx and DIAG.

I was just listening to the famous Dr. Martin Luther King speech. Would you say his dream has been completely materialized since the day he made that wonderful speech?

Description : I was just listening to the famous Dr. Martin Luther King speech. Would you say his dream has been completely materialized since the day he made that wonderful speech?

Last Answer : I believe Dr. King would be pleased with the progress but disappointed that after so long, there is still so much bigotry and racism in America.

Why do people constantly return to the refrigerator with hopes that something new to eat will have materialized?

Description : Why do people constantly return to the refrigerator with hopes that something new to eat will have materialized?

Last Answer : It’s possible…

How can I configure Firefox so it automatically refreshes a page after I hit "Back"?

Description : How can I configure Firefox so it automatically refreshes a page after I hit "Back"?

Last Answer : I’m not sure if either of those is possible at all. Unless you’re a l33t h4XX0r and you’re a bad enough dude to go rewrite the whole program.

Part carbon, part water, I am poison to the fishes. Many have falsely claimed my name, for I am the pause that refreshes.What am I? -Riddles

Description : Part carbon, part water, I am poison to the fishes. Many have falsely claimed my name, for I am the pause that refreshes.What am I? -Riddles

Last Answer : I am Soda Pop!

In snapshot, …………………. clause tells oracle how long to wait between refreshes. A) Complete B) Force C) Next D) Refresh

Description : In snapshot, …………………. clause tells oracle how long to wait between refreshes. A) Complete B) Force C) Next D) Refresh

Last Answer : D) Refresh

A dynamic RAM has refresh cycle of 32 times per msec. Each refresh operation requires 100 nsec and a memory cycle requires 250 nsec. What percentage of memory’s total operating time is required for refreshes? (A) 0.64 (B) 0.96 (C) 2.00 (D) 0.32

Description : A dynamic RAM has refresh cycle of 32 times per msec. Each refresh operation requires 100 nsec and a memory cycle requires 250 nsec. What percentage of memory’s total operating time is required for refreshes? (A) 0.64 (B) 0.96 (C) 2.00 (D) 0.32

Last Answer : Answer: D Explanation: in 1ms : refresh = 32 times Memory cycle = 1ms/250ns = 106ns/250ns = 4000 times Therefore, % of refresh time = (32 x 100ns)/(4000 x 250ns) = 3200ns/1000000 x 100% = 0.32%

Which Process writes data in Datafiles?

Description : Which Process writes data in Datafiles?

Last Answer : Database Writer background process DBWn (20 possible) writes dirty buffers from the buffer cache to the data files. In other words, this process writes modified blocks permanently to disk.

Which Process reads data from Datafiles?

Description : Which Process reads data from Datafiles?

Last Answer : Server Process - There is no background process which reads data from datafile or database buffer. Oracle creates server processes to handle requests from connected user processes. A server process ... , minimizing the number of server processes and maximizing the use of available system resources.

A developer wants to process all transactions in the sequence specified by the application. Which type of Remote Function Call (RFC) implementation do you recommend? A. Background RFC (bgRFC) B. Asynchronous RFC (aRFC) C. Synchronous RFC (sRFC) D. Transactional RFC (tRFC)

Description : A developer wants to process all transactions in the sequence specified by the application. Which type of Remote Function Call (RFC) implementation do you recommend? A. Background RFC (bgRFC) B. Asynchronous RFC (aRFC) C. Synchronous RFC (sRFC) D. Transactional RFC (tRFC)

Last Answer : D. Transactional RFC (tRFC)

What is the function of following UNIX command? WC – l<a >b& (A) It runs the word count program to count the number of lines in its input, a, writing the result to b, as a foreground process. (B) It runs the word count program to count the number of lines in its input, a, writing the result to b, but does it in the background. (C) It counts the errors during the execution of a process, a, and puts the result in process b. (D) It copies the ‘ l ’ numbers of lines of program from file, a, and stores in file b.

Description : What is the function of following UNIX command? WC - lb& (A) It runs the word count program to count the number of lines in its input, a, writing the result to b, as a foreground process. (B) It runs ... (D) It copies the l ' numbers of lines of program from file, a, and stores in file b.

Last Answer : (B) It runs the word count program to count the number of lines in its input, a, writing the result to b, but does it in the background.

What does "jumps off the screen" mean?

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

What are the two ways to incorporate images into a oracle forms application?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

Can one export a subset of a table? (for DBA

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

What are the types of visual attribute settings?

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

How does one use the import/export utilities? (for DBA

Description : How does one use the import/export utilities? (for DBA

Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).

what is a display item?

Description : what is a display item?

Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

What is import/export and why does one need it? (for DBA

Description : What is import/export and why does one need it? (for DBA

Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.

Are there any troubleshooting tips for OEM? (for DBA

Description : Are there any troubleshooting tips for OEM? (for DBA

Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.

Where can one get more information about TCL? (for DBA

Description : Where can one get more information about TCL? (for DBA

Last Answer : One can write custom event checking routines for OEM using the TCL (Tool Command Language) language. Check the following sites for more information about TCL: . The Tcl Developer Xchange - ... the OraTCL package . Tom Poindexter's Tcl Page - Oratcl was originally written by Tom Poindexter

How does one start the Oracle Intelligent Agent? (for DBA

Description : How does one start the Oracle Intelligent Agent? (for DBA

Last Answer : One needs to start an OIA (Oracle Intelligent Agent) process on all machines that will to be managed via OEM. For OEM 9i and above:

What is the Oracle Intelligent Agent? (for DBA

Description : What is the Oracle Intelligent Agent? (for DBA

Last Answer : The Oracle Intelligent Agent (OIA) is an autonomous process that needs to run on a remote node in the network to make the node OEM manageable. The Oracle Intelligent Agent is ... events registered in Enterprise Manager; and . Executing tasks associated with jobs submitted to Enterprise Manager.

What are the types of SQL Statement ?

Description : What are the types of SQL Statement ?

Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.

How does one backout events and jobs during maintenance slots? (for DBA

Description : How does one backout events and jobs during maintenance slots? (for DBA

Last Answer : Managemnet and data collection activity can be suspended by imposing a blackout. Look at these examples: agentctl start blackout # Blackout the entrire agent agentctl stop blackout # Resume normal monitoring ... management agentctl start blackout -s jobs -d 00:20 # Blackout jobs for 20 minutes

What are the pre requisites ?

Description : What are the pre requisites ?

Last Answer : I. to modify data type of a column ? ii. to add a column with NOT NULL constraint ? To Modify the datatype of a column the column must be empty. to add a column with NOT NULL constrain, the table must be empty.

What kind of jobs can one schedule with OEM? (for DBA

Description : What kind of jobs can one schedule with OEM? (for DBA

Last Answer : OEM comes with pre-defined jobs like Export, Import, run OS commands, run sql scripts, SQL*Plus commands etc. It also gives you the flexibility of scheduling custom jobs written with the TCL language.

Difference between SUBSTR and INSTR ?

Description : Difference between SUBSTR and INSTR ?

Last Answer : INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.

Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA

Description : Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA

Last Answer : When a job is submitted the agent will confirm the status of the job. When the status shows up as scheduled, you can close down the OEM console. The processing of the job is managed by the OIA ... that OEM will not be able to send e-mail and paging notifications when the Console is not started.

Explain UNION,MINUS,UNION ALL, INTERSECT ?

Description : Explain UNION,MINUS,UNION ALL, INTERSECT ?

Last Answer : INTERSECT returns all distinct rows selected by both queries.MINUS - returns all distinct rows selected by the first query but not by the second.UNION - returns all distinct rows selected by either queryUNION ALL - returns all rows selected by either query, including all duplicates.

WHY USE RMAN ? (for DBA

Description : WHY USE RMAN ? (for DBA

Last Answer : No extra costs Its available free ?RMAN introduced in Oracle 8 it has become simpler with newer versions and easier than user managed backups ?Proper security ?You are 100% sure your ... what need to backed up Knows what is required for recovery Knows what backups are redundant

WHAT IS RMAN ? (for DBA

Description : WHAT IS RMAN ? (for DBA

Last Answer : Recovery Manager is a tool that: manages the process of creating backups and also manages the process of restoring and recovering from them.

What is the basic structure of PL/SQL ?

Description : What is the basic structure of PL/SQL ?

Last Answer : PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.