DX Infrastructure Manager

Expand all | Collapse all

oracle Probe - Query

  • 1.  oracle Probe - Query

    Posted 10-01-2012 10:02 PM

    Hi, 

     

    I dont know the oracle probe well, but my DBA team is saying they need to run a Oracle QUERY and I wnat to be able to store the data in QOS so I can display on a dashboard? how do I do it, I am sure its simple but i just keep hitting a wall. 

     

    -Ankit 



  • 2.  Re: oracle Probe - Query

    Posted 10-01-2012 10:55 PM

    I believe the SQL_Response probe is what you are looking for here.

     

    From the help file:

     

    Monitoring System Requirements
     
    The sql_response probe allows the user to monitor response of user defined queries for Oracle, SQL Server, Informix, DB2 and Sybase databases.



  • 3.  Re: oracle Probe - Query

    Posted 10-02-2012 04:18 PM

    yep sqlresponse I believe you will need the clients for oracle on the machine where you put the sql response probe.



  • 4.  Re: oracle Probe - Query

    Posted 10-02-2012 08:05 PM

    Thank you both for the quick reply I knew I was just missing something "simple" 

     

    Thanks again. 

     

     



  • 5.  Re: oracle Probe - Query

    Posted 10-09-2012 04:06 PM

    You could also query the oracle Db direct from the dashboard (via the UMP server). If you set up a datasource in the dap on the UMP server to connect to the oracle db then you can use this in your dashboards.