Hi Jim,
I could reproduce it at my place. A possible candidate for BUG i suppose.
Cheers
Amar
The last step hangs the system...Code:SQL*Plus: Release 9.2.0.2.0 - Production on Mon Mar 17 16:59:14 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
SQL> show sga
Total System Global Area 101784268 bytes
Fixed Size 453324 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL> set lines 200
SQL> show parameter shared_pool_size
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
shared_pool_size big integer 50331648
SQL> alter system set shared_pool_size=40331648 scope = both;
System altered.
SQL> show parameter shared_pool_size
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
shared_pool_size big integer 41943040
SQL> SELECT
2 REQUEST_FAILURES,
3 LAST_FAILURE_SIZE,
4 MAX_FREE_SIZE,
5 FREE_SPACE,
6 REQUEST_MISSES
7 FROM
8 V$SHARED_POOL_RESERVED;
SELECT
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL>
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> alter system set shared_pool_size=50331648 scope = both;
System altered.
SQL> show parameter shared_pool_size
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
shared_pool_size big integer 50331648
SQL> SELECT
2 REQUEST_FAILURES,
3 LAST_FAILURE_SIZE,
4 MAX_FREE_SIZE,
5 FREE_SPACE,
6 REQUEST_MISSES
7 FROM
8 V$SHARED_POOL_RESERVED;