Explain the difference between a data block, an extent and
a segment.
Answer Posted / kumar.s
Datablock, Extent and Segment
A segment is defined as any entity that consumes physical
storage space within the database.
Each Oracle segment is made up of contiguous chunks of
storage space in the database called extents. Every segment
must have at least one extent, but can have as many as 2
billion extents.
Each extent is itself made up of a collection of smaller
chunks of space called Oracle database blocks. The minimum
size of an extent is five database blocks.
The default size of these database blocks is set at
database creation, but Oracle 10g db can use multiple block
sizes within one db. The common database block sizes are
2KB, 4KB, 8KB, and 16KB.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What do you mean by Oracle MEDIA RECOVERY?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is Restricted Mode of Instance Startup in Oracle?
1. What is PO rate variance gain and loss?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What is the use of lockboxes? : oracle accounts receivable
What is mrc and what is its use? : oracle accounts receivable
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Explain prerequisites and post activities of oracle database installation
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
What is the difference between conversions and interfaces? : oracle accounts receivable