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 a list of all user accounts in the database?
Is there a function to split a string in plsql?
What to do if the startbd.bat failed to start the xe instance?
What is a Database instance ? Explain?
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
How to grant create session privilege to a user in oracle?
What do you understand by a database object? Can you list a few of them?
select * from emp what happened internally when we write this query in the sql prompt?
Explain about your project and its relation to the current job position you are applying to?
Give the various exception types.
How to define a record variable to store a table row?
Display Odd/ Even number of records?