|
|
|
|
| Re: Use of TEMP segment [message #203516 is a reply to message #203512] |
Wed, 15 November 2006 06:32   |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
The temp segment is used for things like Sorts, Hash joins and index creation, so you could minimise this sort of activity.
Why do you feel you need to do this?
|
|
|
|
| Re: Use of TEMP segment [message #203517 is a reply to message #203516] |
Wed, 15 November 2006 06:38 |
kanis
Messages: 61
Registered: November 2006
|
Member |
|
|
I need this as my code ,when executing giving error due to sortage of temp segment .
asically i want to know which operation should be avoided to minimise the use of TEMP segment??
|
|
|
|
|
|
|
|
|
|
| Re: Use of TEMP segment [message #203532 is a reply to message #203527] |
Wed, 15 November 2006 07:17 |
kanis
Messages: 61
Registered: November 2006
|
Member |
|
|
No ,simply this not possible to bye a Harddisk.
I wan to know which operation should be avoided in oracle to minimise the use of temp segment??
Any pointer regrading the minimise the use of temp segment can help me.
|
|
|
|
|
|
| Re: Use of TEMP segment [message #203618 is a reply to message #203538] |
Wed, 15 November 2006 19:25 |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
Things that will use TEMP space:
- ORDER BY
- DISTINCT/UNIQUE
- GROUP BY
- UNION
- MINUS
- INTERSECT
- Hash Joins
- Sort-Merge Joins
- IN sub-queries
- NOT IN subqueries that the CBO transforms into anti-joins
- EXISTS sub-queries that the CBO transforms into Hash or Sort-Merge semi-joins
- Analytic functions
- OR clauses that the CBO transforms into UNIONs
- CREATE INDEX
Did I miss anything?
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
