RE: What is your server configration ?What is yo...
hi
I don't the server cofiguration but as per the query my knowledge Oracle automatically allocates some space in RAM that is called SGA(System Gloabal Area). we could not define the size of SGA or Shared pool Memory .
The default Size of Oracle block upto 9i is 2KB but from 10g it is 8KB
RE: What is your server configration ?What is yo...
Srinivas System does nt allocate SGA automatically. we have to configure SGA. to do the same we can set following parameters in pfile such as db_cache_size shared_pool_size db_block_size. - Aruna
RE: What is your server configration ?What is yo...
oooooooooooopppppppps what an answer mr.srinivas hahhaa
sga:its chunk of memory which is shared by oracle processes and its a memory allocate by oracle instance on server(server side memory).sga is divide into fixed memory(database buffer)is constant cannot be changed and memory is allocated in terms of granules and variable memory(shared pool large pool javapool db_cache_size) which can changed dynamically (session level) or at instance level and memory is allocated in bytes.For optimal performance the sga should fit into RAM.Shared pool contains recently used sql pl/sql statments which can be shared among all users it includes shared sql area and data dictionary cache.
RE: What is your server configration ?What is yo...
Hello sql>show sga then it shows these parameters ---- Total system global area ---- Fixed size ----Variable size ----Database buffers ----Redo buffers
RE: What is your server configration ?What is your SGA size ?what is Shared pool size ?How much size have you configured for oracle_block ?
Use show sga to know all the important parameters that are there for you by default setting of oracle or may be DBA has set at the time of installing the database in your init.ora or sp file.
Many of the SGA values depend upon your system/user/org. environment. How many hits you are having and according to that you need to decide the value of share_pool_size large_pool_size(if its a shared server) log_buffer db_block_size (very important) db_cache_advice sga_max_size.
shared_pool_size includes data dictionary cache (cahce information about data dictionaries tables indexes user ..etc.) and library cache (sql & plsql related queried objects)
If you don't know what size you should use for db_block_size then go for oracle default size and make sure that your db_cache_advice parameter is on. then after some time check the view related to advisory and change the db_block_size accordingly.
