Problems updating the table with too many data volumes

User_GZOVT

I have a table that per day has a base of 16,836,155 data per day. When I reached a base of 973,902,982 in two months I can't update the table anymore, even after 1 day.

I wanted to know if the volume of data that is in my table

 is impacting the insertion of data in my table.

Note: I have no exception about Table Space handled

EdStevens

I can't update the table anymore,

If you "can't update the table anymore", then you must be getting _some_ error. So what is it? "can't update the table" is totally devoid of actionable information.

Show us the following:

select s.owner,
      s.segment_name,
      s.tablespace_name,
      s.bytes / 1024/1024/1024 gbytes,
      f.file_name,
      f.maxbytes
from dba_segments s
join dba_data_files f 
 on s.tablespace_name = f.tablespace_name;