Custom extension

[nikhil]

Hi all,

I am trying to build an custom extension for getting the queries executed on database. Can anyone pls help me out with any sample template of YAMl file ? Or can anyone pls guide the parameters for sqlOracle in custom extension ?

I have done as following and it is not working. Please guide me where i am wrong

sqlOracle:

  - group: Top queries

    featureSet: "Top queries"

    interval:

      minutes: 1

    ingest: log

    query: >

      SELECT

      *

      FROM

      (SELECT sql_text AS "Queries" FROM sys.v_$sqlarea)

      WHERE ROWNUM < 21

    metrics:

      - key: oracle.queries.extension.oracle-top-queries

        value: col:Queries

    dimensions:

      - key: Queries

        value: col:Queries

[Mike_L]

Hi,

Our out of the box extension already does this, so you can grab that one as a base. Just go to the hub: https://www.dynatrace.com/hub/detail/oracle-database/#release-notes , expand one of the versions and download it. You can then open the extension.yaml file and search for topN.

[rudy_h]

When will you provide virtual Hands on Training Session on how to expand versions of Oracle and SQL Server extensions?

Best Regards.

Rudy