DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: system tablespace is full

  1. #1
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Hi Friends,
    I'm facing some problem in my Oracle 8.1.6 database which is running on Sun SPARC Solaris server.
    OEM shows rthat the system tablespace is full. All of my processes are running very slow, even a simple query will take a lot of time. Sometimes my front end applications are not able to connect to the database. Pz tell me whether this is because there is no space in system tablespace or what??
    What is solution of the problem. Can I add one more datafile in my system tablespace or is there any other solution of this problem?? Plz tell me the solution.
    Thanks in Advance
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    well you can simply resize the system datafile, see if it goes quixker then - bet it will :-)

  3. #3
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Thanks davey23uk, I'm working on this...hope it should solve my problem.
    Once again thanks a lot.
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You can add a datafile to SYSTEM tablespace but I would suggest to investigate what is making it full.
    SYSTEM tablespace should not grow much if you have no user objects in it and auditing is not turned ON.

    Sanjay

  5. #5
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    prompt
    prompt Objects existing in the SYSTEM tablespace
    prompt -----------------------------------------
    pause

    prompt Objects other than those owned by SYS or SYSTEM should exist in
    prompt their own tablespace

    col Owner format a17 heading 'Owner'
    col ob_type format a4 heading 'Type'
    col ob_name format a30 heading 'Object'
    col size_m format 990.90 heading 'Size M'

    break on owner nodup skip 1 on report
    compute sum of size_m on owner report

    select owner, decode(substr(segment_type,1,3), 'TAB', 'Tbl:',
    'IND', 'Idx:',
    substr(segment_type,1,3)||':') ob_type,
    segment_name ob_name, bytes/(1024*1024) size_m
    from dba_segments
    where tablespace_name = 'SYSTEM'
    and owner not in ('SYS', 'SYSTEM')
    order by 1,3
    /
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  6. #6
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Thanks a lot Sureshy for the script...
    "Greatest Rewards come only with Greatest Commitments!"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width