1. Automatic Indexing (only available on EE-ES and ExaCS)<\/strong><\/p>\nOracle continually evaluates the executing SQL and the underlying tables to determine which indexes to automatically create and which ones to potentially remove.<\/p>\n
Documentation:<\/p>\n
You can use the AUTO_INDEX_MODE configuration setting to enable or disable automatic indexing in a database.<\/p>\n
The following statement enables automatic indexing in a database and creates any new auto indexes as visible indexes, so that they can be used in SQL statements:<\/p>\n
\nEXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','IMPLEMENT');
\n<\/code><\/p>\nThe following statement enables automatic indexing in a database, but creates any new auto indexes as invisible indexes, so that they cannot be used in SQL statements:<\/p>\n
\nEXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','REPORT ONLY');
\n<\/code><\/p>\nThe following statement disables automatic indexing in a database, so that no new auto indexes are created, and the existing auto indexes are disabled:<\/p>\n
\nEXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','OFF');
\n<\/code><\/p>\nShow a report of automatic indexing activity:<\/p>\n
\nset serveroutput on size unlimited lines 200 pages 200
\ndeclare
\n report clob := null;
\nbegin
\n report := DBMS_AUTO_INDEX.REPORT_LAST_ACTIVITY();
\n dbms_output.put_line(report);
\nend;
\n\/
\n<\/code><\/p>\nIn a test I ran some statements repeatedly on a table T1 (which contains 32 times the data of all_objects). The table has no index:<\/p>\n
\nSQL> select * from t1 where object_id=:b1;
\nSQL> select * from t1 where data_object_id=:b2;
\n<\/code><\/p>\nAfter some time indexes were created automatically:<\/p>\n
\nSQL> select table_name, index_name, auto from ind;
\n
\nTABLE_NAME INDEX_NAME AUT
\n-------------------------------- -------------------------------- ---
\nT1 SYS_AI_5mzwj826444wv YES
\nT1 SYS_AI_gs3pbvztmyaqx YES
\n
\n2 rows selected.
\n
\nSQL> select dbms_metadata.get_ddl('INDEX','SYS_AI_5mzwj826444wv') from dual;
\n
\nDBMS_METADATA.GET_DDL('INDEX','SYS_AI_5MZWJ826444WV')
\n------------------------------------------------------------------------------------
\nCREATE INDEX \"CBLEILE\".\"SYS_AI_5mzwj826444wv\" ON \"CBLEILE\".\"T1\" (\"OBJECT_ID\") AUTO
\nPCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
\nSTORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
\nPCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
\nBUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
\nTABLESPACE \"USERS\"
\n<\/code><\/p>\n2. Real-Time Statistics (only available on EE-ES and ExaCS)<\/strong><\/p>\nThe database automatically gathers real-time statistics during conventional DML operations. You can see in the Note-section of dbms_xplan.display_cursor when stats used to optimize a Query were gathered during DML:<\/p>\n
\nSQL> select * from table(dbms_xplan.display_cursor);
\n
\nPLAN_TABLE_OUTPUT
\n-------------------------------------------------------------------------------------------------------
\nSQL_ID 7cd3thpuf7jxm, child number 0
\n-------------------------------------
\n
\nselect * from t2 where object_id=:y
\n
\nPlan hash value: 1513984157
\n--------------------------------------------------------------------------
\n| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
\n--------------------------------------------------------------------------
\n| 0 | SELECT STATEMENT | | | | 24048 (100)| |
\n|* 1 | TABLE ACCESS FULL| T2 | 254 | 31242 | 24048 (1)| 00:00:01 |
\n--------------------------------------------------------------------------
\n
\nPredicate Information (identified by operation id):
\n---------------------------------------------------
\n
\n1 - filter(\"OBJECT_ID\"=:Y)
\n
\nNote
\n-----
\n- dynamic statistics used: statistics for conventional DML
\n<\/code><\/p>\n3. Quarantine problematic SQL (only available on EE-ES and ExaCS)<\/strong><\/p>\nRunaway SQL statements terminated by Resource Manager due to excessive consumption of processor and I\/O resources can now be automatically quarantined. I.e. instead of letting the SQL run until it reaches a resource plan limit, the SQL is not executed at all.<\/p>\n
E.g. create a resource plan which limits SQL-exec-time for User CBLEILE to 16 seconds:<\/p>\n
\nbegin
\n -- Create a pending area
\n dbms_resource_manager.create_pending_area();
\n...
\n dbms_resource_manager.create_plan_directive(
\n plan => 'LIMIT_RESOURCE',
\n group_or_subplan => 'TEST_RUNAWAY_GROUP',
\n comment => 'Terminate SQL statements when they exceed the' ||'execution time of 16 seconds',
\n switch_group => 'CANCEL_SQL',
\n switch_time => 16,
\n switch_estimate => false);
\n...
\n -- Set the initial consumer group of the 'CBLEILE' user to 'TEST_RUNAWAY_GROUP'
\n dbms_resource_manager.set_initial_consumer_group('CBLEILE','TEST_RUNAWAY_GROUP');
\nend;
\n\/
\n<\/code><\/p>\nA SQL-Statement with SQL_ID 12jc0zpmb85tm executed by CBLEILE runs in the 16 seconds limit:<\/p>\n
\nSQL> select count(*) X
\n2 from kill_cpu
\n3 connect by n > prior n
\n4 start with n = 1
\n5 ;
\nfrom kill_cpu
\n*
\nERROR at line 2:
\nORA-00040: active time limit exceeded - call aborted
\n
\nElapsed: 00:00:19.85
\n<\/code><\/p>\nSo I quarantine the SQL now:<\/p>\n
\nset serveroutput on size unlimited
\nDECLARE
\nquarantine_config VARCHAR2(80);
\nBEGIN
\nquarantine_config := DBMS_SQLQ.CREATE_QUARANTINE_BY_SQL_ID(
\nSQL_ID => '12jc0zpmb85tm');
\ndbms_output.put_line(quarantine_config);
\nEND;
\n\/
\n
\nSQL_QUARANTINE_1d93x3d6vumvs
\n
\nPL\/SQL procedure successfully completed.
\n
\nSQL> select NAME,ELAPSED_TIME,ENABLED from dba_sql_quarantine;
\n
\nNAME ELAPSED_TIME ENA
\n---------------------------------------- -------------------------------- ---
\nSQL_QUARANTINE_1d93x3d6vumvs ALWAYS YES
\n<\/code><\/p>\nOther CBLEILE-session:<\/p>\n
\nSQL> select count(*) X
\n2 from kill_cpu
\n3 connect by n > prior n
\n4 start with n = 1
\n5 ;
\nfrom kill_cpu
\n*
\n
\nERROR at line 2:
\nORA-56955: quarantined plan used
\nElapsed: 00:00:00.00
\n
\nSQL> !oerr ora 56955
\n56955, 00000, \"quarantined plan used\"
\n\/\/ *Cause: A quarantined plan was used for this statement.
\n\/\/ *Action: Increase the Oracle Database Resource Manager limits or use a new plan.
\n<\/code><\/p>\n–> The SQL does not run for 16 seconds, but is stopped immediately (is under quarantine). You can define the Plan-Hash-Value for which a SQL should be in quarantine and define quarantine thresholds. E.g. 20 seconds for the elapsed time. As long as the resource plan is below those 20 seconds the SQL is under quarantine. If the resource plan is defined to be above 20 seconds execution time limit, the SQL is executed.<\/p>\n
4. Active Standby DML Redirect (only available with Active Data Guard)<\/strong><\/p>\nOn Active Data Guard you may allow moderate write activity. These writes are then transparently redirected to the primary database and written there first (to ensure consistency) and then the changes are shipped back to the standby. This approach allows applications to use the standby for moderate write workloads.<\/p>\n
5. Hybrid Partitioned Tables<\/strong><\/p>\nCreate partitioned tables where some partitions are inside and some partitions are outside the database (on filesystem, on a Cloud-Filesystem-service or on a Hadoop Distributed File System (HDFS)). This allows e.g. “cold” partitions to remain accessible, but on cheap storage.<\/p>\n
Here an example with 3 partitions external (data of 2016-2018) and 1 partition in the DB (data of 2019):<\/p>\n
\n!mkdir -p \/u01\/my_data\/sales_data1
\n!mkdir -p \/u01\/my_data\/sales_data2
\n!mkdir -p \/u01\/my_data\/sales_data3
\n!echo \"1,1,01-01-2016,1,1,1000,2000\" > \/u01\/my_data\/sales_data1\/sales2016_data.txt
\n!echo \"2,2,01-01-2017,2,2,2000,4000\" > \/u01\/my_data\/sales_data2\/sales2017_data.txt
\n!echo \"3,3,01-01-2018,3,3,3000,6000\" > \/u01\/my_data\/sales_data3\/sales2018_data.txt
\n
\nconnect \/ as sysdba
\nalter session set container=pdb1;
\n
\nCREATE DIRECTORY sales_data1 AS '\/u01\/my_data\/sales_data1';
\nGRANT READ,WRITE ON DIRECTORY sales_data1 TO cbleile;
\n
\nCREATE DIRECTORY sales_data2 AS '\/u01\/my_data\/sales_data2';
\nGRANT READ,WRITE ON DIRECTORY sales_data2 TO cbleile;
\n
\nCREATE DIRECTORY sales_data3 AS '\/u01\/my_data\/sales_data3';
\nGRANT READ,WRITE ON DIRECTORY sales_data3 TO cbleile;
\n
\nconnect cbleile\/difficult_password@pdb1
\n
\nCREATE TABLE hybrid_partition_table
\n( prod_id NUMBER NOT NULL,
\ncust_id NUMBER NOT NULL,
\ntime_id DATE NOT NULL,
\nchannel_id NUMBER NOT NULL,
\npromo_id NUMBER NOT NULL,
\nquantity_sold NUMBER(10,2) NOT NULL,
\namount_sold NUMBER(10,2) NOT NULL
\n)
\nEXTERNAL PARTITION ATTRIBUTES (
\nTYPE ORACLE_LOADER
\nDEFAULT DIRECTORY sales_data1
\nACCESS PARAMETERS(
\nFIELDS TERMINATED BY ','
\n(prod_id,cust_id,time_id DATE 'dd-mm-yyyy',channel_id,promo_id,quantity_sold,amount_sold)
\n)
\nREJECT LIMIT UNLIMITED
\n)
\nPARTITION BY RANGE (time_id)
\n(
\nPARTITION sales_2016 VALUES LESS THAN (TO_DATE('01-01-2017','dd-mm-yyyy')) EXTERNAL
\nLOCATION ('sales2016_data.txt'),
\nPARTITION sales_2017 VALUES LESS THAN (TO_DATE('01-01-2018','dd-mm-yyyy')) EXTERNAL
\nDEFAULT DIRECTORY sales_data2 LOCATION ('sales2017_data.txt'),
\nPARTITION sales_2018 VALUES LESS THAN (TO_DATE('01-01-2019','dd-mm-yyyy')) EXTERNAL
\nDEFAULT DIRECTORY sales_data3 LOCATION ('sales2018_data.txt'),
\nPARTITION sales_2019 VALUES LESS THAN (TO_DATE('01-01-2020','dd-mm-yyyy'))
\n);
\n
\ninsert into hybrid_partition_table values (4,4,to_date('01-01-2019','dd-mm-yyyy'),4,4,4000,8000);
\n
\ncommit;
\n
\nSQL> select * from hybrid_partition_table where time_id in (to_date('01-01-2017','dd-mm-yyyy'),to_date('01-01-2019','dd-mm-yyyy'));
\n
\nPROD_ID CUST_ID TIME_ID CHANNEL_ID PROMO_ID QUANTITY_SOLD AMOUNT_SOLD
\n---------- ---------- --------- ---------- ---------- ------------- -----------
\n2 2 01-JAN-17 2 2 2000 4000
\n4 4 01-JAN-19 4 4 4000 8000
\n
\n2 rows selected.
\n
\nSQL> select * from table(dbms_xplan.display_cursor);
\n
\nPLAN_TABLE_OUTPUT
\n-------------------------------------------------------------------------------
\nSQL_ID c5s33u5kanzb5, child number 0
\n-------------------------------------
\nselect * from hybrid_partition_table where time_id in
\n(to_date('01-01-2017','dd-mm-yyyy'),to_date('01-01-2019','dd-mm-yyyy'))
\n
\nPlan hash value: 2612538111
\n
\n-------------------------------------------------------------------------------------------------------------------------
\n| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |
\n-------------------------------------------------------------------------------------------------------------------------
\n| 0 | SELECT STATEMENT | | | | 83 (100)| | | |
\n| 1 | PARTITION RANGE INLIST | | 246 | 21402 | 83 (0)| 00:00:01 |KEY(I) |KEY(I) |
\n|* 2 | TABLE ACCESS HYBRID PART FULL| HYBRID_PARTITION_TABLE | 246 | 21402 | 83 (0)| 00:00:01 |KEY(I) |KEY(I) |
\n|* 3 | TABLE ACCESS FULL | HYBRID_PARTITION_TABLE | | | | |KEY(I) |KEY(I) |
\n-------------------------------------------------------------------------------------------------------------------------
\n
\nPredicate Information (identified by operation id):
\n---------------------------------------------------
\n
\n2 - filter((SYS_OP_XTNN(\"HYBRID_PARTITION_TABLE\".\"AMOUNT_SOLD\",\"HYBRID_PARTITION_TABLE\".\"QUANTITY_SOLD\",\"HYBRID_PARTITION_TABLE\".\"PROMO_ID\",\"HYBRID_PARTITION_TABLE\".\"CHANNEL_ID\",\"HYBRID_PARTITION_TABLE\".\"TIME_ID\",\"HYBRID_PARTITION_TABLE\".\"CUST_ID\",\"HYBRID_PARTITION_TABLE\".\"PROD_ID\") AND INTERNAL_FUNCTION(\"TIME_ID\")))
\n
\n3 - filter((SYS_OP_XTNN(\"HYBRID_PARTITION_TABLE\".\"AMOUNT_SOLD\",\"HYBRID_PARTITION_TABLE\".\"QUANTITY_SOLD\",\"HYBRID_PARTITION_TABLE\".\"PROMO_ID\",\"HYBRID_PARTITION_TABLE\".\"CHANNEL_ID\",\"HYBRID_PARTITION_TABLE\".\"TIME_ID\",\"HYBRID_PARTITION_TABLE\".\"CUST_ID\",\"HYBRID_PARTITION_TABLE\".\"PROD_ID\") AND INTERNAL_FUNCTION(\"TIME_ID\")))
\n<\/code><\/p>\n6. Memoptimized Rowstore<\/strong><\/p>\nEnables fast data inserts into Oracle Database 19c from applications, such as Internet of Things (IoT), which ingest small, high volume transactions with a minimal amount of transactional overhead.<\/p>\n
7. 3 PDBs per Multitenant-DB without having to pay for the Multitenant option<\/strong><\/p>\nBeginning with 19c it is allowed to create 3 PDBs in a Container-DB without requiring the Mutitenant-Option license from Oracle. As the single- or multi-tenant DB becomes a must in Oracle 20, it is a good idea to start using the container-DB architecture with 19c already.<\/p>\n
Please let me know your experience with Oracle 19c.<\/h3>\n","protected":false},"excerpt":{"rendered":"
Oracle 19c has been released quite a while ago already and some customers already run it in Production. However, as it is the long term supported release, I thought I blog about some interesting information and features around 19c to encourage people to migrate to it. Download Oracle 19c: https:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/downloads or https:\/\/edelivery.oracle.com (search e.g. for […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[280,1672,96,1171],"type_dbi":[],"class_list":["post-12870","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-oracle","tag-database","tag-new-features","tag-oracle","tag-oracle-19c"],"acf":[],"yoast_head":"\n
Oracle 19c - 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-19c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 19c\" \/>\n<meta property=\"og:description\" content=\"Oracle 19c has been released quite a while ago already and some customers already run it in Production. However, as it is the long term supported release, I thought I blog about some interesting information and features around 19c to encourage people to migrate to it. Download Oracle 19c: https:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/downloads or https:\/\/edelivery.oracle.com (search e.g. for […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-09T08:33:46+00:00\" \/>\n<meta name=\"author\" content=\"Clemens Bleile\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ifgtxD2SrQ8r!YuXj\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Clemens Bleile\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 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-19c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Oracle 19c\",\"datePublished\":\"2019-10-09T08:33:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/\"},\"wordCount\":863,\"commentCount\":0,\"keywords\":[\"database\",\"New Features\",\"Oracle\",\"Oracle 19c\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/\",\"name\":\"Oracle 19c - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2019-10-09T08:33:46+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 19c\"}]},{\"@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\/0ac04011f60f2e93c115358d0789c2da\",\"name\":\"Clemens Bleile\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"caption\":\"Clemens Bleile\"},\"description\":\"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.\",\"sameAs\":[\"https:\/\/www.dbi-services.com\",\"https:\/\/x.com\/ifgtxD2SrQ8r!YuXj\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle 19c - 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-19c\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 19c","og_description":"Oracle 19c has been released quite a while ago already and some customers already run it in Production. However, as it is the long term supported release, I thought I blog about some interesting information and features around 19c to encourage people to migrate to it. Download Oracle 19c: https:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/downloads or https:\/\/edelivery.oracle.com (search e.g. for […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/","og_site_name":"dbi Blog","article_published_time":"2019-10-09T08:33:46+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Oracle 19c","datePublished":"2019-10-09T08:33:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/"},"wordCount":863,"commentCount":0,"keywords":["database","New Features","Oracle","Oracle 19c"],"articleSection":["Database Administration & Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-19c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/","name":"Oracle 19c - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2019-10-09T08:33:46+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-19c\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-19c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 19c"}]},{"@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\/0ac04011f60f2e93c115358d0789c2da","name":"Clemens Bleile","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","caption":"Clemens Bleile"},"description":"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.","sameAs":["https:\/\/www.dbi-services.com","https:\/\/x.com\/ifgtxD2SrQ8r!YuXj"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12870","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\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=12870"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12870\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=12870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=12870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=12870"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=12870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}