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
the UGA is moved into the SGA (shared pool or large pool if configured) leaving the PGA with only stack space.”