RE: Shared Pool problem

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Fri, 25 Aug 2000 00:12:00 -0300
Message-Id: <10599.115526@fatcity.com>

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>=20

	-----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
	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
=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

Received on Thu Aug 24 2000 - 22:12:00 CDT