What is a Temporary Segment ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
Temporary segments are created by ORACLE when a SQL statement
needs a temporary work area to complete execution. When the
statement finishes execution, the temporary segment extents are
released to the system for future use.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / bijender singh
Temporary segements are created during the sorting
operation in the temporary tablespace and released after
the execution.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to define a sub function?
what is IDE,DMV in sql server?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is rich query?
How do I escape a reserved word in oracle?
What are the parameters that we can pass through a stored procedure?
how many columns can a plsql table have
How to view existing locks on the database?
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?
What is a Data Segment ?
Explain the dml?