Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Shared Pool problem
Sorry, I kept referring to EXTEND, but it should be RESIZE.
After dropping and re-creating those tablespaces, I am getting the same errors. Still talking with Oracle.
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
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20
-----Original Message----- From: Boivin, Patrice J [SMTP:BoivinP_at_mar.dfo-mpo.gc.ca] Sent: Friday, August 25, 2000 1:15 AM To: Multiple recipients of list ORACLE-L Subject: RE: Shared Pool problem Thanks everyone. Not finished fixing it yet, but I thought you might want to know that there is a problem with the EXTEND clause of alter tablespace on Digital UX - If the files are very large, the Oracle data dictionary gets confused. At least it did after a full import! Import tried to re-create a handful of tablespaces (not all) with size values like 18446744072560312320. Imagine what that does to the data dictionary... and Shared Pool. See note 1012442.6. This is on Oracle 7.3.4.4., D-UX 4.0D, don't know what the situation is for the other versions or other OSes but I heard that there are many hits for RESIZE in MetaLink. I hadn't used the EXTEND clause from the command line, but I did extend six tablespaces' datafiles using Storage Manager. I imagine Storage Manager extends the files by using RESIZE. File sizes varied between 3000M to 7048M in size. The fix was to drop those tablespaces, re-create them manually with the file size I wanted, and import back in. Am importing now. After that I hopefully won't have too much cleaning up to do, may have to reboot the UNIX server because Oracle says memory is probably fragmented by now. 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 E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca> -----Original Message----- From: Lyall Barbour [SMTP:lbarbour_at_stanford.edu] Sent: Thursday, August 24, 2000 12:26 PM To: Multiple recipients of list ORACLE-L Subject: 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=09
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 =09
>--------------------------------------------------------------------
>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). --=20 Author: Lyall Barbour INET: lbarbour_at_stanford.edu 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). --=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 inReceived on Fri Aug 25 2000 - 05:54:17 CDT