How to define Data Block size ?

Answer Posted / nishi

A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and can't be changed latter.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can windows applications connect to oracle servers?

518


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1468


What are the differences between interval year to month and interval day to second?

550


Explain what are the uses of rollback segment?

578


How do I spool to a csv formatted file using sqlplus?

544






What is a table index?

559


How to experiment a data lock in oracle?

593


query optmization techniques and quwry analyser+projects+ppts

1925


What is a nvl function? How can it be used?

557


How many types of synonyms in Oracle?

591


Why oracle is used?

578


How to use in conditions in oracle?

549


How to define a cusotmer as a supplier in ORACLE R12

1726


What is using clause and give example?

579


Why is oracle so popular?

558