When a process needs to use the defined temporary tablespace for sorting operations, which of the following does it do?
A . It looks in the PGA sort extent pool (SEP) to determine if there are free extents in the system tablespace.
B. It looks in the SGA sort extent pool (SEP) to determine if there are free extents in the sort segment.
C . It looks in the PGA sort extent pool (SEP) to determine if there are free extents in the sort segment.
Explanation:
Answer B: A sort segment is created when the first sort operation uses the tablespace, and is dropped when the database is closed. The sort segment grows as needed, and is made up of extents that can be used by different sort operations. When a process needs sort space, it looks in the SGA Sort sort Extent extent Pool pool (SEP) to determine if there are free extents in the sort segment.
No comments:
Post a Comment