Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.The SGA contains what data[…]
Read moreTag: db
Describe the Streams Pool,”Found in the SGAStreams pool memory is used exclusively by Oracle Streams to:• Store buffered queue messages• Provide memory for Oracle Streams processesUnless you specifically configure it
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe the Streams Pool,”Found in[…]
Read moredescribe 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 moredescribe the Shared SQL area
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.describe the Shared SQL area[…]
Read morewhat are database processes
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.what are database processes –[…]
Read more