System tablespace 99.99% used!Urgent!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: System tablespace 99.99% used!Urgent!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    I have a problem:

    Working on Oracle v8i 8.1.6.0.0 with OS as NT!

    1.To-day when I saw my tablespaces status on DBA Studio,
    I noticed the following:

    a.Tablespace:System.
    size:245.500 m
    used:245.375 m
    used %:99.95%.

    b.Tablespace:BIAC(for users).
    size:370.000 m
    used:352.656 m
    used %:95.31%.

    c.Tablespace:USERS consists of two data Files.
    used %:56.5% for datafile01.dbf
    used%:0.9% for datafile02.dbf


    Now please tell me as to whether could I increase the System tablespace by adding another datafile(with autoextend feature on) as of now the system tablespace consists of just one datafile and is nearing 100% completion.

    Is Autoextend on recommended on the system tablespace like that of users tablespace.

    Earlier i had two users named X and Y both having their default tablespaces BIAC as above and temporary tablespaces TEMP.

    Now I have changed the above two users default tablespaces to USERS as there ain't enough spaces left on
    BIAC tablespace.

    What impact would this create on the DB!

    Please reply fast with precautionary steps!

    Looking for your reply!

    Take care.

    Amit.



  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Turn autoextend on for all your tablespaces. It is a heck of a lot easier adding a datafile than dropping a datafile that has been misallocated.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    New Year Greetings,

    1. The system tablesapce usage should not increase in first place. To avoid any downtime resize the SYSTEM TB datafile and to the foolwing checks..
    - Check none of the users have SYSTEM as default tablespace except SYS and SYSTEM.
    - Check for any user objects on SYSTEM tablespace. If there, move them to another tablespace.

    2. Changing the default tablespace wouldn't solve the problem if the tables already created in your BIAC tablesapce are expanding. Add a datafile or resize the existing datafile of the BIAC tablespace.

    Have fun..
    Sanjay

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