| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Shared Pool problem
Check the machine resources. Are you swapping out the oracle engine? =
Enough
memory on the box?? Just a thought.=20
We had something similar on a solaris 2.6 box.. The database was moved =
to
the box-and the dba didn't change any init parms... as well as other =
things
running(redbrick!) on the box..
We found the machine starving for resources(memory, cpu)
greg
-----Original Message-----
From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca]
Sent: Thursday, August 24, 2000 8:48 AM
To: Multiple recipients of list ORACLE-L
Subject: Shared Pool problem
I just finished re-organising a server, with two databases.
One database is fine, the other has major problems with the data =
dictionary
I think.
I can compile most of the views, except all_tab_columns, =
all_tab_comments,
and all_col_comments.
Although all the other views compile, many of the data dictonary views =
will
not run.
Even when I log in as myself (with DBA role) or as SYSTEM, I can't =
query
v$sga, but if I log in as SYS I can query it no problem.
There is plenty of free space in the Shared Pool, according to = v$sgastat.
I am getting a number of ORA-600 errors:
Wed Aug 23 01:43:23 2000
Errors in file /oracle/oradata1/bank2/user_dump/ora_7946.trc:
ORA-00600: internal error code, arguments: [2141], [3936401603],
[3936401908], [], [], [], [], []
Wed Aug 23 11:52:31 2000
Errors in file /oracle/oradata1/bank2/user_dump/ora_14952.trc:
ORA-00600: internal error code, arguments: [729], [552752], [space =
leak],
[], [], [], [], []
Wed Aug 23 16:30:11 2000
Errors in file /oracle/oradata1/bank2/user_dump/ora_17653.trc:
ORA-00600: internal error code, arguments: [17176], [0], [], [], [], =
[], [],
[]
Any ideas?
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des syst=E8mes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique=20 Maritimes Region, DFO | R=E9gion des Maritimes, MPO
--=20
Author: Boivin, Patrice J
INET: BoivinP_at_mar.dfo-mpo.gc.ca
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Thu Aug 24 2000 - 07:29:33 CDT
 |
 |