![\"C0DLx2GXEAALIG4\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/C0DLx2GXEAALIG4.jpg\")
<\/a>
\nI’ll explain AWR reports in a future post. Basically when you run awrrpt.sql from CDB$ROOT you get CDB snapshots and when you run it from PDB you have the choice.<\/p>\nIn the diagram above, just follow the arrows to know which view reads from PDB or CDB or both. You see two switches between the root and the PDB: data link for one way and common view for the other way. Note that all are metadata links so switches occurs also at parse time.<\/p>\n
WRM$_<\/h3>\n
Let’s start from the table where AWR snapshots are stored:<\/p>\n
\nSQL> select owner,object_name,object_type,sharing from dba_objects where object_name='WRM$_SNAPSHOT';\n \nOWNER OBJECT_NAME OBJECT_TYPE SHARING\n----- ------------------------------ ----------------------- ------------------\nSYS WRM$_SNAPSHOT TABLE METADATA LINK\n<\/code><\/pre>\nThis is a table. METADATA LINK means that the structure is the same in all containers, but data is different.<\/p>\n
I have the following containers:<\/p>\n
\nSQL> select con_id,dbid,name from v$containers;\n \n CON_ID DBID NAME\n---------- ---------- ------------------------------\n 1 904475458 CDB$ROOT\n 2 2066620152 PDB$SEED\n 3 2623271973 PDB1\n<\/code><\/pre>\nFrom CDB$ROOT I see data for the CDB:<\/p>\n
\nSQL> select dbid,count(*) from WRM$_SNAPSHOT group by dbid;\n \n DBID COUNT(*)\n---------- ----------\n 904475458 91\n<\/code><\/pre>\nand from PDB I see snapshots taken from PDB:<\/p>\n
\nSQL> alter session set container=PDB1;\nSession altered.\n \nSQL> select dbid,count(*) from WRM$_SNAPSHOT group by dbid;\n \n DBID COUNT(*)\n---------- ----------\n2623271973 79\n<\/code><\/pre>\nSo remember, CDB$ROOT has 91 snapshots with DBID= 904475458 and PDB1 has 79 snapshots with DBID=2623271973<\/p>\n
AWR_ROOT_ and AWR_PDB_<\/h3>\n
Views on WRM$_SNAPSHOT are referenced in DBA_DEPENDENCIES:<\/p>\n
\nSQL> select owner,name,type from dba_dependencies where referenced_name='WRM$_SNAPSHOT' and type like 'VIEW';\n \nOWNER NAME TYPE\n----- ------------------------------ -------------------\nSYS AWR_ROOT_SNAPSHOT VIEW\nSYS AWR_ROOT_SYSSTAT VIEW\nSYS AWR_ROOT_ACTIVE_SESS_HISTORY VIEW\nSYS AWR_ROOT_ASH_SNAPSHOT VIEW\nSYS AWR_PDB_SNAPSHOT VIEW\nSYS AWR_PDB_ACTIVE_SESS_HISTORY VIEW\nSYS AWR_PDB_ASH_SNAPSHOT VIEW\n<\/code><\/pre>\nI’m interested in views that show snapshot information: AWR_ROOT_SNAPSHOT and AWR_PDB_SNAPSHOT<\/p>\n
\nSQL> select owner,object_name,object_type,sharing from dba_objects where object_name in ('AWR_ROOT_SNAPSHOT','AWR_PDB_SNAPSHOT') order by 3;\n \nOWNER OBJECT_NAME OBJECT_TYPE SHARING\n------ ------------------------------ ----------------------- ------------------\nPUBLIC AWR_ROOT_SNAPSHOT SYNONYM METADATA LINK\nPUBLIC AWR_PDB_SNAPSHOT SYNONYM METADATA LINK\nSYS AWR_ROOT_SNAPSHOT VIEW DATA LINK\nSYS AWR_PDB_SNAPSHOT VIEW METADATA LINK\n<\/code><\/pre>\nBesides the synonyms, we have a metadata link view AWR_PDB_SNAPSHOT and a data link view AWR_ROOT_SNAPSHOT. The data link one means that it switches to CDB$ROOT when queried from a PDB. Here is the definition:<\/p>\n
\nSQL> select owner,view_name,container_data,text from dba_views where view_name in ('AWR_ROOT_SNAPSHOT','AWR_PDB_SNAPSHOT');\n \nOWNER VIEW_NAME C TEXT\n------ ------------------------------ - --------------------------------------------------------------------------------\nSYS AWR_ROOT_SNAPSHOT Y select snap_id, dbid, instance_number, startup_time,\n begin_interval_time, end_interval_time,\n flush_elapsed, snap_level, error_count, snap_flag, snap_timezone,\n decode(con_dbid_to_id(dbid), 1, 0, con_dbid_to_id(dbid)) con_id\n from WRM$_SNAPSHOT\n where status = 0\n \nSYS AWR_PDB_SNAPSHOT N select snap_id, dbid, instance_number, startup_time,\n begin_interval_time, end_interval_time,\n flush_elapsed, snap_level, error_count, snap_flag, snap_timezone,\n decode(con_dbid_to_id(dbid), 1, 0, con_dbid_to_id(dbid)) con_id\n from WRM$_SNAPSHOT\n where status = 0\n<\/code><\/pre>\nSame definition. The difference is that AWR_PDB_SNAPSHOT reads from the current container but AWR_ROOT_SNAPSHOT being a DATA LINK always read from CDB$ROOT.<\/p>\n
This is what we can see:<\/p>\n
\nSQL> alter session set container=CDB$ROOT;\nSession altered.\n \nSQL> select dbid,count(*) from AWR_ROOT_SNAPSHOT group by dbid;\n \n DBID COUNT(*)\n---------- ----------\n 904475458 91\n \nSQL> select dbid,count(*) from AWR_PDB_SNAPSHOT group by dbid;\n \n DBID COUNT(*)\n---------- ----------\n 904475458 91\n \nSQL> alter session set container=PDB1;\nSession altered.\n \nSQL> select dbid,count(*) from AWR_ROOT_SNAPSHOT group by dbid;\n \n DBID COUNT(*)\n---------- ----------\n 904475458 91\n<\/code><\/pre>\nThis query when run in PDB1 displays the 91 snapshots from the CDB.<\/p>\n
\nSQL> select dbid,count(*) from AWR_PDB_SNAPSHOT group by dbid;\n \n DBID COUNT(*)\n---------- ----------\n2623271973 79\n<\/code><\/pre>\nThis one shows what is in the current container.<\/p>\n
Those are the views used by the AWR report, depending on the AWR location choice. But what about the DBA_HIST_ views that we know and use from previous versions?<\/p>\n
DBA_HIST_ and CDB_HIST_<\/h3>\n
I continue to follow the dependencies:<\/p>\n
\nSQL> select owner,name,type from dba_dependencies where referenced_name in ('AWR_ROOT_SNAPSHOT','AWR_PDB_SNAPSHOT') and name like '%SNAPSHOT' order by 3;\n \nOWNER NAME TYPE\n------ ------------------------------ -------------------\nPUBLIC AWR_ROOT_SNAPSHOT SYNONYM\nPUBLIC AWR_PDB_SNAPSHOT SYNONYM\nSYS DBA_HIST_SNAPSHOT VIEW\nSYS CDB_HIST_SNAPSHOT VIEW\n \nSQL> select owner,object_name,object_type,sharing from dba_objects where object_name in ('CDB_HIST_SNAPSHOT','DBA_HIST_SNAPSHOT');\n \nOWNER OBJECT_NAME OBJECT_TYPE SHARING\n------ ------------------------------ ----------------------- ------------------\nSYS DBA_HIST_SNAPSHOT VIEW METADATA LINK\nSYS CDB_HIST_SNAPSHOT VIEW METADATA LINK\nPUBLIC DBA_HIST_SNAPSHOT SYNONYM METADATA LINK\nPUBLIC CDB_HIST_SNAPSHOT SYNONYM METADATA LINK\n<\/code><\/pre>\nHere are the views I’m looking for. They are metadata link only. Not data link. This means that they do not switch to CDB$ROOT.<\/p>\n
But there’s more in the view definition:<\/p>\n
\nSQL> select owner,view_name,container_data,text from dba_views where view_name in ('CDB_HIST_SNAPSHOT','DBA_HIST_SNAPSHOT');\n \nOWNER VIEW_NAME C TEXT\n------ ------------------------------ - --------------------------------------------------------------------------------\nSYS DBA_HIST_SNAPSHOT N select \"SNAP_ID\",\"DBID\",\"INSTANCE_NUMBER\",\"STARTUP_TIME\",\"BEGIN_INTERVAL_TIME\",\"\n END_INTERVAL_TIME\",\"FLUSH_ELAPSED\",\"SNAP_LEVEL\",\"ERROR_COUNT\",\"SNAP_FLAG\",\"SNAP_\n TIMEZONE\",\"CON_ID\" from AWR_ROOT_SNAPSHOT\n \nSYS CDB_HIST_SNAPSHOT Y SELECT k.\"SNAP_ID\",k.\"DBID\",k.\"INSTANCE_NUMBER\",k.\"STARTUP_TIME\",k.\"BEGIN_INTERV\n AL_TIME\",k.\"END_INTERVAL_TIME\",k.\"FLUSH_ELAPSED\",k.\"SNAP_LEVEL\",k.\"ERROR_COUNT\",\n k.\"SNAP_FLAG\",k.\"SNAP_TIMEZONE\",k.\"CON_ID\", k.CON$NAME, k.CDB$NAME FROM CONTAINE\n RS(\"SYS\".\"AWR_PDB_SNAPSHOT\") k\n<\/code><\/pre>\nThe DBA_HIST_SNAPSHOT is a simple one view on AWR_ROOT_SNAPSHOT which, as we have seen above, always show snapshots from CDB:<\/p>\n
\nSQL> alter session set container=CDB$ROOT;\nSession altered.\n \nSQL> select dbid,count(*) from DBA_HIST_SNAPSHOT group by dbid;\n \n DBID COUNT(*)\n---------- ----------\n 904475458 91\n \nSQL> alter session set container=PDB1;\nSession altered.\n \nSQL> select dbid,count(*) from DBA_HIST_SNAPSHOT group by dbid;\n \n DBID COUNT(*)\n---------- ----------\n 904475458 91\n<\/code><\/pre>\nThen CDB_HIST_SNAPSHOT reads AWR_PDB_SNAPSHOT which show current container snapshots. But this view is a COMMON DATA one, with the CONTAINER() function. This means that from CDB$ROOT when executed with a common user data from all open containers will be retrieved:<\/p>\n
\nSQL> alter session set container=CDB$ROOT;\nSession altered.\n \nSQL> select dbid,count(*) from CDB_HIST_SNAPSHOT group by dbid;\n \n DBID COUNT(*)\n---------- ----------\n2623271973 79\n 904475458 91\n<\/code><\/pre>\nHowever, from a PDB you cannot see anything else:<\/p>\n
\nSQL> alter session set container=PDB1;\nSession altered.\n \nSQL> select dbid,count(*) from CDB_HIST_SNAPSHOT group by dbid;\n \n DBID COUNT(*)\n---------- ----------\n2623271973 79\n<\/code><\/pre>\nSo what?<\/h3>\n
Multitenant adds a new dimension in the dictionary views and we must be aware of that. However, compatibility is still there. The scripts that we used to run to query DBA_HIST views should still work. Don’t forget to always join on DBID and INSTANCE_NUMBER in addition to SNAP_ID so that your scripts are still working in RAC, and cross containers.
\nIn 12.2 you can do the same for your application: used metadata links, data links, and common views for your tables. But remember to keep it simple…<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . In a previous post I explained how the AWR views have changed between 12.1.0.1 and 12.1.0.2 and now in 12.2.0.1 they have changed again. This is a good illustration of multitenant object link usage.<\/p>\n","protected":false},"author":27,"featured_media":9600,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[656,422,220,455,64,209,875,66,223],"type_dbi":[],"class_list":["post-9598","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-12-2","tag-awr","tag-cdb","tag-internals","tag-multitenant","tag-oracle-12c","tag-oracle-multitenant","tag-pdb","tag-pluggable-databases"],"acf":[],"yoast_head":"\n
Oracle 12cR2: AWR views in multitenant - 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\/oracle-12cr2-awr-views-in-multitenant\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 12cR2: AWR views in multitenant\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . In a previous post I explained how the AWR views have changed between 12.1.0.1 and 12.1.0.2 and now in 12.2.0.1 they have changed again. This is a good illustration of multitenant object link usage.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-19T18:42:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/C0DLx2GXEAALIG4-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1164\" \/>\n\t<meta property=\"og:image:height\" content=\"560\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"7 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\/oracle-12cr2-awr-views-in-multitenant\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 12cR2: AWR views in multitenant\",\"datePublished\":\"2016-12-19T18:42:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/\"},\"wordCount\":652,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/C0DLx2GXEAALIG4-1.jpg\",\"keywords\":[\"12.2\",\"AWR\",\"CDB\",\"internals\",\"multitenant\",\"Oracle 12c\",\"Oracle Multitenant\",\"PDB\",\"Pluggable Databases\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/\",\"name\":\"Oracle 12cR2: AWR views in multitenant - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/C0DLx2GXEAALIG4-1.jpg\",\"datePublished\":\"2016-12-19T18:42:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/C0DLx2GXEAALIG4-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/C0DLx2GXEAALIG4-1.jpg\",\"width\":1164,\"height\":560},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 12cR2: AWR views in multitenant\"}]},{\"@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":"Oracle 12cR2: AWR views in multitenant - 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\/oracle-12cr2-awr-views-in-multitenant\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 12cR2: AWR views in multitenant","og_description":"By Franck Pachot . In a previous post I explained how the AWR views have changed between 12.1.0.1 and 12.1.0.2 and now in 12.2.0.1 they have changed again. This is a good illustration of multitenant object link usage.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/","og_site_name":"dbi Blog","article_published_time":"2016-12-19T18:42:50+00:00","og_image":[{"width":1164,"height":560,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/C0DLx2GXEAALIG4-1.jpg","type":"image\/jpeg"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 12cR2: AWR views in multitenant","datePublished":"2016-12-19T18:42:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/"},"wordCount":652,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/C0DLx2GXEAALIG4-1.jpg","keywords":["12.2","AWR","CDB","internals","multitenant","Oracle 12c","Oracle Multitenant","PDB","Pluggable Databases"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/","name":"Oracle 12cR2: AWR views in multitenant - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/C0DLx2GXEAALIG4-1.jpg","datePublished":"2016-12-19T18:42:50+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/C0DLx2GXEAALIG4-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/C0DLx2GXEAALIG4-1.jpg","width":1164,"height":560},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-awr-views-in-multitenant\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 12cR2: AWR views in multitenant"}]},{"@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\/9598","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=9598"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9598\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/9600"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9598"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}