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 get last monday of a month?
Can a Tablespace hold objects from different Schemes ?
what is the output of select * from emp where null=null & select * from emp where 1=1
When can Hash Cluster used ?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
How to recover a dropped index?
How to create index-by table in oracle?
How to insert a record into a table?
what is difference between foreign key and reference key
what is the difference between sql& oracle?
How to work with data objects interactively?
How oracle handles dead locks?