on 01-13-2021 8:29 AM
Hi,
More redo log data is accumulated during peak times in dialog mode or during a batch job involving many
changes than during times of low system activity.
Long or frequently executed INSERT, UPDATE or DELETE operations can cause exceptionally high occurrence of redo logs.
You can also check SAP Note 584548 - Unusually high number of redo logs (especially point 4)
Regards,
Bíborka
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear biborka
Thank you for your suggestion, I 've run command SQL ;
SELECT * FROM
(SELECT SUBSTR(SQL_TEXT, 1, 64), ROWS_PROCESSED
FROM V$SQL
WHERE ( UPPER(SQL_TEXT) LIKE 'INSERT %' OR
UPPER(SQL_TEXT) LIKE 'UPDATE %' OR
UPPER(SQL_TEXT) LIKE 'DELETE %' ) AND
ROWS_PROCESSED > 0
ORDER BY ROWS_PROCESSED DESC)
WHERE ROWNUM <= 20;
, It show output as picture below. What is the meaning of this command?
Hi,
I recommend to use Oracle AWR and ASH with a very small granularity to check if there is an unusual high amount of modification made during this time. More redo information means more changes done on the DB.
Regards,
János
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Below SAP document contains the steps to generate AWR and ASH from DBACOCKPIT.
1738665ASH and AWR report creation in SQLPLUS and DBACOCKPITI hop this helps.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.