{"id":3195,"date":"2018-04-25T10:58:04","date_gmt":"2018-04-25T13:58:04","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=3195"},"modified":"2018-04-25T12:49:02","modified_gmt":"2018-04-25T15:49:02","slug":"new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/","title":{"rendered":"New DBMS_ASH and DBMS_BDSQL packages &#8211; Apr2018 Patch"},"content":{"rendered":"<p>After applying the 180417 PSU and BP over 12.1.0.2 Database, I&#8217;ve noted 2 new packages created on the database: DBMS_ASH and DBMS_BDSQL.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">VERSION              PATCH      OWNER                TYPE                 NAME\r\n-------------------- ---------- -------------------- -------------------- --------------------\r\n12.1.0.2             PSU &amp; BP   SYS                  PACKAGE              DBMS_ASH\r\n12.1.0.2             BP ONLY    SYS                  PACKAGE              DBMS_BDSQL\r\n12.1.0.2             BP ONLY    SYS                  PACKAGE BODY         DBMS_ASH\r\n12.1.0.2             BP ONLY    SYS                  PACKAGE BODY         DBMS_BDSQL<\/pre>\n<p><strong>* Note DBMS_ASH Package Body was not created by the PSU, only by the BP. Probably this was a bug or something still under development.<\/strong><\/p>\n<h3>DBMS_ASH:<\/h3>\n<pre class=\"height-set:true height:300 lang:plsql decode:true\">PACKAGE dbms_ash AUTHID CURRENT_USER IS\r\n\r\n  TYPE FILTERTABLETYPE IS TABLE OF VARCHAR2(32767) INDEX BY VARCHAR2(30);\r\n\r\n  TYPE ADDINFOTYPE IS RECORD (\r\n    IDNAMESQL          VARCHAR2(32767)\r\n\r\n  , ID2NAME_DYNAMIC    VARCHAR2(32767)\r\n\r\n  , ID2NAME_AWR        VARCHAR2(32767)\r\n\r\n  , ID2NAME_CONST      VARCHAR2(32767)\r\n\r\n  , IDNAMEXML          VARCHAR2(32767)\r\n  );\r\n\r\n  TYPE DIMTYPE IS RECORD (\r\n\r\n    NAME                VARCHAR2(30)\r\n  , ENABLED             BOOLEAN\r\n\r\n  , SELECTSTR           VARCHAR2(32767)\r\n  , MAPSQL              VARCHAR2(32767)\r\n  , SELECTSTRMAP        VARCHAR2(32767)\r\n  , ISDIMMASKED         BOOLEAN\r\n  , FROMCLAUSE          VARCHAR2(32767)\r\n  , MAPXML              VARCHAR2(32767)\r\n  , WHERECLAUSE         VARCHAR2(32767)\r\n  , ADDINFO             ADDINFOTYPE\r\n  , IS_PDB_SPECIFIC     BOOLEAN\r\n  , CATEGORY            VARCHAR2(128)\r\n  );\r\n\r\n  TYPE DIMTABLETYPE IS TABLE OF DIMTYPE INDEX BY VARCHAR2(30);\r\n\r\n  TYPE BINDTYPE IS RECORD (\r\n    NAME VARCHAR2(100)\r\n  , VALUE VARCHAR2(4000)\r\n  );\r\n\r\n  TYPE BINDARRAYTYPE IS VARRAY(100) OF BINDTYPE;\r\n\r\n  TYPE QUERYBLOCKARRAYTYPE IS VARRAY(200) OF VARCHAR2(4000);\r\n\r\n  TYPE CONTEXTTYPE IS RECORD (\r\n\r\n    IS_LOCAL          BOOLEAN\r\n  , IS_CDB_ROOT       BOOLEAN\r\n  , LOCAL_IS_PDB      BOOLEAN\r\n  , LOCAL_DBID        NUMBER\r\n  , LOCAL_VERSION     VARCHAR(30)\r\n  , LOCAL_COMP_VER    VARCHAR(30)\r\n  , LOCAL_CONID       NUMBER\r\n  , LOCAL_CONDBID     NUMBER\r\n  , UNDERSCORES       BOOLEAN\r\n\r\n  , BEGINTIMEUTC      DATE\r\n  , ENDTIMEUTC        DATE\r\n\r\n  , BUCKETCOUNT       NUMBER\r\n  , BUCKETINTERVAL    NUMBER\r\n  , LASTBUCKETSIZE    NUMBER\r\n\r\n  , MEMENABLE         BOOLEAN\r\n  , MEMTZ             NUMBER\r\n  , MEMSIZEDAYS       NUMBER\r\n\r\n  , DISKENABLE        BOOLEAN\r\n  , DISK_COMP_VER     VARCHAR(30)\r\n  , DBID              NUMBER\r\n  , BEGINSNAPID       NUMBER\r\n  , ENDSNAPID         NUMBER\r\n  , AWRTABLEPREFIX    VARCHAR(20)\r\n  , DISKENDTIMEUTC    DATE\r\n  , DISKTZ            NUMBER\r\n\r\n  , SHOW_SQL          BOOLEAN\r\n  , VERBOSE_XML       BOOLEAN\r\n  , ERROR_XML         XMLTYPE\r\n  , DIAG_START_TIME   TIMESTAMP\r\n  , DIAG_CONTEXT_SECS NUMBER\r\n  , DIAG_PICKER_SECS  NUMBER\r\n  , DIAG_DATA_SECS    NUMBER\r\n  , DIAG_CPUINFO_SECS NUMBER\r\n\r\n  , INCLUDE_BG        BOOLEAN\r\n  , DIMTABLE          DIMTABLETYPE\r\n  , MEMFILTERPREDICATE VARCHAR2(32767)\r\n  , DISKFILTERPREDICATE VARCHAR2(32767)\r\n  , GVFILTERPREDICATE VARCHAR2(32767)\r\n  , SAMPLE_RATIO      NUMBER\r\n  , EST_ROW_COUNT     NUMBER\r\n  , EXP_ROW_COUNT     NUMBER\r\n  , ACTIVITYLINEXML   XMLTYPE\r\n  , CPUCOUNT          NUMBER\r\n  , CPUCORECOUNT      NUMBER\r\n\r\n  , QUERY             QUERYBLOCKARRAYTYPE\r\n  , USE_UTC_BINDS     BOOLEAN\r\n  , BINDS             BINDARRAYTYPE\r\n  );\r\n\r\n  REPORT_INTERNAL_VERSION CONSTANT VARCHAR2(64) := '29';\r\n\r\n  OMC_TIME_FORMAT CONSTANT VARCHAR2(30) := 'MM\/DD\/YYYY HH24:MI:SS';\r\n\r\n  OMC_ALLOWED_ERR_RATIO CONSTANT NUMBER := 0.9;\r\n\r\n  OMC_DEF_BUCKETS CONSTANT NUMBER := 120;\r\n\r\n  OMC_DEF_ROWS_PER_BUCKET CONSTANT NUMBER := 20;\r\n\r\n  OMC_DEF_RT_MIN_BUCKET_SIZE CONSTANT NUMBER := 10;\r\n\r\n  OMC_DEF_HIST_MIN_BUCKET_SIZE CONSTANT NUMBER := 10;\r\n\r\n  OMC_DEF_SQLTEXT_LEN CONSTANT NUMBER := 200;\r\n\r\n  VER_12_2 CONSTANT VARCHAR2(12) := '1202000000';\r\n  VER_12_1_2 CONSTANT VARCHAR2(12) := '1201000200';\r\n  VER_12_1 CONSTANT VARCHAR2(12) := '1201000000';\r\n  VER_12   CONSTANT VARCHAR2(12) := '1200000000';\r\n  VER_11_MIN CONSTANT VARCHAR2(12) := '1102000200';\r\n\r\n  TOP_ADD_INFO_COUNT      CONSTANT BINARY_INTEGER := 20;\r\n  MAX_INFO_TIME_LIMIT     CONSTANT BINARY_INTEGER := 2;\r\n\r\n  RSRC_CONS_CAT           CONSTANT VARCHAR2(128) := 'resource_consumption_cat';\r\n  SESS_ID_CAT             CONSTANT VARCHAR2(128) := 'session_identifiers_cat';\r\n  SESS_ATTR_CAT           CONSTANT VARCHAR2(128) := 'session_attributes_cat';\r\n  SQL_CAT                 CONSTANT VARCHAR2(128) := 'sql_cat';\r\n  PLSQL_CAT               CONSTANT VARCHAR2(128) := 'pl_sql_cat';\r\n  TARGET_CAT              CONSTANT VARCHAR2(128) := 'target_category';\r\n\r\n  ERR_DIMNAME_TOO_LONG CONSTANT NUMBER := -13720;\r\n  ERR_DIMNAME_INVALID  CONSTANT NUMBER := -13721;\r\n\r\n  FUNCTION STR_TO_ASCII(S IN VARCHAR) RETURN VARCHAR;\r\n\r\n  FUNCTION FETCH_SQLTEXT_LOCAL(P_SQLID IN VARCHAR, P_DBID IN NUMBER,\r\n                               P_TIME_LIMIT IN VARCHAR)\r\n  RETURN   VARCHAR;\r\n\r\n  FUNCTION FETCH_SQLTEXT_AWR(P_SQLID IN VARCHAR, P_DBID IN NUMBER,\r\n                             P_IS_PDB IN VARCHAR, P_TIME_LIMIT IN VARCHAR)\r\n  RETURN   VARCHAR;\r\n\r\n  FUNCTION FETCH_OBJ_NAME_LOCAL(P_OBJ_ID IN NUMBER, P_DBID IN NUMBER,\r\n                                P_CON_DBID IN NUMBER, P_TIME_LIMIT IN VARCHAR)\r\n  RETURN   VARCHAR;\r\n\r\n  FUNCTION FETCH_OBJ_NAME_AWR(P_OBJ_ID IN NUMBER, P_DBID IN NUMBER,\r\n                              P_CON_DBID IN NUMBER, P_IS_PDB IN VARCHAR,\r\n                              P_TIME_LIMIT IN VARCHAR)\r\n  RETURN   VARCHAR;\r\n\r\n  FUNCTION FETCH_PROCEDURE_NAME(P_OBJ_ID IN NUMBER, P_SUBOBJ_ID IN NUMBER,\r\n                                P_CON_DBID IN NUMBER, P_TIME_LIMIT IN VARCHAR)\r\n  RETURN VARCHAR;\r\n\r\n  FUNCTION FETCH_USER_NAME(P_USER_ID IN NUMBER, P_CON_DBID IN NUMBER,\r\n                           P_TIME_LIMIT IN VARCHAR)\r\n  RETURN VARCHAR;\r\n\r\n  FUNCTION GETCPUINFO(DBID IN NUMBER := NULL,\r\n                      OBSERVATIONTIME IN VARCHAR := NULL)\r\n  RETURN XMLTYPE;\r\n\r\n  FUNCTION GETTIMEPICKERREALTIME(\r\n      TIME_SINCE_SEC IN NUMBER := 3600\r\n    , SHOW_SQL       IN VARCHAR2 := 'n'\r\n    , VERBOSE_XML    IN VARCHAR2 := 'n')\r\n  RETURN XMLTYPE;\r\n\r\n  FUNCTION INCREMENTTIMEPICKER(\r\n      BEGIN_TIME_UTC IN VARCHAR2\r\n    , BUCKET_SIZE    IN NUMBER\r\n    , SHOW_SQL       IN VARCHAR2 := 'n'\r\n    , VERBOSE_XML    IN VARCHAR2 := 'n')\r\n  RETURN XMLTYPE;\r\n\r\n  FUNCTION GETTIMEPICKERHISTORICAL(\r\n      DBID           IN NUMBER := NULL\r\n    , BEGIN_TIME_UTC IN VARCHAR2 := NULL\r\n    , END_TIME_UTC   IN VARCHAR2 := NULL\r\n    , TIME_SINCE_SEC IN NUMBER := 86400\r\n    , SHOW_SQL       IN VARCHAR2 := 'n'\r\n    , VERBOSE_XML    IN VARCHAR2 := 'n')\r\n  RETURN XMLTYPE;\r\n\r\n  FUNCTION GETDATAREALTIME(\r\n      FILTER_LIST     IN VARCHAR2 := NULL\r\n    , TIME_SINCE_SEC  IN NUMBER := 3600\r\n    , SHOW_SQL        IN VARCHAR2 := 'n'\r\n    , VERBOSE_XML     IN VARCHAR2 := 'n'\r\n    , INCLUDE_BG      IN VARCHAR2 := 'n')\r\n  RETURN XMLTYPE;\r\n\r\n  FUNCTION INCREMENTDATA(\r\n      FILTER_LIST    IN VARCHAR2 := NULL\r\n    , BEGIN_TIME_UTC IN VARCHAR2\r\n    , BUCKET_SIZE    IN NUMBER\r\n    , SHOW_SQL       IN VARCHAR2 := 'n'\r\n    , VERBOSE_XML    IN VARCHAR2 := 'n'\r\n    , INCLUDE_BG      IN VARCHAR2 := 'n')\r\n  RETURN XMLTYPE;\r\n\r\n  FUNCTION GETDATAHISTORICAL(\r\n      DBID            IN NUMBER := NULL\r\n    , FILTER_LIST     IN VARCHAR2 := NULL\r\n    , BEGIN_TIME_UTC  IN VARCHAR2 := NULL\r\n    , END_TIME_UTC    IN VARCHAR2 := NULL\r\n    , TIME_SINCE_SEC  IN NUMBER := 86400\r\n    , SHOW_SQL        IN VARCHAR2 := 'n'\r\n    , VERBOSE_XML     IN VARCHAR2 := 'n'\r\n    , INCLUDE_BG      IN VARCHAR2 := 'n')\r\n  RETURN XMLTYPE;\r\n\r\nEND DBMS_ASH;\r\n<\/pre>\n<h2>DBMS_BDSQL:<\/h2>\n<pre class=\"height-set:true height:300 lang:plsql decode:true\">PACKAGE \"DBMS_BDSQL\" AUTHID DEFINER\r\n AS\r\n\r\n -- Here are the exceptions that can come from this module\r\n -- We're going to use RAISE_APPLICATION_EEROR to raise these errors\r\n\r\n NULL_CLUSTER_NAME_PASSED constant PLS_INTEGER := -20899;\r\n NULL_CURRENT_DB_USER_PASSED constant PLS_INTEGER := -20898;\r\n NULL_FOURTH_PARAMETER_PASSED constant PLS_INTEGER := -20897;\r\n INVALID_USERENV_ATTRIBUTE constant PLS_INTEGER := -20896;\r\n DUPLICATE_ROW constant PLS_INTEGER := -20895;\r\n ROLE_PRIV_ERR constant PLS_INTEGER := -20894;\r\n NULL_SYSCTX_PARM_HADOOP_PASSED constant PLS_INTEGER:= -20893;\r\n INVALID_NAME_FOR_US constant PLS_INTEGER := -20892;\r\n INVALID_NAME_ASSERT constant PLS_INTEGER := -20891;\r\n NO_ROWS_FOUND constant PLS_INTEGER := -20890;\r\n NOTHING_TO_REVOKE constant PLS_INTEGER := -20889;\r\n NAMESPACE_TOO_LONG constant PLS_INTEGER := -20888;\r\n HADOOP_USER_TOO_LONG constant PLS_INTEGER := -20887;\r\n AMBIGUOUS_ROW constant PLS_INTEGER := -20886;\r\n\r\n NAMESPACE_MAX_LEN constant PLS_INTEGER := 30;\r\n HADOOP_USER_MAX_LEN constant PLS_INTEGER := 30;\r\n\r\n --- DBMS_ASSERT.SIMPLE_SQL_NAME didn't like one of the names given\r\n assert_invalid_name EXCEPTION;\r\n  PRAGMA EXCEPTION_INIT(assert_invalid_name, -44003);\r\n --\r\n\r\n -- ADD_USER_MAP:\r\n --\r\n PROCEDURE ADD_USER_MAP(cluster_name IN VARCHAR2 DEFAULT '[DEFAULT]',\r\n                        current_database_user    IN VARCHAR2,  -- NOT NULL\r\n                    syscontext_namespace    IN VARCHAR2,   -- DEFAULT NULL\r\n                    syscontext_parm_hadoop_user IN VARCHAR2); -- NOT NULL\r\n\r\n -- REMOVE_USER_MAP:\r\n --\r\n PROCEDURE REMOVE_USER_MAP(\r\n                    cluster_name           IN VARCHAR2 DEFAULT '[DEFAULT]',\r\n                    current_database_user  IN VARCHAR2);   -- NOT NULL\r\n\r\n -- SEL_USERMAP:\r\n PROCEDURE SEL_USERMAP(cluster_name           IN VARCHAR2,\r\n                       current_database_user  IN VARCHAR2,\r\n                       mapping               OUT VARCHAR2,\r\n                       rc                    OUT PLS_INTEGER);\r\n\r\nEND DBMS_BDSQL;<\/pre>\n<p>Both packages are not yet officially documented so their usage are still unclear. They seem to be for internal use only. However, one thing I could notice is that <strong>DBMS_HADOOP<\/strong> now interacts with <strong>DBMS_BDSQL.SEL_USERMAP<\/strong>.<\/p>\n<p>Their unwrapped Package Bodys are pretty big to post here. I did some overall analysis in SQL Injection and at least they look clear =]<\/p>\n<b>Have you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-3195 jlk' href='javascript:void(0)' data-task='like' data-post_id='3195' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-3195 lc'>0<\/span><\/a><\/div><\/div> <div class='status-3195 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>After applying the 180417 PSU and BP over 12.1.0.2 Database, I&#8217;ve noted 2 new packages created on the database: DBMS_ASH and DBMS_BDSQL. VERSION PATCH OWNER TYPE NAME &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; 12.1.0.2 PSU &amp; BP SYS PACKAGE DBMS_ASH 12.1.0.2 BP ONLY SYS PACKAGE DBMS_BDSQL 12.1.0.2 BP ONLY SYS PACKAGE BODY DBMS_ASH 12.1.0.2 BP ONLY &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":3207,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-3195","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>New DBMS_ASH and DBMS_BDSQL packages - Apr2018 Patch - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/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.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\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.dbarj.com.br\\\/en\\\/2018\\\/04\\\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/04\\\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"New DBMS_ASH and DBMS_BDSQL packages &#8211; Apr2018 Patch\",\"datePublished\":\"2018-04-25T13:58:04+00:00\",\"dateModified\":\"2018-04-25T15:49:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/04\\\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\\\/\"},\"wordCount\":127,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/04\\\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/Screen-Shot-2018-04-25-at-11.04.21.png\",\"articleSection\":[\"Oracle Database General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/04\\\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/04\\\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/04\\\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\\\/\",\"name\":\"New DBMS_ASH and DBMS_BDSQL packages - Apr2018 Patch - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/04\\\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/04\\\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/Screen-Shot-2018-04-25-at-11.04.21.png\",\"datePublished\":\"2018-04-25T13:58:04+00:00\",\"dateModified\":\"2018-04-25T15:49:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/04\\\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/04\\\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/04\\\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/Screen-Shot-2018-04-25-at-11.04.21.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/Screen-Shot-2018-04-25-at-11.04.21.png\",\"width\":1072,\"height\":464},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/04\\\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New DBMS_ASH and DBMS_BDSQL packages - Apr2018 Patch\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New DBMS_ASH and DBMS_BDSQL packages - Apr2018 Patch - DBA - Rodrigo Jorge - Oracle Tips and Guides","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.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"New DBMS_ASH and DBMS_BDSQL packages &#8211; Apr2018 Patch","datePublished":"2018-04-25T13:58:04+00:00","dateModified":"2018-04-25T15:49:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/"},"wordCount":127,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2018\/04\/Screen-Shot-2018-04-25-at-11.04.21.png","articleSection":["Oracle Database General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/","url":"https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/","name":"New DBMS_ASH and DBMS_BDSQL packages - Apr2018 Patch - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/#primaryimage"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2018\/04\/Screen-Shot-2018-04-25-at-11.04.21.png","datePublished":"2018-04-25T13:58:04+00:00","dateModified":"2018-04-25T15:49:02+00:00","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/#primaryimage","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2018\/04\/Screen-Shot-2018-04-25-at-11.04.21.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2018\/04\/Screen-Shot-2018-04-25-at-11.04.21.png","width":1072,"height":464},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2018\/04\/new-dbms_ash-and-dbms_bdsql-packages-apr2018-patch\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"New DBMS_ASH and DBMS_BDSQL packages - Apr2018 Patch"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/3195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=3195"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/3195\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media\/3207"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=3195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=3195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=3195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}