Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between a data block, an extent and
a segment.
- 1 Answers
- 9418 Views
- Accenture, IBM, I also Faced
- E-Mail Answers
Answer / 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 |
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.
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
What view would you use to look at the size of a data file?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
what is the difference b/w oracle8i and oracle9i
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
Explain the payment term in ar. : oracle accounts receivable
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
Oracle General 
