Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tablespace size. System data vs user data.

1041347Sep 18 2013 — edited Sep 18 2013

Hi,

I have Oracle 11.2.0.1 on Solaris 11 x86_64. Software using SYSTEM tablespace. The free space on this tablespace is allmost end,

When i check what amount of data is collected in database i get strange value:

select SUM(qq.MB) from (select table_name,(num_rows*avg_row_len)/(1024*1024) MB, num_rows, avg_row_len from user_tables) qq;

SUM(QQ.MB)

----------------------

6,43802738189697265625

So i suppose that data using only 6.4MB.... But statistic for this tablespace is

Tablespace Used MB Free MB Total MB Pct. Free

------------------------------ ---------------------- ---------------------- ---------------------- ----------------------

SYSAUX 655 35 690 5

UNDOTBS1 27 18 45 40

TQTBS 11 489 500 98

USERS 0 5 5 100

SYSTEM 707 93 800 12

What is using 700MB?!

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 16 2013

Added on Sep 18 2013

#general-database-discussions, #oracle

12 comments

684 views