Database Administration (MOSC)

MOSC Banner

OUTLN Schema

edited Nov 30, 2008 3:49PM in Database Administration (MOSC) 1 comment
Dear All,

select OWNER,
SEGMENT_NAME,
SEGMENT_TYPE,
TABLESPACE_NAME,
BYTES
from dba_segments
where TABLESPACE_NAME = 'SYSTEM'
and OWNER not in ('SYS','SYSTEM')
order by OWNER, SEGMENT_NAME

When I ran the above statement I have found that OUTLN owner is there in the System Tablespace.  I have seeing my System Tablespace is too large and used heavyly with 99%  and data of Outln schema in System Tablespace is

OWNER    SEGMENT_NAME                               SEGMENT_TYPE                 TABLESPACE_NAME  BYTES

OUTLN       OL$                                                         TABLE                                      SYSTEM                     65536
OUTLN       OL$HINTS                                             TABLE                                      SYSTEM                    65536
OUTLN      OL$HNT_NUM                                       INDEX                                       SYSTEM                    65536
OUTLN      OL$NAME                                              INDEX                                      SYSTEM                    65536
OUTLN       OL$NODES                                          TABLE                                      SYSTEM                    65536

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center