Database Administration (MOSC)

MOSC Banner

How can I set the DATABASE PARAMETER like SESSION PARAMETERS

edited Feb 1, 2013 11:55AM in Database Administration (MOSC) 2 commentsAnswered
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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center