Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Temp Segments

Temp Segments

From: <vasarpota_at_my-deja.com>
Date: 2000/03/31
Message-ID: <8c2o8u$5lp$1@nnrp1.deja.com>#1/1

Hi guys,
was just reading the Oracle DBA book and wanted to clear up a couple of issues:
1) The SORE_AREA_SIZE is a system parameter and not specific to each user, right? Meaning, this represents the size in memory for all users regarding Sorts and when exceeded temporary segments are used 2) When should temporary segments be placed in Permanent Tablespaces? 3) How is the PGA used regarding Temporary Segments and sorting if at all?
Thanks in advance for

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 31 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US