Answer Posted / 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 |
Post New Answer View All Answers
How to pass a parameter to a cursor in oracle?
Will you be able to store pictures in the database?explain.
What is connection pooling in oracle?
Explain coalesce function?
Is rowid unique in oracle?
What is rowid and rownum in oracle?
How to add another datafile to a tablespace?
How to insert a record into a table?
What is the difference between post-database commit and post-form commit?
What are temporal data types in oracle?
How to assign a tablespace to a users in oracle?
What happens to the current transaction if the session is ended?
When do you get a .pll extension in oracle?
How to call a sub procedure?
what is the difference between substr and instr function in oracle?