DB details in Java stack

[Former Member]

Hi All.

Can someone explain how to check the DB buffer information like DB buffer size and quality in JAVA stack system.

Also what is the script to find the SQL statement that use excessive buffer gets leads to high CPU utilization on oracle.

Thanks

[fidel_vales]

Hi,

As it was mentioned, you should connect the DBACOCKPIT from an ABAP instance. But, FYI, the "buffer quality" is a very old and useless method to evaluate the performance of any DB instance. If you think you have DB problems I advice you to use more "modern" techniques, like wait events, db time and such

[divyanshu_srivastava3]

Hi Sathish,

The simplest way is to use your solution manager system to monitor all non-ABAP/Java databases.

You need to connect your PI system to solman and then in DBACOKPIT you can find most of the information that you have been looking for.

To do this, you have several possible ways - you can either go for a classical connection or add your system in MAI of solman.

Now for eg, you may refer SCN wiki -

Additionally, read SAP KBA for the same purpose.

1139623 - Using transaction RZ20 to monitor remote Oracle databases

1261329 - DBA Cockpit: Oracle as a remote database

1540222 - DBA Cockpit: Monitoring non-ABAP/Java Oracle databases

1265134 - DBA Cockpit: Connecting a remote database

Regards,

[Reagan]

If there is an ABAP stack system then configure DBACOCKPIT for the remote database so you can monitor the database from the ABAP stack.

Read the note 1261329 - DBA Cockpit: Oracle as a remote database

RB

[Former Member]

Hi,

Thanks for the reply. this is pure java stack system with usage type as PI java.

Thanks