Oracle DB Alert in DB02

[Former Member]

Hi All,

We have upgraded our oracle database from 10.2.0.4 to 11.2.0.2 and everything is working fine till now.

Few days back we have found that there are certain error messages which has popup on DB02.

1. Most allocated extend in any segment 1555 > 200

2. Buffer cache which shows that 56 < 80 %.

How can we fix this error?

Thanks,

[Former Member]

Hi Rableen,

>> 1. Most allocated extend in any segment 1555 > 200

If the tablespaces are LTMS, you can ignore it. Read the Note 599694 - LMTS autoallocate: Extent allocation

>> 2. Buffer cache which shows that 56 < 80 %.

There can be several reasons, such as not enough database cache size or executing different select statements which does not hit the buffer cache. At the first step, try to increase db_cache_size parameter, restart the database. Then, monitor the value in daily basis. Additionally, you can find the reference value from advisory on ST04 -> SGA Monitor

Best regards,

Orkun Gedik