system TS size ??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: system TS size ??

  1. #1
    Join Date
    Nov 2000
    Posts
    198
    what is the average size for a system tablespace ? and how much should I sized the datafile (system)?.
    mine is almost 500MB (trying to clean it up) !!!!!!!!! I have alot of non system objects.

    thanks,

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    there isnt an average, it depends database size, if you have tons of objects then obviously system would be bigger.
    your problem is there are people using the tablespace system when only user SYS is the only onw allowed to use it

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