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
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How would you extract DDL of a table without using a GUI tool?
how does an oracle clusterware manage crs resources?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what is the role of dip user in our database?
How would you go about verifying the network name that the local_listener is currently using?
how to restore files with rman?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is the default fill factor value? : sql server DBA
what is the use of recording information about current session?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how can you implement fine-grained auditing?
What are the different ways you can create databases in sql server? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what is grd?