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 |
What happens if recursive calls get out of control?
what is difference between table and view? where to use views? thanks in advance!
How to use select statement to count the number of rows in oracle?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
How to define an external table with a text file?
What is the difference between RBBMS & DBMS?
What is oracle in java?
can you explain performance tunning in oracle(sql,PL/SQL)
What is oracle used for?
Please explan Why static query is more faster than dynamic query ?
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
What are the oracle differences between nvl and coalesce