Oracle recommends this technique whenever you are updating a lot of data. Group sets of rows in the table into smaller chunks.Īpply the desired UPDATE statement to the chunks in parallel, committing each time you have finished processing a chunk. The DBMS_PARALLEL_EXECUTE package lets you incrementally update the data in a large table in parallel, in two high-level steps: Result Caches in Oracle RAC Environment Are No Longer Private
The PL/SQL features for Oracle Database 11 g Release 2 are:ĪLTER TYPE Statement Restrictions for Editioned ADTsĪutomatic Detection of Data Sources of Result-Cached Function PL/SQL Features for Oracle Database 11 g Release 2
0 kommentar(er)
