Database Administration (MOSC)

MOSC Banner

how determinate the best value of processes parameter

edited Feb 1, 2013 6:55AM in Database Administration (MOSC) 9 commentsAnswered
Helloin RDBMS 11.2.0.3 exists a select to determiate the best value for parameter processes
now I have this parameter

SELECT name, value
FROM gv$parameter
WHERE isdefault = 'FALSE';

NAME                           VALUE
------------------------------ ------------------------------
processes                      150
nls_language                   ITALIAN
nls_territory                  ITALY
nls_date_format                DD-MON-RR
memory_target                  1677721600
control_files                  /opt/oracle/oradata/age2/contr
                               ol01.ctl, /opt/oracle/oradata/
                               age2/control02.ctl

db_block_size                  8192
compatible                     11.2.0.0.0

NAME                           VALUE
------------------------------ ------------------------------
db_recovery_file_dest          /opt/oracle/fast_recovery_area
db_recovery_file_dest_size     4322230272
undo_tablespace                UNDOTBS1
remote_login_passwordfile      EXCLUSIVE
db_domain                      agecontrol.it
dispatchers                    (PROTOCOL=TCP)(DISPATCHERS=3)
shared_servers                 30
max_shared_servers             50

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