PsychoDazey
asked on
Block Size, 32 bit vs 64 bit
I have a test environment that is running the 32 bit version of Oracle 10g on windows. The production environment is oracle 10g 64 bit. I am being asked to restore a database from the test server to the production server (and vice-versa). the block size on the production server is 8192. On the test server it is 4096. Will this cause issues? What is the benefit to the larger bock size? Are there any other issues I should be aware of when going between the 32 and 64 bit versions?
ASKER
this system is mainly for data warehousing and reporting. What is your opinion of the block size of 8192?
For data warehousing and reporting, larger block sizes are usually better than smaller. A smaller block size in a data warehouse will usually cause slower performance, but not errors.
ASKER
thanks for the input...one last question: do you agree it would be best to keep both the test and production environments the same or is there no impact? They are trying to avoid buying another 64 bit license, but I dont think it costs more for 32 bit vs 64 bit
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you, you were a huge help!
Will a different block size between a test system and a production cause issues? Maybe, but most likely not. Smaller block sizes tend to work better for OLTP (transaction-processing) systems. Large blco sizes tned to work better for Data Warehouse (decision-support) systems.
What kind of application does this database support? Is it mainly a transaction-processing system, or mainly a reporting system (that uses bulk or batch jobs to load large numbers of records at a time)?