• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by Anoh B. · Jun 25, 2013 at 01:25 PM ·

Oracle Call Interface

The client has two Oracle Business Intelligence servers that make Oracle database calls thru the Oracle Call Interface (OCI). Unfortunately, the dynaTrace is blind to those calls and the Oracle database connections are not shown in the Transaction Flow dashlet. Moreover, there no JDBC API displayed in the API Breakdown dashlet.
Is there anything that can be done (i.e., sensors, etc..) that can make the Oracle database queries visible to dynaTrace (i.e., shown in the transaction Flow dashlet, etc...).

Regards,
Anoh Brou

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

4 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Alberto D. · Dec 01, 2014 at 11:24 PM

Hello,

I am testing Tuxedo Servers Instrumentation via ADK. I am able to see in the transaction flow, the service requests, the time spent, etc but I am not able to see the Database calls coming from Tuxedo servers (I just see these calls coming from Weblogic). 

The thing is that via Weblogic we use JDBC and Weblogic Agent Group has "JDBC" sensor pack associated. For ADK I just have activated "Agent Development kit" sensor pack. I am making Database calls using OCI (library libclntsh.so ). I am looking for something like "OCI Sensor Pack" but I don't meet it.

Do you know a way to get Database calls using OCI (not JDBC) via ADK?

Thanks in advance.

 

Alberto.

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image

Answer by Stefan G. · Jul 02, 2013 at 09:23 AM

Just had a short conversation with an ADK developer and we think it is better to go forward with the customer sensor pack. However by using the java calls to Siebel.dll we will not get any database attachments and therefore no information in the database dashlet. So they are only visible via the API. The queries are only visible if you capture them via method arguments.

  • stefan
Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image Anoh B. · Jul 02, 2013 at 03:34 PM 0
Share

Hello Stefan,
Thank you once again for the information. The issue is that I have never written a custom sensor pack. Would it be possible for the ADK developer to send me a version of the custom sensor pack? I can modify it as need be.

Regards,
Anoh

avatar image

Answer by Stefan G. · Jul 01, 2013 at 02:14 PM

Hi maybe a custom sensor pack which takes care of all java calls to the siebel.dll and marks them the desired API if these calls are made by native components you can still use the ADK for that I'll forward this information to a colleague of mine.

  • stefan
Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image Anoh B. · Jul 01, 2013 at 02:16 PM 0
Share

Thank you Stefan!

avatar image

Answer by Stefan G. · Jul 01, 2013 at 11:48 AM

Hi,

the OCI calls you are mentioning are they done via a java application where a java agent is injected? Additionally is OCI via JDBC used?

regards
Stefan

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image Anoh B. · Jul 01, 2013 at 02:08 PM 0
Share

Good morning Stephan,

The OCI calls are indeed made via a Java application where the agent is injected. The OCI via JDBC is not used. The call is made via a Siebel DLL. This process encapsulated all the Oracle calls, hence making them invisible to dynaTrace. I would like to know if there were any ways available to unravel the "blackbox".

Regards,
Anoh Brou

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

1 Person is following this question.

avatar image

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A