Skip to Main Content
  • Questions
  • SESSION parameter shows different value

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, vishnudas.

Asked: June 07, 2018 - 8:36 am UTC

Last updated: June 13, 2018 - 1:42 am UTC

Version: 11.2.0.1.0

Viewed 1000+ times

You Asked

hi there

As you guys suggested,

last day i was trying to change process and session parameter values as follows,
Everything gone perfectly. But after starting up the database, for the SESSION PARAMETER
it shows me a value that i wasn't expected!!




SQL> show parameter session;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
session_cached_cursors integer 50
session_max_open_files integer 10
sessions integer 1528
shared_server_sessions integer
SQL> show parameter process;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
cell_offload_processing boolean TRUE
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 1000



SQL> alter system set processes=1400 scope=spfile;

System altered.

SQL> alter system set sessions=1545 scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1.3696E+10 bytes
Fixed Size 2188768 bytes
Variable Size 6576671264 bytes
Database Buffers 7079985152 bytes
Redo Buffers 37044224 bytes
Database mounted.
Database opened.
SQL> show user;
USER is "SYS"
SQL> show parameter process;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
cell_offload_processing boolean TRUE
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 1400


SQL> show parameter session;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
session_cached_cursors integer 50
session_max_open_files integer 10
sessions integer 2128
shared_server_sessions integer

i set 1545 for session parameter,but it shows 2128

what is the reason for this??


and Connor said...

We *didn't* say to set the sessions parameter.

We said to set the processes parameter - and the sessions parameter will take on a reasonable default based off that.

Sessions takes into account things like maximum potential background processes etcm so if you set it too low, we'll ignore your value.

From the docs

"Oracle uses the default value of this parameter as its minimum. Values between 1 and the default do not trigger errors, but Oracle ignores them and uses the default instead."

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, June 12, 2018 - 6:58 am UTC

Thank you so much.... :) :) :)
Connor McDonald
June 13, 2018 - 1:42 am UTC

glad we could help

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database