1

Topic: Top requests on generation redo

I welcome!
On one DB from a heap of the same there is a big generation redo.
At data volume of 55 Gb for day of operation 400 Gb  are generated.
How to learn, what requests more all generate redo?
Oracle 10g / sles 11

2

Re: Top requests on generation redo

lYY;
What to you answered in Oracle technical support?

3

Re: Top requests on generation redo

And here technical support? Broke nothing.

4

Re: Top requests on generation redo

lYY wrote:

And here technical support? Broke nothing.

it is daily generated much REDO.
It seems to you that in it there is a problem.
You want to clarify what commands cause generation of great volume REDO.
As to make it you do not know, therefore address in technical support.
It is normal.
Want to wait, when something breaks?
If money is paid them, let works.

5

Re: Top requests on generation redo

lYY;
To look awr. It is possible   and to look that so actively changes.

6

Re: Top requests on generation redo

env wrote:

to Look awr.

I tried, but did not understand, in what there sections to look?
SQL Statistics
SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count

7

Re: Top requests on generation redo

lYY;
To begin with - to look in section Segments by Physical Writes

8

Re: Top requests on generation redo

And adjacent with it. And then already to look, what requests change/add/delete the data in these objects.
Can at you  everyone  in the separate table. Or on the contrary time ten minutes is updated completely one huge table.
Or you have any durable not complete transaction with a heap of little changes.

9

Re: Top requests on generation redo

lYY wrote:

And here technical support? Broke nothing.

Google did not try to use?
The first link:
http://www.dba-oracle.com/t_find_sessio … h_redo.htm

10

Re: Top requests on generation redo

env wrote:

lYY;
To begin with - to look in section Segments by Physical Writes

In ten probably there is no such:
Segment Statistics
Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

11

Re: Top requests on generation redo

Thanks!

12

Re: Top requests on generation redo

Q.Tarantino wrote:

it is passed...
Google did not try to use?
The first link:
http://www.dba-oracle.com/t_find_sessio … h_redo.htm

Gives only  statistics unfortunately

13

Re: Top requests on generation redo

ora601 wrote:

it is passed...
Gives only  statistics unfortunately

So to it of it for eyes. At it it is constant  generation , to catch the moment it is not necessary...

14

Re: Top requests on generation redo

Q.Tarantino wrote:

it is passed...
So to it of it for eyes. At it it is constant  generation , to catch the moment it is not necessary...

Well can night  for example...)

15

Re: Top requests on generation redo