摘要： How much memory does each of the individual components of the SGA need? Oracle now has methods to determine most of the major parameters all on its own.What is the SGASimply stated, the system global area (SGA) is just shared memory structures that are created at instance startup, hold information a 阅读全文

摘要： In oracle 10g we can have multiple block sizes at the same time. When a tablespace is created we can assign a block size for the objects that will be created in that tablespace.The DB_BLOCK_SIZE parameter in your initialization parameter file determines the size of your standard block size in the da 阅读全文