oracle processes 的大小,【sessions】Oracle中sessions和processes的大小关系（10g和11g不同）...

SYS@lhrdb> COL NAME FORMAT

A10

SYS@lhrdb> COL VALUE FORMAT

A10

SYS@lhrdb> SELECT A.NAME,

A.VALUE

2    FROM V$PARAMETER A

3

WHERE A.NAME IN ('processes', 'sessions');

NAME

VALUE

----------

----------

processes

100

sessions

176

SYS@lhrdb>  alter system

set processes=200 scope=spfile;

System

altered.

SYS@lhrdb> STARTUP

FORCE

ORACLE instance

started.

Total

System Global Area 1720328192 bytes

Fixed

Size                  2247072 bytes

Variable Size

503318112 bytes

Database Buffers

1207959552 bytes

Redo

Buffers                6803456 bytes

Database

mounted.

Database

opened.

SYS@lhrdb> SELECT A.NAME,

A.VALUE

2    FROM V$PARAMETER A

3

WHERE A.NAME IN ('processes', 'sessions');

NAME

VALUE

----------

----------

processes

200

sessions

328

SYS@lhrdb>

SYS@lhrdb> alter system set

processes=50  scope=spfile;

System

altered.

SYS@lhrdb>  STARTUP

FORCE

ORACLE instance

started.

Total

System Global Area 1720328192 bytes

Fixed

Size                  2247072 bytes

Variable Size

503318112 bytes

Database Buffers

1207959552 bytes

Redo

Buffers                6803456 bytes

Database

mounted.

Database

opened.

SYS@lhrdb> SELECT A.NAME,

A.VALUE

2    FROM V$PARAMETER A

3

WHERE A.NAME IN ('processes', 'sessions');

NAME

VALUE

----------

----------

processes

50

sessions

176

SYS@lhrdb>

SYS@lhrdb>  alter system

set processes=60  scope=spfile;

System

altered.

SYS@lhrdb> STARTUP

FORCE

ORACLE instance

started.

Total

System Global Area 1720328192 bytes

Fixed

Size                  2247072 bytes

Variable Size

452986464 bytes

Database Buffers

1258291200 bytes

Redo

Buffers                6803456 bytes

Database

mounted.

Database

opened.

SYS@lhrdb> SELECT A.NAME,

A.VALUE

2    FROM V$PARAMETER A

3

WHERE A.NAME IN ('processes', 'sessions');

NAME

VALUE

----------

----------

processes

60

sessions

176