{"id":46799,"date":"2026-09-18T18:00:33","date_gmt":"2026-09-18T16:00:33","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=46799"},"modified":"2026-09-18T18:00:35","modified_gmt":"2026-09-18T16:00:35","slug":"listing-and-querying-oracle-enterprise-manager-metric-extensions","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/","title":{"rendered":"Listing and Querying Oracle Enterprise Manager Metric Extensions"},"content":{"rendered":"\n

I recently wanted to work on Metric Extensions automation, and realized the task was a bit more complicated than I thought. My original idea was to look into the emcli<\/code> verb list, but I was unlucky. In fact, emcli<\/code> does not allow you to retrieve information about Metric Extensions.<\/p>\n\n\n\n

$ emcli help | grep -i metric_extension\n    export_metric_extension           -- Export a metric extension to an archive file\n    get_unused_metric_extensions      -- Get a list of unused metric extensions\n    import_metric_extension           -- Import a metric extension archive file\n    publish_metric_extension          -- Publish a metric extension for use by all administrators\n    save_metric_extension_draft       -- Save a deployable draft of a metric extension<\/code><\/pre>\n\n\n\n
I had to dig further, looking into the Enterprise Manager SYSMAN<\/code> schema.<\/p>\n\n\n\n
Metric extensions are not stored under MGMT$<\/code> views<\/h2>\n\n\n\n
At first, I checked in the MGMT$<\/code> views, in the SYSMAN<\/code> schema. They usually hold all the relevant information you need when doing automation with the Enterprise Manager. The documentation gave me nothing about Metric Extensions there, and I did not find anything either:<\/p>\n\n\n\n
SQL> SELECT owner, object_name, object_type\nFROM dba_objects\nWHERE owner = 'SYSMAN'\nAND UPPER(object_name) LIKE '%EXTENSION%'\nORDER BY object_name;\n\nOWNER   OBJECT_NAME        OBJECT_TYPE\n------- ------------------ ------------\nSYSMAN  EM_TYPE_EXTENSION  PACKAGE\nSYSMAN  EM_TYPE_EXTENSION  PACKAGE BODY<\/code><\/pre>\n\n\n\n
After a lot of searching, I found the undocumented MEXT<\/code> views, where all the information on Metric Extensions is stored<\/strong>.<\/p>\n\n\n\n
SELECT owner, object_name, object_type\nFROM dba_objects\nWHERE object_name LIKE '%MEXT%'\nAND object_type IN ('TABLE', 'VIEW')\nORDER BY object_name;<\/code><\/pre>\n\n\n\n
This query returns more than a hundred objects. Among them, you can find a EM_MEXT_VERSIONS<\/code> table.<\/p>\n\n\n\n
EM_MEXT_VERSIONS<\/code> is the catalog<\/h2>\n\n\n\n
EM_MEXT_VERSIONS<\/code> has one row per Metric Extension. Drafts, editable versions and published metrics are all stored here, with the same name<\/code> column.<\/p>\n\n\n\n
SQL> DESC sysman.em_mext_versions\n\nName             Null?     Type\n---------------- --------- -------------\nMEXT_VERSION_ID  NOT NULL  NUMBER\nTARGET_TYPE      NOT NULL  VARCHAR2(256)\nNAME             NOT NULL  VARCHAR2(64)\nVERSION          NOT NULL  NUMBER\nDISPLAY_NAME     NOT NULL  VARCHAR2(64)\nSTATUS           NOT NULL  NUMBER(2)\nCREATION_DATE              DATE\n...<\/code><\/pre>\n\n\n\n
Using a few useful columns, let\u2019s see what\u2019s inside:<\/p>\n\n\n\n
SQL> SELECT name, version, display_name, target_type, status, creation_date\nFROM sysman.em_mext_versions\nORDER BY name, version;\n\nNAME                           VERSION  DISPLAY_NAME          TARGET_TYPE  STATUS  CREATION_DATE\n------------------------------ -------- --------------------- ------------ ------- -------------\nME$minimal_uptime_check        1        Minimal Uptime Check  host         2       24-AUG-26\nME$minimal_uptime_check        2        Minimal Uptime Check  host         2       24-AUG-26\nME$minimal_uptime_check_clone  1        Minimal Uptime Check  host         2       24-AUG-26<\/code><\/pre>\n\n\n\n
Every Metric Extension name starts with the ME$<\/code> prefix. If you ever created a Metric Extension by hand in the web UI, the prefix is automatically added in the creation wizard. Regarding the status<\/code> column, they are defined in the SYSMAN.EM_MEXT<\/code> package:<\/p>\n\n\n\n
    \n
  • 0 – MEXT_STATUS_EDITABLE<\/code><\/strong>: for Metric Extensions still under development. They can still be edited, but can\u2019t be deployed to targets.<\/li>\n\n\n\n
  • 1 – MEXT_STATUS_DEPLOYABLE_DRAFT<\/code><\/strong>: for Metric Extensions which can\u2019t be edited anymore, but can be deployed. Accessible only to you.<\/li>\n\n\n\n
  • 2 – MEXT_STATUS_PUBLISHED<\/code><\/strong>: for published Metric Extensions, accessible by any EM user.<\/li>\n<\/ul>\n\n\n\n
    Every row above shows status = 2<\/code>, meaning that all versions were published.<\/p>\n\n\n\n
    You can of course combine multiple SYSMAN<\/code> views to retrieve the list of Metric Extensions and the targets they are deployed on:<\/p>\n\n\n\n
    SQL> SELECT t.target_name, t.target_type, v.name AS metric_name, v.version, v.display_name AS metric_display_name\nFROM sysman.em_mext_versions v\nJOIN sysman.em_mext_target_assoc ta ON ta.mext_version_id = v.mext_version_id\nJOIN sysman.mgmt$target t ON t.target_guid = ta.target_guid\nORDER BY t.target_name, v.name, v.version;\n\nTARGET_NAME  TARGET_TYPE  METRIC_NAME              VERSION  METRIC_DISPLAY_NAME\n------------ ------------ ------------------------ -------- --------------------\nvmogg        host         ME$minimal_uptime_check  1        Minimal Uptime Check\n...<\/code><\/pre>\n\n\n\n
    How to know what a Metric Extension runs ?<\/h2>\n\n\n\n
    If a Metric Extension runs plain OS commands, querying SYSMAN.EM_MEXT_VERSIONS<\/code> is enough to know everything about it. This becomes wrong if the Metric Extension carries a custom uploaded script or runs against the repository instead of a target. For these Metric Extensions, you should query SYSMAN.EM_MEXT_ATTACHMENTS<\/code>, where the FILENAME<\/code> gives you the name of the script being shipped with the metric:<\/p>\n\n\n\n
    SQL> DESC sysman.em_mext_attachments\n\nName             Null?     Type\n---------------- --------- -------------\nMEXT_VERSION_ID  NOT NULL  NUMBER\nFILENAME         NOT NULL  VARCHAR2(255)\nFILE_CONTENTS              BLOB<\/code><\/pre>\n\n\n\n
    I cloned ME$minimal_uptime_check<\/code> with Create Like<\/strong>, then in the Adapter step changed the command from a literal \/bin\/echo<\/code> to %perlBin%\/perl<\/code> running an uploaded script, referenced as %scriptsDir%\/uptime_check.pl<\/code>. Custom files are attached from the same step, in the Upload Custom Files<\/strong> panel:<\/p>\n\n\n
    \n
    \"\"<\/figure>\n<\/div>\n\n\n
    Once confirmed, the file shows up in the adapter\u2019s file list with its size, and gets packaged into the Metric Extension itself:<\/p>\n\n\n
    \n
    \"\"<\/figure>\n<\/div>\n\n\n
    Querying the repository afterward confirms it landed exactly where the package source implied:<\/p>\n\n\n\n
    SQL> SELECT v.name, v.version, a.filename, DBMS_LOB.GETLENGTH(a.file_contents) AS bytes\nFROM sysman.em_mext_versions v\nJOIN sysman.em_mext_attachments a ON a.mext_version_id = v.mext_version_id\nWHERE v.name = 'ME$script_uptime_check';\n\nNAME                    VERSION  FILENAME         BYTES\n----------------------- -------- ---------------- -----\nME$script_uptime_check  1        uptime_check.pl  39<\/code><\/pre>\n\n\n\n
    Retrieving the full metric definition<\/h2>\n\n\n\n
    There are a few other relevant LOB columns in SYSMAN.EM_MEXT_VERSIONS<\/code>: METADATA_DEFINITION<\/code>, COLLECTION_DEFINITION<\/code> and MEXT_ARCHIVE<\/code>. Selecting METADATA_DEFINITION<\/code> for minimal_uptime_check<\/code> returns the whole <Metric><\/code> definition as XML:<\/p>\n\n\n\n
    SQL> SELECT metadata_definition\nFROM sysman.em_mext_versions\nWHERE name = 'ME$minimal_uptime_check'\nAND version = 1;\n\n<Metric NAME=\"ME$minimal_uptime_check\" TYPE=\"TABLE\">\n    <Display>\n        <Label NLSID=\"NLS_METRIC_hostME$minimal_uptime_check\">Minimal Uptime Check<\/Label>\n        <Description NLSID=\"NLS_DESCRIPTION_hostME$minimal_uptime_check\">Minimal test ME - single OS command column, no credentials.<\/Description>\n    <\/Display>\n    <TableDescriptor>\n        <ColumnDescriptor NAME=\"value\" TYPE=\"NUMBER\">\n            <Display>\n                <Label NLSID=\"NLS_COLUMN_hostME$minimal_uptime_checkvalue\">Value<\/Label>\n            <\/Display>\n        <\/ColumnDescriptor>\n    <\/TableDescriptor>\n    <QueryDescriptor FETCHLET_ID=\"OSLineToken\">\n        <Property NAME=\"command\" SCOPE=\"GLOBAL\">\/bin\/echo<\/Property>\n        <Property NAME=\"scriptLoc\" SCOPE=\"GLOBAL\" OPTIONAL=\"TRUE\">%scriptsDir%<\/Property>\n        <Property NAME=\"args\" SCOPE=\"GLOBAL\" OPTIONAL=\"TRUE\">em_result=1<\/Property>\n        <Property NAME=\"delimiter\" SCOPE=\"GLOBAL\" OPTIONAL=\"TRUE\">|<\/Property>\n        <Property NAME=\"startsWith\" SCOPE=\"GLOBAL\" OPTIONAL=\"TRUE\">em_result=<\/Property>\n        <Property NAME=\"ENVEM_TARGET_NAME\" SCOPE=\"INSTANCE\" OPTIONAL=\"TRUE\">NAME<\/Property>\n        <CredentialRef NAME=\"OSCreds\"><\/CredentialRef>\n    <\/QueryDescriptor>\n<\/Metric><\/code><\/pre>\n\n\n\n
    A few observations here:<\/p>\n\n\n\n
      \n
    • FETCHLET_ID=\"OSLineToken\"<\/code> is the fetchlet<\/li>\n\n\n\n
    • command<\/code>, args<\/code>, delimiter<\/code> and startsWith<\/code> are the fields filled when creating the metric.<\/li>\n<\/ul>\n\n\n\n
      Another column, COLLECTION_DEFINITION<\/code>, gives the schedule of the Metric Extension. Here, it is set to run every 15 minutes, which is the default schedule for Metric Extensions.<\/p>\n\n\n\n
      SQL> SELECT collection_definition\nFROM sysman.em_mext_versions\nWHERE name = 'ME$minimal_uptime_check'\nAND version = 1;\n\n<CollectionItem NAME=\"ME$minimal_uptime_check\" UPLOAD=\"YES\">\n\t<Schedule>\n\t\t<IntervalSchedule INTERVAL=\"15\" TIME_UNIT=\"Min\"\/>\n\t<\/Schedule>\n\t<MetricColl NAME=\"ME$minimal_uptime_check\">\n\t<\/MetricColl>\n<\/CollectionItem><\/code><\/pre>\n\n\n\n
      Finally, MEXT_ARCHIVE<\/code> holds the whole archive as a single BLOB<\/code>. Exporting it to a file with UTL_FILE<\/code> gives us a .zip<\/code> file which holds the full definition of the Metric Extension. But you don\u2019t need to do all of this, because this is the exact same zip that emcli export_metric_extension<\/code> generates.<\/p>\n\n\n\n
      A side note on repository-side Metric Extensions<\/strong>, which can also be created from the web UI. For these, there are a few pre-requisites: TARGET_GUID<\/code> must be the first column<\/strong>, the query can only reference MGMT$<\/code> repository views (not other SYSMAN<\/code> tables), and it runs as the MGMT_VIEW<\/code> user.<\/p>\n\n\n\n
      Querying SYSMAN.EM_MEXT_VERSIONS<\/code> gives you the full SQL query, under the REPOS_SQL<\/code> column. Use IS_REPOSITORY<\/code> to filter repository-side Metric Extensions.<\/p>\n\n\n\n
      SQL> SELECT name, version, is_repository, repos_sql\nFROM sysman.em_mext_versions\nWHERE name = 'ME$sql_target_count';\n\nNAME                 VERSION  IS_REPOSITORY  REPOS_SQL\n-------------------- -------- -------------- --------------------------------------------------------------------------------------------\nME$sql_target_count  1        1              SELECT target_guid, target_type, 1 AS host_count FROM mgmt$target WHERE target_type = 'host'<\/code><\/pre>\n\n\n\n
      I hope this will help you navigate Metric Extensions outside of the web UI, for automation work. This gave us a first glimpse of the archive format, which deserves a closer look of its own.<\/p>\n","protected":false},"excerpt":{"rendered":"
      I recently wanted to work on Metric Extensions automation, and realized the task was a bit more complicated than I thought. My original idea was to look into the emcli verb list, but I was unlucky. In fact, emcli does not allow you to retrieve information about Metric Extensions. I had to dig further, looking […]<\/p>\n","protected":false},"author":152,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[59],"tags":[4214,4212,4213,761,96,2046,98],"type_dbi":[4216,4215,4217,4010,2728,4218],"class_list":["post-46799","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-emcli","tag-enterprise-manager-2","tag-metric-extension","tag-oem","tag-oracle","tag-query","tag-sql","type-emcli","type-enterprise-manager-3","type-metric-extension","type-oem","type-oracle","type-sql"],"acf":[],"yoast_head":"\nListing and Querying Oracle Enterprise Manager Metric Extensions - dbi Blog<\/title>\n<meta name=\"description\" content=\"emcli has no verb to list Metric Extensions. Query SYSMAN.EM_MEXT_VERSIONS instead, plus where uploaded scripts and repository SQL live.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Listing and Querying Oracle Enterprise Manager Metric Extensions\" \/>\n<meta property=\"og:description\" content=\"emcli has no verb to list Metric Extensions. Query SYSMAN.EM_MEXT_VERSIONS instead, plus where uploaded scripts and repository SQL live.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-18T16:00:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-18T16:00:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/09\/001_mext-upload-attachment-dialog-7f2a19-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"370\" \/>\n\t<meta property=\"og:image:height\" content=\"110\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Julien Delattre\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julien Delattre\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/listing-and-querying-oracle-enterprise-manager-metric-extensions\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/listing-and-querying-oracle-enterprise-manager-metric-extensions\\\/\"},\"author\":{\"name\":\"Julien Delattre\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\"},\"headline\":\"Listing and Querying Oracle Enterprise Manager Metric Extensions\",\"datePublished\":\"2026-09-18T16:00:33+00:00\",\"dateModified\":\"2026-09-18T16:00:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/listing-and-querying-oracle-enterprise-manager-metric-extensions\\\/\"},\"wordCount\":644,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/listing-and-querying-oracle-enterprise-manager-metric-extensions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/09\\\/001_mext-upload-attachment-dialog-7f2a19-1.png\",\"keywords\":[\"emcli\",\"enterprise-manager\",\"metric-extension\",\"OEM\",\"Oracle\",\"query\",\"SQL\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/listing-and-querying-oracle-enterprise-manager-metric-extensions\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/listing-and-querying-oracle-enterprise-manager-metric-extensions\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/listing-and-querying-oracle-enterprise-manager-metric-extensions\\\/\",\"name\":\"Listing and Querying Oracle Enterprise Manager Metric Extensions - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/listing-and-querying-oracle-enterprise-manager-metric-extensions\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/listing-and-querying-oracle-enterprise-manager-metric-extensions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/09\\\/001_mext-upload-attachment-dialog-7f2a19-1.png\",\"datePublished\":\"2026-09-18T16:00:33+00:00\",\"dateModified\":\"2026-09-18T16:00:35+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\"},\"description\":\"emcli has no verb to list Metric Extensions. Query SYSMAN.EM_MEXT_VERSIONS instead, plus where uploaded scripts and repository SQL live.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/listing-and-querying-oracle-enterprise-manager-metric-extensions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/listing-and-querying-oracle-enterprise-manager-metric-extensions\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/listing-and-querying-oracle-enterprise-manager-metric-extensions\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/09\\\/001_mext-upload-attachment-dialog-7f2a19-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/09\\\/001_mext-upload-attachment-dialog-7f2a19-1.png\",\"width\":370,\"height\":110},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/listing-and-querying-oracle-enterprise-manager-metric-extensions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Listing and Querying Oracle Enterprise Manager Metric Extensions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\",\"name\":\"Julien Delattre\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"caption\":\"Julien Delattre\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/juliendelattre\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Listing and Querying Oracle Enterprise Manager Metric Extensions - dbi Blog","description":"emcli has no verb to list Metric Extensions. Query SYSMAN.EM_MEXT_VERSIONS instead, plus where uploaded scripts and repository SQL live.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/","og_locale":"en_US","og_type":"article","og_title":"Listing and Querying Oracle Enterprise Manager Metric Extensions","og_description":"emcli has no verb to list Metric Extensions. Query SYSMAN.EM_MEXT_VERSIONS instead, plus where uploaded scripts and repository SQL live.","og_url":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/","og_site_name":"dbi Blog","article_published_time":"2026-09-18T16:00:33+00:00","article_modified_time":"2026-09-18T16:00:35+00:00","og_image":[{"width":370,"height":110,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/09\/001_mext-upload-attachment-dialog-7f2a19-1.png","type":"image\/png"}],"author":"Julien Delattre","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Julien Delattre","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/"},"author":{"name":"Julien Delattre","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"headline":"Listing and Querying Oracle Enterprise Manager Metric Extensions","datePublished":"2026-09-18T16:00:33+00:00","dateModified":"2026-09-18T16:00:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/"},"wordCount":644,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/09\/001_mext-upload-attachment-dialog-7f2a19-1.png","keywords":["emcli","enterprise-manager","metric-extension","OEM","Oracle","query","SQL"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/","url":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/","name":"Listing and Querying Oracle Enterprise Manager Metric Extensions - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/09\/001_mext-upload-attachment-dialog-7f2a19-1.png","datePublished":"2026-09-18T16:00:33+00:00","dateModified":"2026-09-18T16:00:35+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"description":"emcli has no verb to list Metric Extensions. Query SYSMAN.EM_MEXT_VERSIONS instead, plus where uploaded scripts and repository SQL live.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/09\/001_mext-upload-attachment-dialog-7f2a19-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/09\/001_mext-upload-attachment-dialog-7f2a19-1.png","width":370,"height":110},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/listing-and-querying-oracle-enterprise-manager-metric-extensions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Listing and Querying Oracle Enterprise Manager Metric Extensions"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e","name":"Julien Delattre","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","caption":"Julien Delattre"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/juliendelattre\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/46799","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/152"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=46799"}],"version-history":[{"count":3,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/46799\/revisions"}],"predecessor-version":[{"id":46986,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/46799\/revisions\/46986"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=46799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=46799"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=46799"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=46799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}