Miro is working slow

[Former Member]

Dear All,

I am working SAP ECC6.0 and my database is 10 G.My users are facing problem when they are running MIRO transaction because it is taking around 25 minutes.When i am in checking st03 Miro transaction is taking time in DB access.

So i Checked st04 and here database buffer quality is 49 % but DD cache quality is + 90 %. Is the problem is because of database buffer quality?

How can I improve Database buffer quality ?

When i am checking in initSID.ora parameter file db_cache_size=641728512 , sga_max_size=1283457024 , shared_pool_reserved_size=64172851 , shared_pool_size=641728512 .

RAM in the server is 8 GB.

Thanks

Mohanti

[Former Member]

issue resolved by applying creating new index for MSEG

[Former Member]

Increase db_cache_size upto 2GB atleast

Regards

Nick Loy

[former_member204746]

increase db_cache_size to a higher value.

search SAP notes about MIRO performances, this is a known issue.