-
Hi Jim,
I could reproduce it at my place. A possible candidate for BUG i suppose.
Cheers
Amar
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;
The last step hangs the system...
Amar
"There is a difference between knowing the path and walking the path."
-
It's interesting that you can reproduce the error because I have attempted the same thing on 2 different test instances and still can't get it to reproduce
I wondered if it had anything to do with the contents of the shared poll when it is resized.
The details from Oracle seem to imply that they are working on a backport for a previous bug to be released in 9.2.0.3
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
-
Thanks for your help Amar
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
I tried to reproduce the problem on Tru64 5.1A with 9.2.0.1.0, I reduced the shared pool about 100 MB and got the followin results
SQL> CONN SYS/ORACLE@ALPHA AS SYSDBA
Connected.
SQL> SHOW SGA
Total System Global Area 370642376 bytes Fixed Size 732616 bytes
Variable Size 251658240 bytes Database Buffers 117440512 bytes
Redo Buffers 811008 bytes
SQL> SHOW PARAMETER SHARED_POOL_SIZE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------ shared_pool_size big integer 218103808
SQL> ALTER SYSTEM SET SHARED_POOL_SIZE = 113246208;
System altered.
SQL> SHOW PARAMETER SHARED_POOL_SIZE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------ shared_pool_size big integer 117440512
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
9 ;
V$SHARED_POOL_RESERVED
*
ERROR at line 8:
ORA-04030: out of process memory when trying to allocate 88 bytes (cursor work he,x$ksmsp)
(This error took alot of time to come up so i tried again)
SQL> SHOW PARAMETER SHARED_POOL_SIZE
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------shared_pool_size big integer 117440512
SQL> L
1 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
9*
SQL> /
V$SHARED_POOL_RESERVED
*
ERROR at line 8:
ORA-04030: out of process memory when trying to allocate 88 bytes (cursor work he,x$ksmsp)
SQL> spool off
I think i have to try more to get the error u got Jim
NK
====================================================
Stand up for your principles even if you stand alone!
====================================================
-
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|