Forum Stats

  • 3,769,471 Users
  • 2,252,969 Discussions
  • 7,875,044 Comments

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

Answers

  • EdStevens
    EdStevens Member Posts: 28,525 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.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;