Oracle parallel query (OPQ) - June 17, 2010 at 12:30 PM
by Babu Kunwar
What is Oracle Parallel Query?
Difference between Parallel
Query and Parallel Server
Explain how to invoke Parallel
Query
Explain how to disable Parallel
Query
Explain how to monitor Parallel
Query Execution
Can single-processor systems
benefit from Parallel Query? Explain
Object data types are user defined data types. Both column and row can represent
an object type................
User process – User process is used in invocation of application software, Data
writing process - A database writer process is used to write buffer content
into a datafile. They are specifically used to write “dirty block” to data
files from the buffer..............
Procedure runs only when one call them manually whereas a trigger runs when
there is any activity (insert,update,delete) on table on which the trigger is
written...................
|
