Oracle DBA Tools for NW Systems ( ABAP +JAVA)

[former_member160248]

Hi,

We have installed PI/XI ( ABAP + JAVA). i have the following questions.

1)Like SE11, is any tool SAP supplies to maintain JAVA dictionary objects( belonging to SAPSR3DB)?.

2)Like ST05->Analysis of SQL statement, is any tool SAP supplies to get the explain plan for SQL statements related to SAPSR3DB tables?.

3)Apart from BR* tools and DBACOCKPIT, what are the SAP tools available for administrate Java(Oracle) dictionary objects?.

Thanks in advance.

Thanks.

Raj.

[stefan_koehler]

Hello Raj,

1) No there isn't any tool like that as far as i know

2) You can perform a SQL trace with the OpenSQL monitor or the Wily Interscope agent (which i would recommend). After you have identified the expensive SQL statements you can perform an EXPLAIN PLAN in SQL*Plus or Oracle SQL Developer (free tool). The Java stack is not so comfortable as the ABAP stack in this area.

-> http://help.sap.com/saphelp_nw04/helpdata/en/24/d4ff0eccf33a49a5c26a280a119b14/content.htm

3) I don't know any ... in a Java Stack you need to know what you are doing.

Regards

Stefan