Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from turing.freelists.org (turing.freelists.org [206.53.239.180]) by malta2546.startdedicated.com (Postfix) with ESMTPS id EF0B010135F026 for ; Tue, 10 Oct 2017 20:29:19 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9DC301AECA; Tue, 10 Oct 2017 14:29:18 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1507660158; bh=JW+H0q164Bgp66v6ZPznRGK9/GJ7ADuL8EbfXK0JjPo=; h=From:Date:Subject:To:Reply-To:List-help:List-unsubscribe:List-Id: List-subscribe:List-owner:List-post:List-archive; b=u/DFnocRLgPWC80UIW4qW9uvTOZ5Vppu3fBX+iMHQ4GzU1XGioJb7zjfoPtN/OuJg CUnFFAaX/wFEfqTfR71YRU0xz7Wr9NYhK9OM+lCzfOyTi5QD4sQQhal5RBA5mbPqiV BQQMulUlxboCEcGMeMIBxthBAQeQFer7Q4+l/Pmo= X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id CyKOH_HvpDNW; Tue, 10 Oct 2017 14:29:18 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BA3931AF4F; Tue, 10 Oct 2017 14:28:59 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1507660151; bh=JW+H0q164Bgp66v6ZPznRGK9/GJ7ADuL8EbfXK0JjPo=; h=From:Date:Subject:To:Reply-To:List-help:List-unsubscribe:List-Id: List-subscribe:List-owner:List-post:List-archive; b=J3o/3ntqmP/DtllcybcTl0ic7TJ+wDqn8tyLv3n/d3D1U+6GbujmefD8DBbAs5+XZ xiX1YuQmYGLtcF6JQHX+0rEMbFN+nrkFgqk/ogzweTa1LbITeMjPkYWVW98iS3MK4q JyulkTWSsQWx03jZXy6O+LTVra3xc/44aqHuem30= Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 10 Oct 2017 14:27:38 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1067C1AEDD for ; Tue, 10 Oct 2017 14:27:38 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id C2BMQmduI3I3 for ; Tue, 10 Oct 2017 14:27:38 -0400 (EDT) Received: from mail-wm0-f51.google.com (mail-wm0-f51.google.com [74.125.82.51]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id B67E81AEC9 for ; Tue, 10 Oct 2017 14:27:37 -0400 (EDT) Received: by mail-wm0-f51.google.com with SMTP id m72so7673715wmc.1 for ; Tue, 10 Oct 2017 11:27:37 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=go88X7pp3PCyzZcViISZVgjAzdYhg1+MESuO6sv2nIo=; b=SV2jnm1TBH+e2WN0L13p0pf3M8ATj+/ph7IF8Yo0wqtoWl/w7leKWpf9oXZ2Ynuve9 mPxWsNeln9rN20jAa3ZAvz0IZpRJt26ACeOvZk7BJBgA6pFVrGENtGA8RAc1CL9wdY7z tYpml3w8o9FJ8l0OBuX8m3yb8CdxphMcgaYvSclYsPjnaqxxXy7eZSr8Li10CyqzVxFO DfRlg/R/KpkU3aLV/PO2I4GMy2Zibsb5yH2xgNqgABqFx02TYt9Fv+zT/z/tfy0KNq3b MmEZaZG0+V2vnrwlW828iNmQWDq9j4VUf7Lp4BZgIOOn33K0y7Bods0RU/fHqKoWjveI XPaw== X-Gm-Message-State: AMCzsaXig23bm4foi4K6qofuC2X5gYKqFq//wdBZ8cC+r0xDLwaACaz+ E97iDjFbCJRaApQ9VyAf9lA9uk/XHyeOxdhZiQTzlQ== X-Google-Smtp-Source: AOwi7QA7Evh/JhhKeY2M+x8t6aSPwa9tRiqlZiq8EM+cnoa0i7V4LeLCCxREnuuGhkeMqlPZk4WSHA81EzepMwG2qVM= X-Received: by 10.80.173.185 with SMTP id a54mr18632880edd.70.1507660056229; Tue, 10 Oct 2017 11:27:36 -0700 (PDT) MIME-Version: 1.0 Received: by 10.80.205.6 with HTTP; Tue, 10 Oct 2017 11:27:35 -0700 (PDT) From: Michael Calisi Date: Tue, 10 Oct 2017 14:27:35 -0400 Message-ID: Subject: Redo Generation To: Oracle-L Freelists Content-Type: multipart/alternative; boundary="94eb2c0df9e017fa7a055b357628" X-archive-position: 69513 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: oracle455@gmail.com Precedence: normal Reply-To: oracle455@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --94eb2c0df9e017fa7a055b357628 Content-Type: text/plain; charset="UTF-8" Is there a way to determine how much redo will be generated by a particular sql stmt? I have some sql stmt that generate GIGS of redo, and if would be nice know before it runs. -- --94eb2c0df9e017fa7a055b357628 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Is there a way to determine how much red= o will be generated by a particular sql stmt?

I have some sql st= mt that generate GIGS of redo, and if would be nice know before it runs. --

--94eb2c0df9e017fa7a055b357628-- -- http://www.freelists.org/webpage/oracle-l