Change Database Parameter And Memory Size.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Rajib>sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Thu May 16 20:36:55 2013

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

SQL> conn sys /as sysdba
Enter password:
Connected.
SQL>
SQL> show parameter process

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0                             
db_writer_processes                  integer     1                             
gcs_server_processes                 integer     0                             
job_queue_processes                  integer     10                            
log_archive_max_processes            integer     2                             
processes                            integer     150                           
SQL> show session
SP2-0158: unknown SHOW option "session"
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                             
logmnr_max_persistent_sessions       integer     1                             
session_cached_cursors               integer     20                            
session_max_open_files               integer     10                            
sessions                             integer     170                           
shared_server_sessions               integer                                   
SQL> show parameter sga

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE                         
pre_page_sga                         boolean     FALSE                         
sga_max_size                         big integer 584M                          
sga_target                           big integer 584M                          
SQL> show parameter pga

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
pga_aggregate_target                 big integer 194M                          

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

System altered.

SQL> alter system set sga_max_size=684M scope=spfile;

System altered.

SQL> alter system set sga_target=684M scope=spfile;

System altered.

SQL> alter system set pga_aggregate_target=294M scope=spfile;

System altered.

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

Total System Global Area  717225984 bytes                                      
Fixed Size                  1292684 bytes                                      
Variable Size             192939636 bytes                                      
Database Buffers          515899392 bytes                                      
Redo Buffers                7094272 bytes                                      
Database mounted.
Database opened.
SQL> conn / as sysdba
Connected.
SQL> show parameter processes

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0                             
db_writer_processes                  integer     1                             
gcs_server_processes                 integer     0                             
job_queue_processes                  integer     10                            
log_archive_max_processes            integer     2                             
processes                            integer     300                           
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                             
logmnr_max_persistent_sessions       integer     1                             
session_cached_cursors               integer     20                            
session_max_open_files               integer     10                            
sessions                             integer     335                           
shared_server_sessions               integer                                   
SQL> show parameter sga

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE                         
pre_page_sga                         boolean     FALSE                         
sga_max_size                         big integer 684M                          
sga_target                           big integer 684M                          
SQL> show parameter pga

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
pga_aggregate_target                 big integer 294M                          
SQL> show parameter transa

NAME                                 TYPE        VALUE                         
------------------------------------ ----------- ------------------------------
transactions                         integer     368                           
transactions_per_rollback_segment    integer     5                             
SQL> exit