Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between a data block, an extent and
a segment.
- 1 Answers
- 9502 Views
- Accenture, IBM, I also Faced
- E-Mail Answers
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
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
What is mrc and what is its use? : oracle accounts receivable
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Are These Dff's Flexible?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
types of receipts and detail desription about recipts and tables effected by receipts?
What is the importance of batch source set up in ar? : oracle accounts receivable
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
How would you go about increasing the buffer cache hit ratio?
What is db_recovery_file_dest in oracle? When do you need to set this value?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
what are the tools used for oracle 10g in real time.
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?
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
