{"id":10600,"date":"2017-10-31T19:27:00","date_gmt":"2017-10-31T18:27:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/"},"modified":"2017-10-31T19:27:00","modified_gmt":"2017-10-31T18:27:00","slug":"dbvisit-replicate-sql-developer-chart","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/","title":{"rendered":"Dbvisit replicate – SQL Developer chart"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nHere is a quick SQL Developer report which display a chart about the Dbvisit replicate lag over the last hours
\n
\nThe idea is to have the following chart showing the lag in MINE and APPLY processes. Here is an example where I stopped the replication to show some lag.
\n\"CaptureDbvrepsqldev\"<\/a><\/p>\n

The query is on the DBVREP.DBRSCOMMON_LAG_STATS on the APPLY side, which display the wallclock time with timestamp from the MINE and from the APPLY.<\/p>\n

Here is the SQL Developer report .xml:<\/p>\n

<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<displays>\n<display id=\"72f37b59-015f-1000-8002-0af7a3b47766\" type=\"\" style=\"Chart\" enable=\"true\">\n\t<name><![CDATA[Dbvisit replicate gap]]><\/name>\n\t<description><![CDATA[]]><\/description>\n\t<tooltip><![CDATA[]]><\/tooltip>\n\t<drillclass><![CDATA[]]><\/drillclass>\n\t<CustomValues>\n\t\t<Y1AXIS_TITLE_TEXT><![CDATA[min]]><\/Y1AXIS_TITLE_TEXT>\n\t\t<PLOT_DATATIPS_TEXT><![CDATA[true]]><\/PLOT_DATATIPS_TEXT>\n\t\t<Y2AXIS_SCALE_MAXIMUM><![CDATA[80.0]]><\/Y2AXIS_SCALE_MAXIMUM>\n\t\t<XAXIS_TICK_LABEL_FONT.COLOR><![CDATA[-12565927]]><\/XAXIS_TICK_LABEL_FONT.COLOR>\n\t\t<LEGEND_LOCATION><![CDATA[AUTOMATIC]]><\/LEGEND_LOCATION>\n\t\t<PLOT_SERIES_OPTIONS_COLOR><![CDATA[\\,-1344256,-16756836,-10066279,-16751002,-26368]]><\/PLOT_SERIES_OPTIONS_COLOR>\n\t\t<DATA_MAP_COLUMNS><![CDATA[\\,\"WALLCLOCK\",\"WALLCLOCK\"]]><\/DATA_MAP_COLUMNS>\n\t\t<Y1AXIS_SCALE_MAXIMUM><![CDATA[60.0]]><\/Y1AXIS_SCALE_MAXIMUM>\n\t\t<Y1AXIS_SCALE_INCREMENT_AUTOMATIC><![CDATA[false]]><\/Y1AXIS_SCALE_INCREMENT_AUTOMATIC>\n\t\t<XAXIS_TICK_LABEL_ROTATE><![CDATA[HORIZONTAL]]><\/XAXIS_TICK_LABEL_ROTATE>\n\t\t<TYPE><![CDATA[BAR_VERT_CLUST]]><\/TYPE>\n\t\t<DATA_MAP_COUNT><![CDATA[2]]><\/DATA_MAP_COUNT>\n\t\t<STYLE><![CDATA[Default]]><\/STYLE>\n\t\t<TITLE_ALIGNMENT><![CDATA[LEFT]]><\/TITLE_ALIGNMENT>\n\t\t<XAXIS_TICK_LABEL_FONT.NAME><![CDATA[Courier New]]><\/XAXIS_TICK_LABEL_FONT.NAME>\n\t\t<TITLE_TEXT><![CDATA[Dbvisit replicate gap (in minutes)]]><\/TITLE_TEXT>\n\t\t<Y2AXIS_TICK_LABEL_ROTATE><![CDATA[HORIZONTAL]]><\/Y2AXIS_TICK_LABEL_ROTATE>\n\t\t<PLOT_HGRID><![CDATA[true]]><\/PLOT_HGRID>\n\t\t<PLOT_DATATIPS_VALUE><![CDATA[true]]><\/PLOT_DATATIPS_VALUE>\n\t\t<Y2AXIS_LINE_WIDTH><![CDATA[THINNEST]]><\/Y2AXIS_LINE_WIDTH>\n\t\t<Y1AXIS_TICK_LABEL_ROTATE><![CDATA[HORIZONTAL]]><\/Y1AXIS_TICK_LABEL_ROTATE>\n\t\t<PLOT_HGRID_WIDTH><![CDATA[THINNER]]><\/PLOT_HGRID_WIDTH>\n\t\t<XAXIS_TICK_LABEL_AUTO_ROTATE><![CDATA[true]]><\/XAXIS_TICK_LABEL_AUTO_ROTATE>\n\t\t<Y1AXIS_SCALE_INCREMENT><![CDATA[60.0]]><\/Y1AXIS_SCALE_INCREMENT>\n\t\t<Y1AXIS_LINE_WIDTH><![CDATA[THINNEST]]><\/Y1AXIS_LINE_WIDTH>\n\t\t<Y1AXIS_TITLE_ALIGNMENT><![CDATA[CENTER]]><\/Y1AXIS_TITLE_ALIGNMENT>\n\t\t<LEGEND_ALIGNMENT><![CDATA[LEFT]]><\/LEGEND_ALIGNMENT>\n\t\t<XAXIS_LINE_WIDTH><![CDATA[THINNEST]]><\/XAXIS_LINE_WIDTH>\n\t\t<XAXIS_TICK_LABEL_FONT.SIZE><![CDATA[14]]><\/XAXIS_TICK_LABEL_FONT.SIZE>\n\t\t<XAXIS_TITLE_ALIGNMENT><![CDATA[CENTER]]><\/XAXIS_TITLE_ALIGNMENT>\n\t\t<PLOT_DATALABELS><![CDATA[false]]><\/PLOT_DATALABELS>\n\t\t<Y1AXIS_LOGARITHMIC_BASE><![CDATA[BASE_10]]><\/Y1AXIS_LOGARITHMIC_BASE>\n\t\t<GRID_WIDTH><![CDATA[THINNER]]><\/GRID_WIDTH>\n\t\t<PLOT_DATALABELS_BAR_POSITION><![CDATA[ABOVE]]><\/PLOT_DATALABELS_BAR_POSITION>\n\t\t<FOOTNOTE_ALIGNMENT><![CDATA[LEFT]]><\/FOOTNOTE_ALIGNMENT>\n\t\t<XAXIS_TICK_LABEL_SKIP_MODE><![CDATA[MANUAL]]><\/XAXIS_TICK_LABEL_SKIP_MODE>\n\t\t<XAXIS_TICK_LABEL_FONT.UNDERLINE><![CDATA[false]]><\/XAXIS_TICK_LABEL_FONT.UNDERLINE>\n\t\t<DATA_MAP_COLNAMES><![CDATA[\\,\"APPLY lag seconds\",\"APPLY_PROCESS_NAME\",\"DDC_ID\",\"MINE lag seconds\",\"MINE_PROCESS_NAME\",\"WALLCLOCK\"]]><\/DATA_MAP_COLNAMES>\n\t\t<DATA_MAP_SERIES><![CDATA[\\,\"MINE_PROCESS_NAME\",\"APPLY_PROCESS_NAME\"]]><\/DATA_MAP_SERIES>\n\t\t<Y2AXIS_LOGARITHMIC_BASE><![CDATA[BASE_10]]><\/Y2AXIS_LOGARITHMIC_BASE>\n\t\t<Y2AXIS_SCALE_MINIMUM><![CDATA[10.0]]><\/Y2AXIS_SCALE_MINIMUM>\n\t\t<XAXIS_TICK_LABEL_FONT.POSTURE><![CDATA[false]]><\/XAXIS_TICK_LABEL_FONT.POSTURE>\n\t\t<DATA_MAP_VALUES><![CDATA[\\,\"MINE lag seconds\",\"MINE lag seconds\"]]><\/DATA_MAP_VALUES>\n\t\t<PLOT_VGRID><![CDATA[true]]><\/PLOT_VGRID>\n\t\t<TITLE><![CDATA[true]]><\/TITLE>\n\t\t<Y1AXIS_TITLE><![CDATA[false]]><\/Y1AXIS_TITLE>\n\t\t<Y2AXIS_SCALE_INCREMENT><![CDATA[20.0]]><\/Y2AXIS_SCALE_INCREMENT>\n\t\t<PLOT_VGRID_WIDTH><![CDATA[THINNER]]><\/PLOT_VGRID_WIDTH>\n\t\t<Y2AXIS_TITLE_ALIGNMENT><![CDATA[CENTER]]><\/Y2AXIS_TITLE_ALIGNMENT>\n\t\t<SUBTITLE_ALIGNMENT><![CDATA[LEFT]]><\/SUBTITLE_ALIGNMENT>\n\t\t<XAXIS_TICK_LABEL_FONT.WEIGHT><![CDATA[false]]><\/XAXIS_TICK_LABEL_FONT.WEIGHT>\n\t<\/CustomValues>\n\t<query>\n\t\t<sql><![CDATA[SELECT  ddc_id,mine_process_name,apply_process_name,\"WALLCLOCK\", \"APPLY lag seconds\", \"MINE lag seconds\" FROM(\nselect ddc_id,mine_process_name,apply_process_name,\nto_char(trunc(wallclock_date,'hh24'),'dd-mon hh24:mi') wallclock,\nmax(round((wallclock_date-apply_date)*24*60*60)) \"APPLY lag seconds\", max(round((wallclock_date-mine_date)*24*60*60)) \"MINE lag seconds\"\nfrom DBVREP.DBRSCOMMON_LAG_STATS \nwhere wallclock_date>sysdate-3\ngroup by ddc_id,mine_process_name,apply_process_name,to_char(trunc(wallclock_date,'hh24'),'dd-mon hh24:mi')\norder by wallclock\n)]]><\/sql>\n\t<\/query>\n\t\t<pdf version=\"VERSION_1_7\" compression=\"CONTENT\">\n\t\t\t<docproperty title=\"null\" author=\"null\" subject=\"null\" keywords=\"null\" \/>\n\t\t\t<cell toppadding=\"2\" bottompadding=\"2\" leftpadding=\"2\" rightpadding=\"2\" horizontalalign=\"LEFT\" verticalalign=\"TOP\" wrap=\"true\" \/>\n\t\t\t<column>\n\t\t\t\t<heading font=\"null\" size=\"10\" style=\"NORMAL\" color=\"-16777216\" rowshading=\"-1\" labeling=\"FIRST_PAGE\" \/>\n\t\t\t\t<footing font=\"null\" size=\"10\" style=\"NORMAL\" color=\"-16777216\" rowshading=\"-1\" labeling=\"NONE\" \/>\n\t\t\t\t<blob blob=\"NONE\" zip=\"false\" \/>\n\t\t\t<\/column>\n\t\t\t<table font=\"null\" size=\"10\" style=\"NORMAL\" color=\"-16777216\" userowshading=\"false\" oddrowshading=\"-1\" evenrowshading=\"-1\" showborders=\"true\" spacingbefore=\"12\" spacingafter=\"12\" horizontalalign=\"LEFT\" \/>\n\t\t\t<header enable=\"false\" generatedate=\"false\">\n\t\t\t\t<data>\n\t\t\t\tnull\t\t\t\t<\/data>\n\t\t\t<\/header>\n\t\t\t<footer enable=\"false\" generatedate=\"false\">\n\t\t\t\t<data value=\"null\" \/>\n\t\t\t<\/footer>\n\t\t\t<pagesetup papersize=\"LETTER\" orientation=\"1\" measurement=\"in\" margintop=\"1.0\" marginbottom=\"1.0\" marginleft=\"1.0\" marginright=\"1.0\" \/>\n\t\t<\/pdf>\n<\/display>\n<\/displays><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . Here is a quick SQL Developer report which display a chart about the Dbvisit replicate lag over the last hours<\/p>\n","protected":false},"author":27,"featured_media":10601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[429,570,77,1134],"type_dbi":[],"class_list":["post-10600","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-dbvisit-replicate","tag-postgres","tag-postgresql","tag-sql-developer"],"acf":[],"yoast_head":"\nDbvisit replicate - SQL Developer chart - dbi Blog<\/title>\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\/dbvisit-replicate-sql-developer-chart\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dbvisit replicate - SQL Developer chart\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . Here is a quick SQL Developer report which display a chart about the Dbvisit replicate lag over the last hours\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-31T18:27:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDbvrepsqldev.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1439\" \/>\n\t<meta property=\"og:image:height\" content=\"881\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 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\/dbvisit-replicate-sql-developer-chart\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Dbvisit replicate – SQL Developer chart\",\"datePublished\":\"2017-10-31T18:27:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/\"},\"wordCount\":92,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDbvrepsqldev.png\",\"keywords\":[\"Dbvisit replicate\",\"postgres\",\"PostgreSQL\",\"SQL Developer\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/\",\"name\":\"Dbvisit replicate - SQL Developer chart - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDbvrepsqldev.png\",\"datePublished\":\"2017-10-31T18:27:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDbvrepsqldev.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDbvrepsqldev.png\",\"width\":1439,\"height\":881},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dbvisit replicate – SQL Developer chart\"}]},{\"@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\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Dbvisit replicate - SQL Developer chart - dbi Blog","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\/dbvisit-replicate-sql-developer-chart\/","og_locale":"en_US","og_type":"article","og_title":"Dbvisit replicate - SQL Developer chart","og_description":"By Franck Pachot . Here is a quick SQL Developer report which display a chart about the Dbvisit replicate lag over the last hours","og_url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/","og_site_name":"dbi Blog","article_published_time":"2017-10-31T18:27:00+00:00","og_image":[{"width":1439,"height":881,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDbvrepsqldev.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Dbvisit replicate – SQL Developer chart","datePublished":"2017-10-31T18:27:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/"},"wordCount":92,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDbvrepsqldev.png","keywords":["Dbvisit replicate","postgres","PostgreSQL","SQL Developer"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/","url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/","name":"Dbvisit replicate - SQL Developer chart - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDbvrepsqldev.png","datePublished":"2017-10-31T18:27:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDbvrepsqldev.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDbvrepsqldev.png","width":1439,"height":881},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-sql-developer-chart\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Dbvisit replicate – SQL Developer chart"}]},{"@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\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10600","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\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10600"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10600\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/10601"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10600"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}