Explain the difference between a data block, an extent and a
segment.
- 2 Answers
- 9920 Views
- I also Faced
- E-Mail Answers
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
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is grd?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Why would you use sql agent? : sql server DBA
how does an oracle clusterware manage crs resources?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How would you go about verifying the network name that the local_listener is currently using?
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?
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
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What the different topologies in which replication can be configured? : sql server DBA
Where would you look for errors from the database engine?
What the different components in replication and what is their use? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
