Question on Temp Segments 
Author Message
 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
 Question on Temp Segments

OK, Next time, please don't post your question MANY times.

Regards,

Sybrand Bakker, Oracle DBA

Quote:

> 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. Some question about temp segment

2. Newbie Question on Temp Segments

3. Newbie question on Temp Segments

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

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

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

7. temp segment in non-temp tablespace??

8. IMPort / temp segment question

9. 01652: unable to extend temp segment

10. ORA-1652: unable to extend temp segment by 7680 in tablespace

11. Strange Segment called 6.2 in TEMP

12. Temp segment, info problem.


 
Powered by phpBB® Forum Software