SQL Statements responsible for huge redo generation

From: Goti <aryan.goti_at_gmail.com>
Date: Tue, 5 Oct 2021 17:25:10 +0530
Message-ID: <CAOzfMurDBa+KWeRpkRbpJJKOkNf49GVSLJ26jrhSXEMjsEp4PQ_at_mail.gmail.com>

Hi All,

Is there a way from AWR historic views we can identify the SQL statements /SQL_ID causing huge redo generation?

The database is of version 11.2.0.4.

Thanks,

Goti

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

Received on Tue Oct 05 2021 - 13:55:10 CEST

This message: [ Message body ]
Next message: Seth Miller: "Block Identifiers in Multitenant Databases"
Previous message: Laurentiu Oprea: "Re: hash join cardinality missestimate"
Next in thread: Jonathan Lewis: "Re: SQL Statements responsible for huge redo generation"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message