CMFK/CMFP table performance issue

[Former Member]

Hello All,

We have a performance issue Bcoz of table CMFK/CMFP. A huge amount of data is updated in these tables for applid = 'KKS'.We found a note to archive this table of old data. We would like to know is there any way to deactivate the logging of data to these tables from applid = 'KKS'( Variance : collective processing).

Thanks and regards,

[fidel_vales]

>

> Hello All, 
> 
> We have a performance issue Bcoz of table CMFK/CMFP. A huge amount of data is updated in these tables for applid = 'KKS'.We found a note to archive this table of old data. We would like to know is there any way to deactivate the logging of data to these tables from applid  = 'KKS'( Variance : collective processing). 
> 
> Thanks and regards,

do you have a car?

do you go to the technician and tell him "it does not work, repair it"?

no?

I assume that you would provide more information.

This is the Database Forum, the statement provides absolutely no information. Any advise would be a pure guessing and probably useless.

Please, provide proper information

1) DB release, patch set and optimizer merge fix installed

2) optimizer parameters

3) statement (I assume you are talking about UPDATE)

4) access path chosen by Oracle

5) indexes available (with details as fields and statistics)

6) runtime statistics (you can get them from the sqlcache)

when you talk about logging data, I assume it is NOT oracle logging. In that case, that question do not belong to this forum.

if you are talking about Oracle logging, it is not possible to do that.