Forum Stats

  • 3,825,945 Users
  • 2,260,582 Discussions


Problems updating the table with too many data volumes

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
    EdStevens Member Posts: 28,778 Gold Crown

    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.bytes / 1024/1024/1024 gbytes,
    from dba_segments s
    join dba_data_files f 
     on s.tablespace_name = f.tablespace_name;