cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Oracle Log archive growth abnormal same time every days

former_member680032
Participant
0 Kudos

Dear All,

I have a problem about Oracle Log archive growth abnormal same time every days. Can you suggest about filter column on T-code ST03 or another check this problem?

Best Regards,

Maitree Sodsee

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member207186
Contributor
0 Kudos

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

former_member680032
Participant
0 Kudos

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?

0 Kudos

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

former_member680032
Participant
0 Kudos

Dear janos.mucsi-besze

Thank you for your suggestion, I have only authen by SAP LogOn. Can you suggest me about trace by SAP T-code ?

Regards,

Maitree

0 Kudos

Below SAP document contains the steps to generate AWR and ASH from DBACOCKPIT.

1738665ASH and AWR report creation in SQLPLUS and DBACOCKPIT

I hop this helps.