Skip to content

Instantly share code, notes, and snippets.

@bulain

bulain/ora_extends_conn.sql

Created July 19, 2011 01:13
Show Gist options
  • Save bulain/1091089 to your computer and use it in GitHub Desktop.
Save bulain/1091089 to your computer and use it in GitHub Desktop.
Download ZIP
extends connecions in oracle 10g
Raw
ora_extends_conn.sql
1, using system login
sqlplus system/password@xe
2, change system session configuration.
alter system set session_cached_cursors=200 scope=spfile;
alter system set session_max_open_files=200 scope=spfile;
alter system set sessions=20 scope=spfile;
alter system set license_max_sessions=200 scope=spfile;
alter system set license_sessions_warning=200 scope=spfile;
alter system set processes=200 scope=spfile;
3, restart oracle instance.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment