Is currently the source table the amount of data that is 10 t, partition is not good, so you need to extract data from this table, the detected results are modified sqlnet. Expire_time values, feel no effect, the bosses provide a solution
CodePudding user response:
The mean timeout? This situation is not very good way to try to split the original data, and do not necessarily need to partition, can use index, of course, to ensure that each access to data is not too much, cause inefficient index scan,CodePudding user response:
Still have a kind of method, complex, with the aid of dba_extents in fields, records generated rowid, through the rowid segmentation to visit again after the original table,