From: ashok_jayaraman@yahoo.com (Jayaraman Ashok)
Newsgroups: comp.databases.oracle.server
Subject: Reorganize System Tablespace
Date: 9 Sep 2002 02:08:21 -0700
Organization: http://groups.google.com/
Lines: 26
Message-ID: <7ca2852.0209090108.6f087ca7@posting.google.com>
NNTP-Posting-Host: 203.247.159.52
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1031562501 9568 127.0.0.1 (9 Sep 2002 09:08:21 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 9 Sep 2002 09:08:21 GMT


Hi
The database is running on Oracle 8.1.6.3.0 on AIX 4.3.3. Whe i query
on any dba* views it takes more than 30 minutes or so to get the
result and sometimes it just hangs. Oracle says it is due to smon
hanging from time to time and suggested using oradebug utility to dump
the
process(i think it spawns a new smon automatically and kills the hung
process). After this all my queries on dba* views are
better. I have just taken over this database which runs 11i and the
pctincrease for system tablespace is 100 and the size
of it is around 4.3 GB. I was horrified and i thought the first job
for me will be to reorganize this. KIndly give your inputs. Some
tablespaces are dictionary managed but most are LMTs.Will the
following have performance impact? In case i have to rebuild these
objects which is the best method?

SUBSTR(SEGMENT_NAME,1,20)                   EXTENTS
---------------------------------------- ----------
SOURCE$                                        4572
IDL_UB1$                                       5179
IDL_UB2$                                       3370
I_SOURCE1                                      2166


Cheers,
Ashok