Explain the difference between a data block, an extent and a
segment.
Answers were Sorted based on User's Feedback
Answer / wafa
data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database object.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
How will u copy the objects of one schema to another schema in datapump & export/import?
what is a crs resource?
how can you enable flashback feature?
What are the steps you will take to improve performance of a poor performing query?
What column differentiates the V$ views to the GV$ views and how?
Give two examples of referential integrity constraints.
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
1)how to Take Backup in sql server 2005 from Flash Drive
how does an oracle clusterware manage crs resources?
by issuing "alter tablespace begin backup;" what happens to tablespace?
You're getting high "busy buffer waits" - how can you find what's causing it?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?