{"id":10826,"date":"2018-02-14T10:17:47","date_gmt":"2018-02-14T09:17:47","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/"},"modified":"2018-02-14T10:17:47","modified_gmt":"2018-02-14T09:17:47","slug":"could-you-trust-option_packs_usage_statistics-sql","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/","title":{"rendered":"Can you trust option_packs_usage_statistics.sql ?"},"content":{"rendered":"

Introduction<\/h3>\n

As a former Oracle LMS qualified auditor my opinion is sometimes requested before\/during\/after an Oracle LMS audit or simply to ensure a customer that his Oracle database is 100% in conformity with Oracle Licensing Policy. Even if<\/p>\n

\u201cThe Oracle License Management Services (LMS) Group is the only Oracle group authorized to review and provide opinions on compliance status and will provide guidance, education and impartial opinions on a customer or partner’s compliance state. For more information please visit the following website: http:\/\/www.oracle.com\/corporate\/lms.\u201d<\/em><\/p>\n

I very do hope that you will find interesting tips in this blog.<\/p>\n

Most of the time when a customer would like to check which Oracle options are used by his database infrastructure he is using the well known script \u201coption_packs_usage_statistics.sql<\/a>\u201d. dbi services did checks of the options detected by the script provided by Oracle (My Oracle Support DOC ID 1317265.1<\/em><\/a>). Depending on your database usage this script will detect the usage of different options, but could you really trust the output of this script and how to interpret the output ?<\/p>\n

Can we trust the output of option_packs_usage_statistics.sql ?<\/h3>\n

The answer is quite easy and short: NO you can\u2019t !<\/p>\n

Why? Because as for any software there are some bugs and these bugs lead to false positive detection. The good news is that some of these false positive are documented on My Oracle Support. Indeed the script options_packs_usage_statistics.sql<\/em> used and provided by Oracle has 14 documented bugs (My Oracle Support Doc ID 1309070.1<\/em><\/a>) and some other non-documented bugs (eg. My Oracle Support BUG 17164904<\/em>). These bugs are related to:<\/p>\n

1.\u00a0\u00a0 \u00a0Bug 11902001 – Exclude default users for Feature usage tracking for Securefiles option
\n2.\u00a0\u00a0 \u00a0Bug 11902142 – Exclude default users for Feature usage tracking for Advanced Compression option
\n3.\u00a0\u00a0 \u00a0Bug 19618850 – SOLUTION TO PREVENT UNINTENTED ORACLE OPTION USAGE
\n4.\u00a0\u00a0 \u00a0Query against DBA_FEATURE_USAGE_STATISTICS is not a true test for use of SDO
\n5.\u00a0\u00a0 \u00a0Bug 16088534 : RMAN default Backup BZIP2 Compression feature is reported wrongly as as an Advanced Compression feature
\n6.\u00a0\u00a0 \u00a0Bug 22122625 – GETTING FALSE POSITIVES ON USAGE OF ADVANCED INDEX COMPRESSION
\n7.\u00a0\u00a0 \u00a0Bug 24844549 – ADVANCED INDEX COMPRESSION SHOWS USAGE IN DBA_FEATURE_USAGE_STATISTICS WITH HCC
\n8.\u00a0\u00a0 \u00a0Bug 16859747 – DBA_FEATURE_USAGE_STATISTICS SHOWS INCORRECT USAGE FOR HEAPCOMPRESSION
\n9.\u00a0\u00a0 \u00a0Bug 16563444 – HEAT MAP FEATURE USAGE TRACKING IS NOT CORRECT
\n10.\u00a0\u00a0 \u00a0Bug 19317899 – IMC: IN-MEMORY OPTION IS REPORTED AS BEING USED EVEN INMEMORY_SIZE IS 0
\n11.\u00a0\u00a0 \u00a0Bug 19308780 – DO NOT FEATURE TRACK OBJECTS FOR IM WHEN INMEMORY_SIZE = 0
\n12.\u00a0\u00a0 \u00a0Bug 21248059 – DBA_FEATURE_USAGE_STATISTICS BUG IN TRACKING “HYBRID COLUMNAR COMPRESSION” FEAT
\n13.\u00a0\u00a0 \u00a0Bug 25661076 – DBA_FEATURE_USAGE_STATISTICS INCORRECTLY SHOWS SPATIAL USAGE IN 12C
\n14.\u00a0\u00a0 \u00a0Bug 23734270 – DBA_FEATURE_USAGE_STATISTICS SHOWS PERMANENT USAGE OF REAL-TIME SQL MONITORING<\/p>\n

These bugs may lead to the detection of features such as : Automatic Maintenance – SQL Tuning advisor<\/em> & Automatic SQL Tuning Advisor<\/em>, Real-Time SQL monitoring<\/em>, Advanced security – Oracle Utility Datapump (Export)<\/em> and Oracle Utility Datapump (Import)<\/em>, Advanced Compression – Heat Map<\/em>, Advanced Compression – Oracle Utility Datapump (Export)<\/em> and Oracle Utility Datapump (Import)<\/em>, aso\u2026.<\/p>\n

Of course these bugs make the real options usage analysis especially difficult even for an experimented Database Administrator. Additionally the Oracle database in version 12 could make usage of options in maintenance windows without manual activation. That the case for instance of options such as : Automatic Maintenance – SQL Tuning Advisor<\/em>, Automatic SQL Tuning Advisor<\/em> and Automatic SQL Tuning Advisor<\/em>.<\/p>\n

14. Bug 23734270 – DBA_FEATURE_USAGE_STATISTICS SHOWS PERMANENT USAGE OF REAL-TIME SQL MONITORING<\/em>
\nOn a freshly created 12c database, DBA_FEATURE_USAGE_STATISTICS shows usage of Real-Time SQL Monitoring even if no reports have been run from OEM pages or with DBMS_SQL_MONITOR.<\/em>
\nReason :SQL Monitor reports are automatically generated and saved in AWR but should be considered as system usage.<\/em>
\nThis behavior is the same for all 12 releases and is not present in 11.2. – <\/em>Extract of My Oracle Support Bug 23734270<\/p>\n

Even if LMS team is not using option_packs_usage_statistics.sql<\/em> script, the output of LMS_Collection_Tool (ReviewLite.sql)<\/em> is quite the same. The direct consequence in case of an Oracle LMS audit is that the auditor could detect options that you simply never used and you will have to make the proof of non usage\u2026 if not you will have to pay the invoice following the final LMS report as stated in your LMS preliminary\/final report.<\/p>\n

\u201cBased upon the information provided to License Management Services, the following licensing issues need to be resolved within 30 days from the date of the Final Report.\u201d<\/em>
\n \u2026<\/em>
\n \u201cIn accordance to Oracle compliance policies, backdated support charges are due for the period of unlicensed usage of Oracle Programs.<\/em>
\n Please provide your feedback on this preliminary report within 10 days from the presentation of this report.\u201d- extract of an Oracle LMS audit<\/em><\/p>\n

Even if I do not have hundreds of cases where the LMS department made wrong detection, I\u2019ve concrete stories where LMS team detected some false positives. Last case was related to the detection of more than 700 usage of Advanced compression due to unpublished BUG 17164904<\/em>. Thanks to the metalink Doc ID 1993134.1<\/em><\/a>, the bug is explained:<\/p>\n

In 12.1.0.1,\u00a0 the compression counter is incorrectly incremented (COMPRESSCNT=1) for compression=metadata_only (either explicitly or by default) due to unpublished BUG 17164904 – INCORRECT FEATURE USAGE STATISTICS FOR DATA PUMP COMPRESSION, fixed with 12.1.0.2.<\/em><\/p>\n

How to interpret the output of option_packs_usage_statistics.sql ?<\/h3>\n

Sometimes this script could provide you some non sense option usage. That the case for instance for features provided only since database version 12c but detected on your old database version 11g. In such a case simply edit the option_packs_usage_statistics.sql<\/em> script and have a look on the comments. A perfect example of that is illustrated by the detection of Heat Map usage in database version 11g whereas this option is available since version 12c. You can see below another example of wrong options detection related to \u201cAutomatic Maintenance \u2013 SQL Tuning Advisor<\/em>\u201d and \u201cAutomatic SQL Tuning Advisor<\/em>\u201d:<\/p>\n

…<\/em>
\nSELECT ‘Tuning Pack’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , ‘Automatic Maintenance – SQL Tuning Advisor’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , ‘^12\\.<\/strong>‘\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , ‘INVALID<\/strong>‘ from dual union all\u00a0 — system usage in the maintenance window<\/strong><\/em>
\nSELECT ‘Tuning Pack’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , ‘Automatic SQL Tuning Advisor’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , ‘^11\\.2|^12\\<\/strong>.’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , ‘INVALID<\/strong>‘ from dual union all\u00a0 — system usage in the maintenance window<\/strong><\/em>
\nSELECT ‘Tuning Pack’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , ‘Real-Time SQL Monitoring’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , ‘^11\\.2’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , ‘ ‘\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 from dual union all<\/em>
\n…<\/em><\/p>\n

This INVALID clause explain that the detection of this option is due to system usage in the maintenance window in version 12 (Automatic Maintenance – SQL Tuning Advisor) and in version 11.2 and 12 for Automatic SQL Tuning Advisor. This is also explained few lines after in the option_packs_usage_statistics.sql<\/em> script :<\/p>\n

…
\nwhere nvl(CONDITION, ‘-‘) != ‘INVALID<\/strong>‘\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 — ignore features for which licensing is not required without further conditions<\/strong><\/em>
\n\u00a0\u00a0\u00a0 and not (CONDITION = ‘C003’ and CON_ID not in (0, 1))\u00a0 — multiple PDBs are visible only in CDB$ROOT; PDB level view is not relevant<\/em>
\n)
\n…
\n<\/em><\/p>\n

In such a case the option does not have to be considered since the normal behavior of an oracle database in version 12 is to use this option in the maintenance window. This is just an example to illustrate that some detected option does not have to be licensed as explained in the script.<\/p>\n

Conclusion<\/h3>\n

I very do hope that this blog helps you to have a better understanding of how to detect what your database infrastructure really uses in terms of Oracle options. Anyway if you are convinced that you do not use an Oracle database option despite the output of scripts such as option-packs_usage_statistics or ReviewLite which proofs the opposite, have a look on My Oracle Support. Look for bug related to wrong detection of this feature and with a little bit of luck you will find something interesting. Oracle is definitively engineered for heroes…<\/p>\n

\"Oracle<\/a>
Oracle Engineered For Heroes<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"

Introduction As a former Oracle LMS qualified auditor my opinion is sometimes requested before\/during\/after an Oracle LMS audit or simply to ensure a customer that his Oracle database is 100% in conformity with Oracle Licensing Policy. Even if \u201cThe Oracle License Management Services (LMS) Group is the only Oracle group authorized to review and provide […]<\/p>\n","protected":false},"author":10,"featured_media":10827,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[1288,1289,1290],"type_dbi":[],"class_list":["post-10826","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-option","tag-option_packs_usage_statistics-sql","tag-reviewlite"],"acf":[],"yoast_head":"\nCan you trust option_packs_usage_statistics.sql ? - dbi Blog<\/title>\n<meta name=\"description\" content=\"Could you really trust the options detection of Oracle script option_packs_usage_statistics.sql (My Oracle Support DOC ID 1317265.1) ?\" \/>\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\/could-you-trust-option_packs_usage_statistics-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Can you trust option_packs_usage_statistics.sql ?\" \/>\n<meta property=\"og:description\" content=\"Could you really trust the options detection of Oracle script option_packs_usage_statistics.sql (My Oracle Support DOC ID 1317265.1) ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-14T09:17:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EngineeredForHeroes.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"1000\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Gr\u00e9gory Steulet\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gr\u00e9gory Steulet\" \/>\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\/could-you-trust-option_packs_usage_statistics-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/\"},\"author\":{\"name\":\"Gr\u00e9gory Steulet\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\"},\"headline\":\"Can you trust option_packs_usage_statistics.sql ?\",\"datePublished\":\"2018-02-14T09:17:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/\"},\"wordCount\":1303,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EngineeredForHeroes.jpg\",\"keywords\":[\"option\",\"option_packs_usage_statistics.sql\",\"reviewlite\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/\",\"name\":\"Can you trust option_packs_usage_statistics.sql ? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EngineeredForHeroes.jpg\",\"datePublished\":\"2018-02-14T09:17:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\"},\"description\":\"Could you really trust the options detection of Oracle script option_packs_usage_statistics.sql (My Oracle Support DOC ID 1317265.1) ?\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EngineeredForHeroes.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EngineeredForHeroes.jpg\",\"width\":1600,\"height\":1000,\"caption\":\"Oracle Engineered For Heroes\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Can you trust option_packs_usage_statistics.sql ?\"}]},{\"@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\/7609faada8e4d63e04a28ae29e227098\",\"name\":\"Gr\u00e9gory Steulet\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"caption\":\"Gr\u00e9gory Steulet\"},\"description\":\"Gr\u00e9gory Steulet has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies and high availability solutions (Oracle DataGuard, Data Replication Block Device). His expertise also includes Avaloq banking applications, as well as the open source field (MySQL, Unix\/Linux, etc.). Gr\u00e9gory Steulet is \\\"Oracle Certified Professional 10g\\\", \\\"MySQL Cluster 5.1 Certified\\\", and \\\"Avaloq Certified Professional 2.6\\\". Prior to joining dbi services, Gr\u00e9gory Steulet was Senior Consultant at Trivadis in Lausanne. He also worked as IT Administrator at Box Telecom in Miami Beach, Florida (USA). Gr\u00e9gory Steulet has an Executive MBA from the International Institute of Management in Technology, Fribourg (CH). He also holds a Bachelor's Degree in Business Administration and Computer Science from the University of Applied Sciences Western Switzerland. His branch-related experience covers Telecommunications, Financial Services \/ Banking, Logistics, Pharma etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/gregory-steulet\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Can you trust option_packs_usage_statistics.sql ? - dbi Blog","description":"Could you really trust the options detection of Oracle script option_packs_usage_statistics.sql (My Oracle Support DOC ID 1317265.1) ?","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\/could-you-trust-option_packs_usage_statistics-sql\/","og_locale":"en_US","og_type":"article","og_title":"Can you trust option_packs_usage_statistics.sql ?","og_description":"Could you really trust the options detection of Oracle script option_packs_usage_statistics.sql (My Oracle Support DOC ID 1317265.1) ?","og_url":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/","og_site_name":"dbi Blog","article_published_time":"2018-02-14T09:17:47+00:00","og_image":[{"width":1600,"height":1000,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EngineeredForHeroes.jpg","type":"image\/jpeg"}],"author":"Gr\u00e9gory Steulet","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Gr\u00e9gory Steulet","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/"},"author":{"name":"Gr\u00e9gory Steulet","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098"},"headline":"Can you trust option_packs_usage_statistics.sql ?","datePublished":"2018-02-14T09:17:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/"},"wordCount":1303,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EngineeredForHeroes.jpg","keywords":["option","option_packs_usage_statistics.sql","reviewlite"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/","url":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/","name":"Can you trust option_packs_usage_statistics.sql ? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EngineeredForHeroes.jpg","datePublished":"2018-02-14T09:17:47+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098"},"description":"Could you really trust the options detection of Oracle script option_packs_usage_statistics.sql (My Oracle Support DOC ID 1317265.1) ?","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EngineeredForHeroes.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EngineeredForHeroes.jpg","width":1600,"height":1000,"caption":"Oracle Engineered For Heroes"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Can you trust option_packs_usage_statistics.sql ?"}]},{"@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\/7609faada8e4d63e04a28ae29e227098","name":"Gr\u00e9gory Steulet","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","caption":"Gr\u00e9gory Steulet"},"description":"Gr\u00e9gory Steulet has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies and high availability solutions (Oracle DataGuard, Data Replication Block Device). His expertise also includes Avaloq banking applications, as well as the open source field (MySQL, Unix\/Linux, etc.). Gr\u00e9gory Steulet is \"Oracle Certified Professional 10g\", \"MySQL Cluster 5.1 Certified\", and \"Avaloq Certified Professional 2.6\". Prior to joining dbi services, Gr\u00e9gory Steulet was Senior Consultant at Trivadis in Lausanne. He also worked as IT Administrator at Box Telecom in Miami Beach, Florida (USA). Gr\u00e9gory Steulet has an Executive MBA from the International Institute of Management in Technology, Fribourg (CH). He also holds a Bachelor's Degree in Business Administration and Computer Science from the University of Applied Sciences Western Switzerland. His branch-related experience covers Telecommunications, Financial Services \/ Banking, Logistics, Pharma etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/gregory-steulet\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10826","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10826"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10826\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/10827"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10826"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}