Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe the Streams Pool,”Found in[…]
Read moreCategory: Database
describe the PGA,”Program Global Area (PGA) is a memory region that contains data and control information for each server process. An Oracle server process services a client’s requests. Each server process has its own private PGA that is allocated when the server process is started. Access to the PGA is exclusive to that server process
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.describe the PGA,”Program Global Area[…]
Read moreWhat does the PGA contain?
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.What does the PGA contain?[…]
Read moreShared pool contains what?,”the shared pool contains the library cache and Shared SQL area, the data dictionary cache
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Shared pool contains what?,”the shared[…]
Read moreDescribe the UGA,”Found in the PGAThe UGA is composed of the following:• Cursor area for storing runtime information on cursors• User session data storage area for control information about a session• SQL working areas for processing SQL statements consisting of:- A sort area for functions that order data such as ORDER BY and GROUP BY- A hash area for performing hash joins of tables- A create bitmap area used in bitmap index creation common to data warehouses- A bitmap merge area used for resolving bitmap index plan executionIn a shared server environment, multiple client users share the server process. In this model
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe the UGA,”Found in the[…]
Read moredescribe the data dictionary,”the data dictionary is found in the Shared pool in the SGA. It is both in the data dictionary cache (row cache: holds data as rows instead of buffers) and in the library cache.It is a collection of database tables and views containing reference info about the database, its structures
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.describe the data dictionary,”the data[…]
Read moreWhat is a user process
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.What is a user process[…]
Read morevertical partitioning,”When you have organizational functions with separate data requirements
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.vertical partitioning,”When you have organizational[…]
Read moreremote procedure calls
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.remote procedure calls a protocol[…]
Read morehorizontal partitioning,”When you have an organizational design in which functions are replicated
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.horizontal partitioning,”When you have an[…]
Read more