Re: Shared Pool problem

Patrice,

         Oracle Support for the 600's, even on metalink you might be able=20 to find something if you query with those argurments. That's my idea! :) As for the first part, I would think it's a=20 not-having-a-public-synonym-or-public-grant-on-the-view-problem... Good Luck
Lyall Barbour

At 04:47 AM 8/24/00 -0800, you wrote:
>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
>Maritimes Region, DFO | R=E9gion 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 - 09:22:49 CDT