How can I set the DATABASE PARAMETER like SESSION PARAMETERS
Dear!
I have Oracle R11 on Microsoft Windows server 2008
I would like to have the same parameters as SESSION_PARAMETERS and DATABASE_PARAMETERS.
The DATABASE_PARAMERES must be the same as SESSION_PARAMETERS, slovenian . ..
This ia my SPFILE::
webdb.__db_cache_size=1962934272
webdb.__java_pool_size=16777216
webdb.__large_pool_size=16777216
webdb.__oracle_base='E:\oracle\dbadmin'#ORACLE_BASE set from environment
webdb.__pga_aggregate_target=872415232
webdb.__sga_target=2583691264
webdb.__shared_io_pool_size=0
webdb.__shared_pool_size=536870912
webdb.__streams_pool_size=16777216
*.audit_file_dest='E:\oracle\dbadmin\admin\webdb\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='E:\oracle\dbadmin\oradata\webdb\control01.ctl','E:\oracle\dbadmin\fast_recovery_area\webdb\control02.ctl'
I have Oracle R11 on Microsoft Windows server 2008
I would like to have the same parameters as SESSION_PARAMETERS and DATABASE_PARAMETERS.
The DATABASE_PARAMERES must be the same as SESSION_PARAMETERS, slovenian . ..
This ia my SPFILE::
webdb.__db_cache_size=1962934272
webdb.__java_pool_size=16777216
webdb.__large_pool_size=16777216
webdb.__oracle_base='E:\oracle\dbadmin'#ORACLE_BASE set from environment
webdb.__pga_aggregate_target=872415232
webdb.__sga_target=2583691264
webdb.__shared_io_pool_size=0
webdb.__shared_pool_size=536870912
webdb.__streams_pool_size=16777216
*.audit_file_dest='E:\oracle\dbadmin\admin\webdb\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='E:\oracle\dbadmin\oradata\webdb\control01.ctl','E:\oracle\dbadmin\fast_recovery_area\webdb\control02.ctl'
0