Regarding the following “MOS Note Is Table SCHEMA.CMP4$222224 Or Similar Related To Compression Advisor? (Doc ID 1606356.1)”,
\nwe know that since Oracle 11.2.0.4 BP1 or Higher, due to the failure of Compression Advisor some tables with names
\nthat include “CMP”, created “temporary – the time the process is running” by Compression Advisor process (ie CMP4$23590) are not removed from the database as that should be the case.
\nHow theses tables are created ? How to “cleanly” remove them ?
\n<\/p>\n
1.Check None CMP tables exist.<\/p>\n
\nSQL> select count(*) from dba_tables where table_name like 'CMP%';\n\n COUNT(*)\n----------\n 0\n<\/pre>\n2. Check there is no compression enabled for the table we will use to test the Compression Advisor.<\/p>\n
\nSQL> select nvl(COMPRESSION,'NO') as COMPRESSION,nvl(COMPRESS_FOR,'NO') as COMPRESS_FOR from dba_tables where table_name = 'FOO';\n\nCOMPRESS COMPRESS_FOR\n-------- ------------------------------\nNO NO\n\n<\/pre>\n3.Execute the Compression Advisor procedure<\/p>\n
The procedure DBMS_COMPRESSION.get_compression_ratio analyzes the compression ratio of a table, and gives information about compressibility of a table.
\nFor information, Oracle Database 12c include a number of enhancements to the DBMS_COMPRESSION package such as In-Memory Compression or Advanced Compression.<\/p>\nLet’s executing the DBMS_COMPRESSION.get_compression_ratio procedure:<\/p>\n
\nSQL> \nalter session set tracefile_identifier = 'CompTest1110201815h51';\nalter session set events '10046 trace name context forever, level 12';\nset serveroutput on\n\nDECLARE\n l_blkcnt_cmp PLS_INTEGER;\n l_blkcnt_uncmp PLS_INTEGER;\n l_row_cmp PLS_INTEGER;\n l_row_uncmp PLS_INTEGER;\n l_cmp_ratio NUMBER;\n l_comptype_str VARCHAR2(32767);\nBEGIN\n DBMS_COMPRESSION.get_compression_ratio (\n scratchtbsname => 'USERS',\n ownname => 'TEST_LAF',\n objname => 'FOO',\n subobjname => NULL,\n comptype => DBMS_COMPRESSION.comp_advanced,\n blkcnt_cmp => l_blkcnt_cmp,\n blkcnt_uncmp => l_blkcnt_uncmp,\n row_cmp => l_row_cmp,\n row_uncmp => l_row_uncmp,\n cmp_ratio => l_cmp_ratio,\n comptype_str => l_comptype_str,\n subset_numrows => DBMS_COMPRESSION.comp_ratio_allrows,\n objtype => DBMS_COMPRESSION.objtype_table\n );\n\n DBMS_OUTPUT.put_line('Number of blocks used (compressed) : ' || l_blkcnt_cmp);\n DBMS_OUTPUT.put_line('Number of blocks used (uncompressed) : ' || l_blkcnt_uncmp);\n DBMS_OUTPUT.put_line('Number of rows in a block (compressed) : ' || l_row_cmp);\n DBMS_OUTPUT.put_line('Number of rows in a block (uncompressed) : ' || l_row_uncmp);\n DBMS_OUTPUT.put_line('Compression ratio : ' || l_cmp_ratio);\n DBMS_OUTPUT.put_line('Compression type : ' || l_comptype_str);\nEND;\n\/\n\nNumber of blocks used (compressed) : 1325\nNumber of blocks used (uncompressed) : 1753\nNumber of rows in a block (compressed) : 74\nNumber of rows in a block (uncompressed) : 55\nCompression ratio : 1.3\nCompression type : \"Compress Advanced\"\n\nPL\/SQL procedure successfully completed.\n<\/pre>\n4.Which “CMP internal” tables are created by DBMS_COMPRESSION.get_compression_ratio ?<\/p>\n
To handle the compression advisor process, Oracle creates 4 CMP* tables : CMP1$23590, CMP2$23590, CMP3$23590, CMP4$23590.<\/p>\n
Strangely, Oracle Trace 10046 files contains only DDL for the creation of the last 2 ones (we can also use LogMinner to find the DDL) : CMP3$23590, CMP4$23590.
\nThe table CMP3$23590 is a copy of the source table.
\nThe table CMP4$23590 is a copy “compressed” of CMP3$23590 table.<\/p>\n\ngrep \"CMP*\" DBI_ora_20529_CompTest1110201823h19.trc\n\ndrop table \"TEST_LAF\".CMP1$23590 purge\ndrop table \"TEST_LAF\".CMP2$23590 purge\ndrop table \"TEST_LAF\".CMP3$23590 purge\ndrop table \"TEST_LAF\".CMP4$23590 purge\ncreate table \"TEST_LAF\".CMP3$23590 tablespace \"USERS\" nologging as select \/*+ DYNAMIC_SAMPLING(0) FULL(\"TEST_LAF\".\"FOO\") *\/ * from \"TEST_LAF\".\"FOO\" sample block( 99) mytab\ncreate table \"TEST_LAF\".CMP4$23590 organization heap tablespace \"USERS\" compress for all operations nologging as select \/*+ DYNAMIC_SAMPLING(0) *\/ * from \"TEST_LAF\".CMP3$23590 mytab\ndrop table \"TEST_LAF\".CMP1$23590 purge\ndrop table \"TEST_LAF\".CMP2$23590 purge\ndrop table \"TEST_LAF\".CMP3$23590 purge\ndrop table \"TEST_LAF\".CMP4$23590 purge\n\n<\/pre>\nAs we can see above, the “internal” tables (even the one compressed CMP4$23590) are removed at the end of the process.<\/p>\n
To be sure, we check in the database :<\/p>\n
\nSQL> select count(*) from dba_tables where table_name like 'CMP%';\n\n COUNT(*)\n----------\n 0\n<\/pre>\nSo, everything is fine, no ‘CMP’ tables exist and the source table is not compressed :<\/p>\n
\nSQL> select nvl(COMPRESSION,'NO') as COMPRESSION,nvl(COMPRESS_FOR,'NO') as COMPRESS_FOR from dba_tables where table_name = 'FOO';\n\nCOMPRESS COMPRESS_FOR\n-------- ------------------------------\nNO NO\n\n<\/pre>\n5.But what happens if DBMS_COMPRESSION.get_compression_ratio fails ?<\/p>\n
Let’s forcing the failure of the DBMS_COMPRESSION.get_compression_ratio procedure…<\/p>\n
\nSQL> \nalter session set tracefile_identifier = 'CompTest1410201822h03';\nalter session set events '10046 trace name context forever, level 12';\nset serveroutput on\n\nDECLARE\n l_blkcnt_cmp PLS_INTEGER;\n l_blkcnt_uncmp PLS_INTEGER;\n l_row_cmp PLS_INTEGER;\n l_row_uncmp PLS_INTEGER;\n l_cmp_ratio NUMBER;\n l_comptype_str VARCHAR2(32767);\nBEGIN\n DBMS_COMPRESSION.get_compression_ratio (\n scratchtbsname => 'USERS',\n ownname => 'TEST_LAF',\n objname => 'FOO',\n subobjname => NULL,\n comptype => DBMS_COMPRESSION.comp_advanced,\n blkcnt_cmp => l_blkcnt_cmp,\n blkcnt_uncmp => l_blkcnt_uncmp,\n row_cmp => l_row_cmp,\n row_uncmp => l_row_uncmp,\n cmp_ratio => l_cmp_ratio,\n comptype_str => l_comptype_str,\n subset_numrows => DBMS_COMPRESSION.comp_ratio_allrows,\n objtype => DBMS_COMPRESSION.objtype_table\n );\n 24\n DBMS_OUTPUT.put_line('Number of blocks used (compressed) : ' || l_blkcnt_cmp);\n DBMS_OUTPUT.put_line('Number of blocks used (uncompressed) : ' || l_blkcnt_uncmp);\n DBMS_OUTPUT.put_line('Number of rows in a block (compressed) : ' || l_row_cmp);\n DBMS_OUTPUT.put_line('Number of rows in a block (uncompressed) : ' || l_row_uncmp);\n DBMS_OUTPUT.put_line('Compression ratio : ' || l_cmp_ratio);\n DBMS_OUTPUT.put_line('Compression type : ' || l_comptype_str);\nEND;\n 32 \/\nDECLARE\n*\nERROR at line 1:\nORA-01013: user requested cancel of current operation\n\n<\/pre>\nWhat “CMP*” tables persist after ?<\/p>\n
Two “CMP*” tables is always present :<\/p>\n
\nSQL> select count(*) from dba_tables where table_name like 'CMP%';\n\n COUNT(*)\n----------\n 2\n\nSQL> select owner,table_name from dba_tables where table_name like 'CMP%';\n\nOWNER TABLE_NAME\n------- ----------\nTEST_LAF CMP3$23687\nTEST_LAF CMP4$23687\n\n\n<\/pre>\nSince “CMP3*” and “CMP4*” are copy (compressed for the second one) of source table, space disk can increase dramatically if Compressoin Advisor fails frequently and mainly with huge tables, so it’s important to remove these tables.<\/p>\n
The source table called FOO, CMP3$23687 and CMP4$23687 internal tables contains same set of data (less for the last 2 ones since we use the sample block option)…<\/p>\n
\nSQL> select count(*) from test_laf.CMP3$23687;\n\n COUNT(*)\n----------\n 22147\n\nSQL> select count(*) from test_laf.CMP4$23687;\n\n COUNT(*)\n----------\n 22147\n\nSQL> select count(*) from test_laf.foo;\n\n COUNT(*)\n----------\n 22387\n\n<\/pre>\nThe worst is that now we are in presence of compressed table while we don’t have the compression license option :<\/p>\n
\nSQL> select nvl(COMPRESSION,'NO') as COMPRESSION,nvl(COMPRESS_FOR,'NO') as COMPRESS_FOR from dba_tables where table_name = 'CMP4$23687';\n\nCOMPRESS COMPRESS_FOR\n-------- ------------------------------\nENABLED ADVANCED\n<\/pre>\nTo remove the oracle “CMP*” internal tables tables, let’s analyzing the 10046 trace file to check how oracle remove these tables when the DBMS_COMPRESSION.get_compression_ratio procedure run successfully:<\/p>\n
Find below all the steps that oracle does to drop these tables:<\/p>\n
\ndrop table \"TEST_LAF\".CMP1$23687 purge\n\nBEGIN\n BEGIN\n IF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_CONTENTS)) THEN\n xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);\n ELSIF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN\n xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name);\n END IF;\n EXCEPTION\n WHEN OTHERS THEN\n null;\n END;\nEND;\n\ndrop table \"TEST_LAF\".CMP2$23687 purge\n\nPARSING IN CURSOR #140606951937256 len=515 dep=2 uid=0 oct=47 lid=0 tim=3421988631 hv=2219505151 ad='69fd11c8' sqlid='ct6c4h224pxgz'\nBEGIN\n BEGIN\n IF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_CONTENTS)) THEN\n xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);\n ELSIF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN\n xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name);\n END IF;\n EXCEPTION\n WHEN OTHERS THEN\n null;\n END;\nEND;\n\n\ndrop table \"TEST_LAF\".CMP3$23687 purge\n\nBEGIN\n BEGIN\n IF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_CONTENTS)) THEN\n xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);\n ELSIF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN\n xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name);\n END IF;\n EXCEPTION\n WHEN OTHERS THEN\n null;\n END;\nEND;\n\n\ndrop table \"TEST_LAF\".CMP4$23687 purge\nBEGIN\n BEGIN\n IF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_CONTENTS)) THEN\n xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);\n ELSIF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN\n xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name);\n END IF;\n EXCEPTION\n WHEN OTHERS THEN\n null;\n END;\nEND;\n<\/pre>\nTo remove “CMP*” tables, Oracle does :
\n – drop table *** purge
\n – call internal procedure : xdb.XDB_PITRIG_PKG.pitrig_truncate or xdb.XDB_PITRIG_PKG.pitrig_dropmetadata regarding if Oracle Virtual Private Database is used.<\/p>\n7. Last Test : Check the source table is not compressed, we don’t want to have the compression enabled since we are not licensing…<\/p>\n
\nSQL> select nvl(COMPRESSION,'NO') as COMPRESSION,nvl(COMPRESS_FOR,'NO') as COMPRESS_FOR from dba_tables where table_name = 'FOO';\n\nCOMPRESS COMPRESS_FOR\n-------- ------------------------------\nNO NO\n\n<\/pre>\n6.Conclusion<\/p>\n
To drop “CMP*” tables used by the DBMS_COMPRESSION.get_compression_ratio procedure, just execute : drop table CMP* purge.<\/p>\n
I have not tested more in details the case where compression is used into Oracle VPD, so I don’t know the impact of executing the system procedure : xdb.XDB_PITRIG_PKG.pitrig_truncate or xdb.XDB_PITRIG_PKG.pitrig_dropmetadata in case we use VPD.<\/p>\n","protected":false},"excerpt":{"rendered":"
Regarding the following “MOS Note Is Table SCHEMA.CMP4$222224 Or Similar Related To Compression Advisor? (Doc ID 1606356.1)”, we know that since Oracle 11.2.0.4 BP1 or Higher, due to the failure of Compression Advisor some tables with names that include “CMP”, created “temporary – the time the process is running” by Compression Advisor process (ie CMP4$23590) […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[1460,1461,96],"type_dbi":[],"class_list":["post-11761","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-cmp","tag-compression","tag-oracle"],"acf":[],"yoast_head":"\n
Where come from Oracle CMP$ tables and how to delete them ? - 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\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Where come from Oracle CMP$ tables and how to delete them ?\" \/>\n<meta property=\"og:description\" content=\"Regarding the following “MOS Note Is Table SCHEMA.CMP4$222224 Or Similar Related To Compression Advisor? (Doc ID 1606356.1)”, we know that since Oracle 11.2.0.4 BP1 or Higher, due to the failure of Compression Advisor some tables with names that include “CMP”, created “temporary – the time the process is running” by Compression Advisor process (ie CMP4$23590) […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-16T08:27:45+00:00\" \/>\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=\"8 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\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Where come from Oracle CMP$ tables and how to delete them ?\",\"datePublished\":\"2018-10-16T08:27:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/\"},\"wordCount\":569,\"commentCount\":0,\"keywords\":[\"CMP$\",\"compression\",\"Oracle\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/\",\"name\":\"Where come from Oracle CMP$ tables and how to delete them ? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2018-10-16T08:27:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Where come from Oracle CMP$ tables and how to delete them ?\"}]},{\"@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":"Where come from Oracle CMP$ tables and how to delete them ? - 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\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/","og_locale":"en_US","og_type":"article","og_title":"Where come from Oracle CMP$ tables and how to delete them ?","og_description":"Regarding the following “MOS Note Is Table SCHEMA.CMP4$222224 Or Similar Related To Compression Advisor? (Doc ID 1606356.1)”, we know that since Oracle 11.2.0.4 BP1 or Higher, due to the failure of Compression Advisor some tables with names that include “CMP”, created “temporary – the time the process is running” by Compression Advisor process (ie CMP4$23590) […]","og_url":"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/","og_site_name":"dbi Blog","article_published_time":"2018-10-16T08:27:45+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Where come from Oracle CMP$ tables and how to delete them ?","datePublished":"2018-10-16T08:27:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/"},"wordCount":569,"commentCount":0,"keywords":["CMP$","compression","Oracle"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/","url":"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/","name":"Where come from Oracle CMP$ tables and how to delete them ? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-10-16T08:27:45+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/where-come-from-oracle-cmp-tables-and-how-to-delete-them\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Where come from Oracle CMP$ tables and how to delete them ?"}]},{"@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\/11761","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=11761"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11761\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11761"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}