Timeline for Oracle nologging impact for REDO Generation
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 12:40 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| Jan 9, 2015 at 8:04 | comment | added | Suresh Gautam | I learn totally new thing from your last comment though it's feasible to apply in my context immediately. Thanks Again. | |
| Jan 9, 2015 at 8:04 | vote | accept | Suresh Gautam | ||
| Jan 9, 2015 at 7:42 | comment | added | Jon Heller |
You can use reference partitioning to avoid the limitations on foreign keys. But that's such an unusual feature it would be a risky workaround. Note that the constraint is more damaging than the index - the foreign key constraint both stops direct path and prevents parallelism. If possible, you can simply drop some foreign key constraints. If you must keep them, it would be faster to drop and re-create them. You can use some tricks like RELY and rebuild to recreate a foreign key constraint in parallel. Indexes can be rebuilt in parallel nologging and switched back to noparallel.
|
|
| Jan 9, 2015 at 7:38 | history | edited | Jon Heller | CC BY-SA 3.0 |
added 90 characters in body
|
| Jan 9, 2015 at 6:16 | comment | added | Suresh Gautam | It's conformed that there are no issue with #2, #3, #4 and #5, all INSERT statements are direct-path enabled and generating REDO LOGs because of associated foreign key indexes enabled on the target table. Additional Question - any feasibility to bypass for indexes enabled on the target table? | |
| Jan 8, 2015 at 5:26 | comment | added | Suresh Gautam | Thanks Jon for the comprehensive response, really appreciated. Based on the Full and Hourly AWR report, most of the top statements are all CTAS or Insert /*+ APPEND */ as you have suspected and they are leading to direct path with few exception. I am working for those exception SQLs so that REDO Logs can be reduced, will work with you guys if need further support. | |
| Jan 6, 2015 at 16:12 | history | edited | Jon Heller | CC BY-SA 3.0 |
deleted 63 characters in body
|
| Jan 6, 2015 at 11:37 | history | migrated | from stackoverflow.com (revisions) | ||
| Jan 6, 2015 at 9:40 | history | answered | Jon Heller | CC BY-SA 3.0 |