Newbie question on Temp Segments 
Author Message
 Newbie question on Temp Segments
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?

Thanks in advance for any help

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 Newbie question on Temp Segments

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?

Thanks in advance for any help

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Newbie Question on Temp Segments

2. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

3. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

4. ORA-01652: unable to extend temp segment by 512 in tablespace TEMP

5. temp segment in non-temp tablespace??

6. Some question about temp segment

7. Question on Temp Segments

8. IMPort / temp segment question

9. newbie question about to small rollback segment

10. Newbie Question on Temporary Segments

11. Newbie question about segment & partition

12. Newbie Question re BOL Temp Files


 
Powered by phpBB® Forum Software