| caused an ORA 600 [message #177471] |
Wed, 14 June 2006 21:24 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Doesn't really bother me or anything, and I haven't researched or searched for it at all to see more details, but in case this helps anyone, it would seem that if you do the following, you well get ORA-00600 quite regularly. This is on 10.1.0.2 (10gR1, without any patches, which of course may explain it right there) on windows 32 bit (XP SP2).
SQL> create user a identified by a;
User created.
SQL> alter session set current_schema=a;
Session altered.
SQL> drop user a;
User dropped.
SQL> show parameter lock_sga;
ORA-00600: internal error code, arguments: [5126], [66], [], [], [], [], [], []
SQL> show parameter workarea_size;
ORA-00600: internal error code, arguments: [5126], [66], [], [], [], [], [], []
SQL> alter session set current_schema=mydba;
Session altered.
SQL> show parameter workarea_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
workarea_size_policy string AUTO
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production
SQL> exit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
