Re: Size of SYS1ORCL.ORA

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Tue, 19 Jun 2001 01:59:31 -0700
Message-ID: <F001.0032E560.20010619015536@fatcity.com>

Sounds to me like most of your database objects are in SYSTEM tablespace (ie SYS1ORCL.ORA).

Try

select owner, tablespace_name, count(*)
from dba_segments
group by owner

If you've got lots of things in SYSTEM that are not owned by SYS, SYSTEM then its

1. time to fix a lot of this up
2. get a consultant/senior DBA to come do a review of your system - there's probably a lot of things that can be improved upon
3. glean as much knowledge from them in the process

hth
connor

• Rok Kodrun <rok.kodrun_at_uni-lj.si> wrote: > Hi
  > PLEASE HELP!
  > I have Oracle Workgroup Server 7.3 for Windows NT.
  > How to manage size of database files, when they grow
  > to big?
  > For example, my SYS1ORCL.ORA file has over 376 MB.
  > What to do, to decrease
  > it? I'm running out of disk space and all the user
  > data are on separate
  > tablespace USER_DATA, which has 10MB. The database
  > runs on the machine for
  > couple of years already, without any problems, but
  > we will soon have one -
  > probably.
  > What to do?
  > Rok Kodrun
  > Institute "Jožef Stefan"
  > Ljubljana
  > Slovenia
  >
  >
  

  ---

Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

---

Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

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 Tue Jun 19 2001 - 03:59:31 CDT