Explain the difference between a data block, an extent and a
segment.
Answer Posted / gaya
The oracle server manages the storage space in the datafiles
in units called oracle blocks or data blocks.
A segment is the space allocated for a specific logical
storage structure within a tablespace.
Space is allocated to a segment by extents.One or more
extents make up a segments.
| Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
what is grd?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
what are the benefits of flashback feature?
what are the types of connection load-balancing?
What are the different sql server versions you have worked on? : sql server DBA
What purpose does the model database server? : sql server DBA
What is dbcc? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
how can you process messages in order asynchronously?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What is transparent data encryption? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
Where would you look for errors from the database engine?
You create a private database link and upon
connection, fails with: ORA-2085: connects to