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

Home -> Community -> Mailing Lists -> Oracle-L -> Solved: System Tablespace > 1.5 GB

Solved: System Tablespace > 1.5 GB

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Mon, 18 Dec 2000 17:48:46 +0100
Message-Id: <10714.124848@fatcity.com>


Proble is slved, I found 12 objects in system tablespace where each = object
allocates 100M, but these objects were empty, cause someone plays with = the
default storage parameter of system tablespace (intial=3D100M, = next=3D100M).
Know I have to export database and recreate it. But this is no problem = for
me, cause customer will pay for it.

Thanks to everyone who replied.

Regards

Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Urspr=FCngliche Nachricht-----

Von: Schoen Volker=20
Gesendet: 18. December 2000 16:57
An: 'Christopher Spence'; 'Oracle Lazy DBA list' Betreff: AW: System Tablespace > 1.5 GB

I found the problem, someone created some objects in system tablespace. Every object (only 12 ones) allocated 100 M of system tablespace, but = the
tables were empty, so I dropped these objects and suddenly system = tablespace
allocates only 50 M. But now a newly question:

Datafile of tablespace system is abeout 1.2 Gb, when I try to shrink datafile, oracle says "file contains 984 blocks of data beyond = requested
resize value". Is there a way, other then export and import full = database,
to reorganize the system tablespace, so that I can shrink it?

TIA Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Urspr=FCngliche Nachricht-----

Von: Christopher Spence [mailto:cspence_at_FuelSpot.com] Gesendet: 18. December 2000 16:49
An: Schoen Volker; 'Oracle Lazy DBA list' Betreff: RE: System Tablespace > 1.5 GB

OMG hehehe,=20

  1. Fire the dba that made the database
  2. Do a full export, recreate the database with sane values, import = data

How much of that is actually used by segments?

"I want to die like my Grampa - in my sleep. Not yelling and screaming = like
his passengers....."

Christopher R. Spence
OCP Raptor MCSE MCP A+ CNA
Database Administrator
Fuel Spot

73 Princeton Road
North Chelmsford, MA 01863
(978)-322-5744

 -----Original Message-----

From: 	Schoen Volker [mailto:v.schoen_at_inplan.de]=20
Sent:	Monday, December 18, 2000 7:37 AM
To:	'Oracle Lazy DBA list'; 'Oracle List'
Subject:	System Tablespace > 1.5 GB

Hi list,

I have a costumer, which has a system tablespaces with 1.2 GB. Default storage parameter fpr initial and next extent are 102400 KB. My = question,
how can I minimize and reorganize system tablespace, Full DB export? Or = is
there another easier method?

TIA Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de



Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com=20 Received on Mon Dec 18 2000 - 10:48:46 CST

Original text of this message

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