More than 5 years have passed since last update.

Oracleの共有サーバー設定

oracle

Last updated at 2013-09-04Posted at 2013-09-04

初期化パラメータを確認

  SQL> show parameters dispatchers

  SQL> show parameters shared_servers
  NAME                     TYPE        VALUE
  ------------------------ ----------- ------------------
  max_shared_servers       integer     
  shared_servers           integer     1

Dispatcher属性を変更

  SQL> alter system set dispathcers = '(PROTOCOL=TCP) (DISPATCHERS=5)';

SQL*Plusで共有サーバーに接続していることを確認

  SQL> select servers from v$session where sid = USERENV('SID');
  SERVER
  ----------------------
  SHARED

  (DEDICATEDの場合は専用サーバー接続)

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up