Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Shared Pool problem

Re: Shared Pool problem

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 24 Aug 2000 13:11:41 -0400
Message-Id: <10599.115490@fatcity.com>


Rerun catalog, catproc, and catexp. This should clear up your problems. RBG
----- Original Message -----
From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, August 24, 2000 8:47 AM
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èmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique
Maritimes Region, DFO      | Région des Maritimes, MPO

--
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
also send the HELP command for other information (like subscribing).
Received on Thu Aug 24 2000 - 12:11:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US