question

広志 北. avatar image
広志 北. asked ·

About "Oracle database insight(EAP)"

Hi all,

My customer is very interested in the following "Oracle database insight".

<Oracle database insights now available (EAP)>

https://www.dynatrace.com/news/blog/oracle-database-insights-now-available-eap/

He would like to utilize the Oracle data collected by Dynatrace for Oracle performance management. And he would like to know what kind of Oracle data can be collected before applying for EAP.

So, in the Oracle data collection announced on the above blog, does anyone have a data item list of what kind of data can be collected at the present time?

database
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Jakub M. avatar image
Jakub M. answered ·

Hi, we collect performance metrics from v$ tables, sql statements form cache, explain plans. Till Beta we will add wait and Oracle events.

2 comments Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Hi Jakub,
Thank you for the reply. The information you gave me is very helpful.

For your reference, I will attach a list of requests for Oracle data collection from my customer. His hope is to be able to capture these Oracle data items. For data items not supported by Dynatrace, I will plan to create plugins and deal with them.
If possible, could you please refer the file for the function extension?
Incidentally, the customer is a major airline company in Japan.
Best regards,
oracledatacapture-requirements-list.xlsx

1 Like 1 · ·

Likely to give more explanation about Application Wait Time?, in deeper way, such as wait for what, what does Application here mean, etc.

0 Likes 0 · ·
Joe H. avatar image
Joe H. answered ·

Hiroshi,

The list of data collected is constantly growing and being developed based on the communities needs. So it is recommended to have your customer apply for the EAP, and fill out the survey and contribute to the direction and decision of upcoming metrics list.

The metrics will be very similar to what is provided by the AppMon Oracle agent: Sessions, Wait States, Slow Queries, Current Locks, Explain Plans, etc. A better 'target' of the full list of metrics can be deduced from the AppMon list: https://community.dynatrace.com/community/pages/vi...

1 comment Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Hi Joseph,
Thank you for the reply and recommendation!
I will consider my customers applying for EAP.

0 Likes 0 · ·