ORACLE-Memory configuration for 10g - SGA PGA

SUBMITTED BY: Guest

DATE: March 21, 2015, 6:45 p.m.

FORMAT: Text only

SIZE: 2.2 kB

Raw Download

HITS: 24295

Report
  1. !free
  2. --TotalOracleMem=6G
  3. --sga_max_size=4,2G (TotalOracleMem*0,7) => 4200M
  4. --pga_aggregate_target=1,8G (TotalOracleMem*0,3) => 1800M
  5. --sga_target=3,36G (sga_max_size*0,8) => 3360M
  6. alter system set sga_max_size=4200M scope=spfile;
  7. alter system set pga_aggregate_target=1800M scope=spfile;
  8. alter system set sga_target=3360M scope=spfile;
  10. System altered.
  11. System altered.
  12. System altered.
  14. SQL> shut immediate;
  15. Database closed.
  16. Database dismounted.
  17. ORACLE instance shut down.
  18. SQL>
  19. SQL> startup
  20. ORACLE instance started.
  22. Total System Global Area 4412407808 bytes
  23. Fixed Size 2026520 bytes
  24. Variable Size 1577059304 bytes
  25. Database Buffers 2818572288 bytes
  26. Redo Buffers 14749696 bytes
  27. Database mounted.
  28. Database opened.
  29. SQL>
  32. col name format a40
  33. col value format a40
  34. set lin 300
  35. select name, value
  36. from v$parameter
  37. 2 3 where name in ('shared_pool_size', 'java_pool_size', 'streams_pool_size',
  38. 'log 4 _buffer', 'db_cache_size', 'db_2k_cache_size', 'db_4k_cache_size',
  39. 'db_8k_cache_size', 'db_16k_cache_size 5 ', 'db_32k_cache_size',
  40. 'db_keep_cache_size', 'db_recycle_ca 6 che_size', 'large_pool_size');
  42. NAME VALUE
  43. ---------------------------------------- ----------------------------------------
  44. shared_pool_size 0
  45. large_pool_size 0
  46. java_pool_size 0
  47. streams_pool_size 0
  48. db_cache_size 0
  49. db_2k_cache_size 0
  50. db_4k_cache_size 0
  51. db_8k_cache_size 0
  52. db_16k_cache_size 0
  53. db_32k_cache_size 0
  54. db_keep_cache_size 0
  56. NAME VALUE
  57. ---------------------------------------- ----------------------------------------
  58. db_recycle_cache_size 0
  59. log_buffer 14302720
comments powered by Disqus