{"id":11532,"date":"2018-08-09T19:49:35","date_gmt":"2018-08-09T17:49:35","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/"},"modified":"2018-08-09T19:49:35","modified_gmt":"2018-08-09T17:49:35","slug":"atp-vs-adw-the-autonomous-database-lockdown-profiles","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/","title":{"rendered":"ATP vs ADW &#8211; the Autonomous Database lockdown profiles"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nThe Oracle database has always distinguished two types of workloads: transactional (OLTP) and datawarehouse (VLDB, DWH, DSS, BI, analytics). There is the same idea in the managed Oracle Cloud with two autonomous database services. <\/p>\n<p>To show how this is old, here is how they were defined in the Oracle7 Tuning Book:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOLTPvsDSS.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOLTPvsDSS.png\" alt=\"CaptureOLTPvsDSS\" width=\"1024\" height=\"594\" class=\"aligncenter size-large wp-image-26953\" \/><\/a><\/p>\n<p>The definition has not changed a lot. But the technology behind DSS\/DWH has improved. Now, with In-Memory Column Store, Smart Scan, Result Cache we can even see that indexes, materialized views, star transformation, hints,.. are disabled in the Autonomous Datawarehouse cloud service.<\/p>\n<p>The difference between the two autonomous cloud services, ATP (Autonomous Transaction Processing) for OLTP and ADW (Autonomous Datawarehouse) for analytics have been described by Maria Colgan after Larry Ellison announce:<br \/>\n<a href=\"https:\/\/sqlmaria.com\/2018\/08\/07\/how-does-autonomous-transaction-processing-differ-from-the-autonomous-data-warehouse\/\">https:\/\/sqlmaria.com\/2018\/08\/07\/how-does-autonomous-transaction-processing-differ-from-the-autonomous-data-warehouse\/<\/a><\/p>\n<h3>PDBaaS<\/h3>\n<p>Those autonomous services are PDB as a Service. They are using the consolidation and isolation features of 12cR2 multitenant. And we can even see that the ATP and ADW services can run within the same CDB and same instance. They are different PDBs and they differ only by their resource management plans and PDB lockdown profiles. So let&#8217;s see the differences from this point of view: ATP lockdown profile is called &#8216;OLTP&#8217; and ADW lockdown profile is called &#8216;DWCS&#8217;.<\/p>\n<h3>Options<\/h3>\n<p>The only difference is about partitioning which is enabled for ATP and disabled for ASW<\/p>\n<pre><code>\nSQL&gt; select (select value from v$parameter where name='pdb_lockdown') type,v$lockdown_rules.* from v$lockdown_rules where rule_type='OPTION';\n&nbsp;\nTYPE   RULE_TYPE   RULE           CLAUSE   CLAUSE_OPTION   STATUS   USERS   CON_ID\n----   ---------   ----           ------   -------------   ------   -----   ------\nOLTP   OPTION      PARTITIONING                            ENABLE   ALL          284\n&nbsp;\nSQL&gt; select (select value from v$parameter where name='pdb_lockdown') type,v$lockdown_rules.* from v$lockdown_rules where rule_type='OPTION' order by 1, 2 ,3 nulls first, 4 nulls first,5;\n&nbsp;\nTYPE   RULE_TYPE   RULE           CLAUSE   CLAUSE_OPTION   STATUS    USERS   CON_ID   \n----   ---------   ----           ------   -------------   -------   -----   ------\nDWCS   OPTION      PARTITIONING                            DISABLE   ALL           73 \n<\/code><\/pre>\n<h3>Features<\/h3>\n<p>All disabled features are the same:<br \/>\nDisabled for all users: COMMON_SCHEMA_ACCESS, CONNECTIONS, CTX_LOGGING, NETWORK_ACCESS, OS_ACCESS, SYSTEM_DATA<br \/>\nDisabled for local users only: USER_PASSWORD_VERIFIERS<br \/>\nEnabled for all users: COMMON_USER_CONNECT, TRACE_VIEW_ACCESS, UTL_FILE<\/p>\n<p>Those last ones are good news. We can query V$DIAG_OPT_TRACE_RECORDS, V$DIAG_SQL_TRACE_RECORDS, $DIAG_TRACE_FILE_CONTENTS to show some diagnostics. Unfortunately, I&#8217;ve seen no allowed ways to enable SQL Trace.<\/p>\n<h3>DDL Statements<\/h3>\n<p>In the ADW service, the local user cannot create indexes and materialized views, They are supposed to be autonomously created when required (probably by a common user):<\/p>\n<pre><code>\nSQL&gt; select (select value from v$parameter where name='pdb_lockdown') type,v$lockdown_rules.* from v$lockdown_rules where regexp_like(rule,'(INDEX|MATERIALIZED)') order by 1, 2 ,3 nulls first, 4 nulls first,5;\n&nbsp;\nTYPE   RULE_TYPE   RULE                           CLAUSE   CLAUSE_OPTION   STATUS    USERS     CON_ID   \n----   ---------   ----                           ------   -------------   ------    -----     ------ \nDWCS   STATEMENT   ALTER INDEX                                             DISABLE   LOCAL         73 \nDWCS   STATEMENT   ALTER INDEXTYPE                                         DISABLE   LOCAL         73 \nDWCS   STATEMENT   ALTER MATERIALIZED VIEW                                 DISABLE   LOCAL         73 \nDWCS   STATEMENT   ALTER MATERIALIZED VIEW LOG                             DISABLE   LOCAL         73 \nDWCS   STATEMENT   CREATE INDEX                                            DISABLE   LOCAL         73 \nDWCS   STATEMENT   CREATE INDEXTYPE                                        DISABLE   LOCAL         73 \nDWCS   STATEMENT   CREATE MATERIALIZED VIEW                                DISABLE   LOCAL         73 \nDWCS   STATEMENT   CREATE MATERIALIZED VIEW LOG                            DISABLE   LOCAL         73 \nDWCS   STATEMENT   DROP INDEX                                              DISABLE   LOCAL         73 \nDWCS   STATEMENT   DROP INDEXTYPE                                          DISABLE   LOCAL         73 \nDWCS   STATEMENT   DROP MATERIALIZED VIEW                                  DISABLE   LOCAL         73 \nDWCS   STATEMENT   DROP MATERIALIZED VIEW LOG                              DISABLE   LOCAL         73 \n<\/code><\/pre>\n<p>The ATP service enables all those for all users.<\/p>\n<h3>System parameters<\/h3>\n<p>Both services disable all ALTER SYSTEM statements except KILL SESSION. They allow all ALTER SYSTEM SET for the common users but allow only a few parameters to be changed by local users.<\/p>\n<p>Basically, the ADW service sets the following:<\/p>\n<pre><code>\n_default_pct_free=1\n_ldr_io_size=33554432\n_ldr_io_size2=33554432\n_max_io_size=33554432\n_optimizer_allow_all_access_paths=FALSE\n_optimizer_answering_query_using_stats=TRUE\noptimizer_ignore_hints=TRUE\noptimizer_ignore_parallel_hints=TRUE\nparallel_degree_policy=AUTO\nparallel_min_degree=CPU\nresult_cache_max_result=1\nresult_cache_mode=FORCE\n<\/code><\/pre>\n<p>The ATP service keeps the defaults.<\/p>\n<p>Basically, all the features for OLTP are there for years in the Oracle Database. Under the &#8216;autonomous&#8217; umbrella we can see some well-known features<\/p>\n<ul>\n<li>Automatic provisioning: pluggable databases<\/li>\n<li>Automatic scaling: PDB resource manager<\/li>\n<li>Automatic tuning: SQL Plan Management, Adaptive Plans, SQL Tuning Advisor, Storage Indexes<\/li>\n<li>Automatic security: Rolling patches, Encryption, Database Vault<\/li>\n<li>Automatic Fault Tolerant Failover: RAC, Data Guard<\/li>\n<li>Automatic Backup and Recovery: RMAN, Flashback<\/li>\n<\/ul>\n<p>All these proven features are enhanced to work together in a consolidated multitenant environment. Povisioning is as fast as a CREATE PDB. The ATP and ADW services enable and configure the right set of features for each workload.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . The Oracle database has always distinguished two types of workloads: transactional (OLTP) and datawarehouse (VLDB, DWH, DSS, BI, analytics). There is the same idea in the managed Oracle Cloud with two autonomous database services. To show how this is old, here is how they were defined in the Oracle7 Tuning Book: [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":11533,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[955,59],"tags":[1191,220,135,221,64,96,66,223],"type_dbi":[],"class_list":["post-11532","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud","category-oracle","tag-autonomous","tag-cdb","tag-cloud","tag-data-guard","tag-multitenant","tag-oracle","tag-pdb","tag-pluggable-databases"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>ATP vs ADW - the Autonomous Database lockdown profiles - 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\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ATP vs ADW - the Autonomous Database lockdown profiles\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . The Oracle database has always distinguished two types of workloads: transactional (OLTP) and datawarehouse (VLDB, DWH, DSS, BI, analytics). There is the same idea in the managed Oracle Cloud with two autonomous database services. To show how this is old, here is how they were defined in the Oracle7 Tuning Book: [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-09T17:49:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOLTPvsDSS.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2725\" \/>\n\t<meta property=\"og:image:height\" content=\"1580\" \/>\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=\"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\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"ATP vs ADW &#8211; the Autonomous Database lockdown profiles\",\"datePublished\":\"2018-08-09T17:49:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/\"},\"wordCount\":506,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOLTPvsDSS.png\",\"keywords\":[\"Autonomous\",\"CDB\",\"Cloud\",\"Data Guard\",\"multitenant\",\"Oracle\",\"PDB\",\"Pluggable Databases\"],\"articleSection\":[\"Cloud\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/\",\"name\":\"ATP vs ADW - the Autonomous Database lockdown profiles - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOLTPvsDSS.png\",\"datePublished\":\"2018-08-09T17:49:35+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOLTPvsDSS.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOLTPvsDSS.png\",\"width\":2725,\"height\":1580},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ATP vs ADW &#8211; the Autonomous Database lockdown profiles\"}]},{\"@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":"ATP vs ADW - the Autonomous Database lockdown profiles - 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\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/","og_locale":"en_US","og_type":"article","og_title":"ATP vs ADW - the Autonomous Database lockdown profiles","og_description":"By Franck Pachot . The Oracle database has always distinguished two types of workloads: transactional (OLTP) and datawarehouse (VLDB, DWH, DSS, BI, analytics). There is the same idea in the managed Oracle Cloud with two autonomous database services. To show how this is old, here is how they were defined in the Oracle7 Tuning Book: [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/","og_site_name":"dbi Blog","article_published_time":"2018-08-09T17:49:35+00:00","og_image":[{"width":2725,"height":1580,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOLTPvsDSS.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"ATP vs ADW &#8211; the Autonomous Database lockdown profiles","datePublished":"2018-08-09T17:49:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/"},"wordCount":506,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOLTPvsDSS.png","keywords":["Autonomous","CDB","Cloud","Data Guard","multitenant","Oracle","PDB","Pluggable Databases"],"articleSection":["Cloud","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/","url":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/","name":"ATP vs ADW - the Autonomous Database lockdown profiles - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOLTPvsDSS.png","datePublished":"2018-08-09T17:49:35+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOLTPvsDSS.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOLTPvsDSS.png","width":2725,"height":1580},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/atp-vs-adw-the-autonomous-database-lockdown-profiles\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ATP vs ADW &#8211; the Autonomous Database lockdown profiles"}]},{"@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\/11532","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=11532"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11532\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/11533"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11532"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}