Question
What database block size should i use? (for dba)
Answers
Oracle recommends that your database block size match, or be multiples of your operating system block size. One can use smaller block sizes, but the performance cost is significant. Your choice should depend on the type of application you are running. If you have many small transactions as with OLTP, use a smaller block size. With fewer but larger transactions, as with a DSS application, use a larger block size. If you are using a volume manager, consider your "operating system block size" to be 8K. This is because volume manager products use 8K blocks (and this is not configurable).   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q How to get the first 100 rows from the flat file into the target?
  • Q Why do stars twinkle but not planets?
  • Q Who was the first person in space?
  • Q Discuss, with specific examples, mechanisms employed by viruses to evade host immune responses.
  • Q how to Use datetime datatypes
  • Q Recently, India signed an agreement to cooperate in Cyber Security and Green ICT with which country
  • Q At the entrance to a members club stands a stranger seeking admission. A friend told him that it's easy to get in. You just have to answer a question corrcetly! Answering wrong, however, will result in being shot! To live a little longer, the man waits in a back alley near the entrance for people to go in. After a while a man comes to the entrance. The door warden asks him: "Twelve?" to which he replies "Six!" and goes in. "That's easy." our friend thinks, but he waits a little longer. Another man comes to the door. "Six?" the door warden asks, to which he replies "Three!" and goes in. "That's too good to be true" our friend thinks, and he was right. Because, when asked "Four?", he answered "Two!" and was found dead in the alley. What was the correct answer?
  • Q What uses 28 calories if done for one minute
  • Q How do i rotate a 3d point?
  • Q You do not have all the required experience. How would you compensate for it?
  • Q The name of the train “Shatabdi Express ” addresses the centenary of