{"id":2381,"date":"2026-03-09T23:12:52","date_gmt":"2026-03-09T21:12:52","guid":{"rendered":"https:\/\/www.ludovicocaldara.net\/dba\/?p=2381"},"modified":"2026-03-09T23:12:52","modified_gmt":"2026-03-09T21:12:52","slug":"dg26ai-v-dg-broker-property","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/dg26ai-v-dg-broker-property\/","title":{"rendered":"Data Guard 26ai &#8211; #23: New view V$DG_BROKER_PROPERTY"},"content":{"rendered":"<p dir=\"auto\"><a href=\"https:\/\/www.ludovicocaldara.net\/dba\/dg-26ai-series\/\">This post is part of a blog series.<\/a><\/p>\n<p dir=\"auto\">Previously, the only supported way to view broker properties for members or configurations was by running the DGMGRL SHOW DATABASE or SHOW CONFIGURATION commands. These commands made it difficult to gather all properties for every member or to check for inconsistencies. Monitoring required manual parsing of the output, and there was no direct SQL option.<\/p>\n<p dir=\"auto\">With Data Guard 26ai, you can now use the new <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/26\/refrn\/V-DG_BROKER_PROPERTY.html\">V$DG_BROKER_PROPERTY<\/a> view.<\/p>\n<p dir=\"auto\"><a href=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-properties-scaled.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2382\" src=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-properties-1024x456.png\" alt=\"a select from v$dg_broker_property shows some example properties\" width=\"584\" height=\"260\" srcset=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-properties-1024x456.png 1024w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-properties-300x134.png 300w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-properties-768x342.png 768w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-properties-1536x684.png 1536w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-properties-2048x912.png 2048w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-properties-500x223.png 500w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/a><\/p>\n<p dir=\"auto\">This lets you easily query all broker properties for each member or for the whole configuration, using familiar SQL tools.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Query all Data Guard broker properties easily with the new V$DG_BROKER_PROPERTY view introduced in 26ai\u2014no more parsing of DGMGRL commands. <a href=\"https:\/\/www.ludovicocaldara.net\/dba\/dg26ai-v-dg-broker-property\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[375,329],"tags":[],"class_list":["post-2381","post","type-post","status-publish","format-standard","hentry","category-oracle-ai-database-26ai","category-oracle-dg"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/comments?post=2381"}],"version-history":[{"count":2,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2381\/revisions"}],"predecessor-version":[{"id":2448,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2381\/revisions\/2448"}],"wp:attachment":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/media?parent=2381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/categories?post=2381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/tags?post=2381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}