1. first expand your undo_retention parameter : alter system set undo_retention=86400; expand all undo datafiles alter database datafile 'undofile' resize BIGGER_SIZE; the first step avoid undo extent reused by system 2. we will provide procedure better_flashback_table_query , check how many...
An Oracle 11.2.0.4.7 4-nodes RAC on linux env, the fourth instance has this problem just, When the monitoring tool queries the usage of ASM DISKGroup, the query of V$asm_disk and v$asm_diskgroup has not been completed. from ASM INSTANCE found that waiting for ‘enq: DD – contention’...
1. Can we able to unload the recovered data beginning from the last happened data(or based on a date). 2. Need more clarification on the term per data base licensing .For e.g.: our company having 3 distributed Oracle DB instances, but we use the same “Net Service Name” for all ,...
1. first expand your undo_retention parameter : alter system set undo_retention=86400; expand all undo datafiles alter database datafile 'undofile' resize BIGGER_SIZE; the first step avoid undo extent reused by system 2. we will provide procedure better_flashback_table_query , check how many...