Often you may need to load data to the database under a different schema and different tablespace. With Oracle Data Pump all this is possible in a very simple way. Among the various options of the routine impdp you can find: REMAP_SCHEMA REMAP_TABLESPACE REMAP_SCHEMA allows us to load the exported objects under a…
Leggi tutto
First you have checked the size of each diagram so that you can understand how they guide the work of collecting statistics in order to make improvements on the performance of database Owner Objects size MB —————————— ———— ———— USER_BIG 386 74,516 PR2K 211 8,424 SAST 31 152 ASINT 28 85 APEX_030200 2,561 78…
Leggi tutto
Incremental statistics maintenance was introduced in Oracle Database 11g to improve the performance of gathering statistics on large partitioned table. When incremental statistics maintenance is enabled for a partitioned table, oracle accurately generated global level statistics by aggregating partition level statistics. Incremental statistics maintenance is supposed to yield the same statistics as gathering…
Leggi tutto
Commenti recenti