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
What is a named program unit?
What is data block in Oracle?
Is oracle a language?
What is the sid in oracle?
What is a dead lock in oracle?
How to turn on or off recycle bin for the instance?
What do you mean by merge in oracle and how can you merge two tables?
What privilege is needed for a user to connect to oracle server?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What are the benefits of ordbms?
How do I start tns listener?
What is literal?
How to execute a stored procedure in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
what are archived logs?