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 is a SNAPSHOT ?
How to install oracle odbc drivers?
what are steps for interface? where is exchange rate defined in which table?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
What are a collation and state the different types of collation sensitivity?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Explain the difference between replace() and translate() functions in oracle?
Explain the importance of .pll extension in oracle?
What is an Index Segment ?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
What privilege is needed for a user to connect to oracle server?
query optmization techniques and quwry analyser+projects+ppts