Author: mfadmin

Describe 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

Database

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe the UGA,”Found in the[…]

Read more