DBACockpit hangs

[Former Member]

Hi Everybody

I am having a strange issue with DBACockpit. I would like to see the "Performance -> SQL Statement Analysis -> Table Access" monitor.

For some reasons the monitor never loads it hangs and nothing happens. Every other parts of the DBACockpit just works fine. In SM50 I can see the following:

Last SQL statement

SELECT

inst_id, owner, object_name, statistic_name, value

FROM

gv$segment_statistics

WHERE

object_type = 'TABLE'

ORDER BY

inst_id, owner, object_name, statistic_name

This is the phase when it always hangs.

We have regular statistics on the DB. Does not seem to exist any OSS Note about this particular issue.

SAP ECC6.0 (with SAP_BASIS component on level 15)

Anybody has an idea?

Cheers

[Former Member]

Hi,

I applied the notes and nothing happened.

I just stopsap (r3 and database) and then started and it works.

Regards

[Former Member]

Hi Gergely,

check this note:SAP Note 984955 - Timeout with selection of V$-Views and apply

Because i faced this problem long back,and the problem gets sloved after applying this note.

Thanks,

Best Regards,

Shyam Dontamsetty

[nishikant_kulkarni2]

Anything in system logs ?

-Nishikant

[Former Member]

Hi Gergely Cserdi,

I have exactly the same error just on one system of the landscape.

Did you resolved this problem?

How?

Thank you for your answer.

Kind regards

Philippe

[Former Member]

Could be related to the problems described in Note 871455 - Poor performance when accessing DBA and V$ views.

In this case your best bet will be an upgrade of Oracle and/or SAP release.