{"id":1449,"date":"2018-08-09T12:02:45","date_gmt":"2018-08-09T12:02:45","guid":{"rendered":"http:\/\/dbtut.com\/?p=1449"},"modified":"2019-03-28T11:42:22","modified_gmt":"2019-03-28T11:42:22","slug":"how-to-purge-sysaux-tablespace","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/","title":{"rendered":"How to purge sysaux tablespace"},"content":{"rendered":"<p>Sysaux tablespace is an auxiliary tablespace to the SYSTEM tablespace. If SYSAUX tablespace becomes unusable database functionality will remain operational.<\/p>\n<p>Occupants of the SYSAUX tablespace can be monitored from <span class=\"x-el x-el-span px_-font-style-italic px_-fs-unset px_-ff-_Cabin___Georgia__serif x-d-ux\">V$SYSAUX_OCCUPANTS<\/span>\u00a0view.<\/p>\n<p>The largest component of the SYSAUX tablespace is the Automatic Workload Repository (AWR)<\/p>\n<h3>When the sysaux tablespace grows, the components are investigated:<\/h3>\n<pre class=\"lang:default decode:true\">SELECT \u00a0occupant_name \"Item\", space_usage_kbytes\/1048576 \"Space Used (GB)\",schema_name \"Schema\", move_procedure \"Move Procedure\" FROM v$sysaux_occupants ORDER BY 2 desc;\n\n\u00a0Item \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Space Used (GB) \u00a0\u00a0\u00a0\u00a0Schema\n\nSM\/AWR\u00a0 \u00a0 127,532836914063\u00a0 \u00a0 \u00a0 SYS\n\nSM\/AWR\u00a0 \u00a0 127,532836914063\u00a0 \u00a0 \u00a0 SYS\n\nSM\/AWR\u00a0 \u00a0 127,532836914063\u00a0 \u00a0 \u00a0 SYS\n\nSM\/AWR \u00a0\u00a0\u00a0127,532836914063\u00a0 \u00a0 \u00a0 SYS\n\nSM\/ADVISOR 0,606689453125\u00a0 \u00a0 SYS<\/pre>\n<h3>When we look at sizes of the objects from the dba_segments that are in SYSAUX tablespace:<\/h3>\n<pre class=\"lang:default decode:true\">select * from (select owner,segment_name||'~'||partition_name segment_name,bytes\/(1024*1024) size_m \u00a0from dba_segments \u00a0where tablespace_name = 'SYSAUX' ORDER BY BLOCKS desc) where rownum &lt; 11;\n\nSYS WRH$_EVENT_HISTOGRAM_PK~WRH$_EVENT__2410857060_95950 21612,625\n\nSYS WRH$_EVENT_HISTOGRAM~WRH$_EVENT__2410857060_95950 14004,4375\n\nSYS WRH$_ACTIVE_SESSION_HISTORY~WRH$_ACTIVE_2410857060_95950 12026,625\n\nSYS WRH$_LATCH_MISSES_SUMMARY_PK~WRH$_LATCH__2410857060_95950 8841\n\nSYS WRH$_LATCH_MISSES_SUMMARY~WRH$_LATCH__2410857060_95950 6281,25\n\nSYS WRH$_SYSSTAT_PK~WRH$_SYSSTA_2410857060_95950 5651,1875\n\nSYS WRH$_LATCH~WRH$_LATCH_2410857060_95950 5576,5625\n\nSYS WRH$_SQLSTAT~WRH$_SQLSTA_2410857060_95950 5140,6875\n\nSYS WRH$_LATCH_PK~WRH$_LATCH_2410857060_95950 4932\n\nSYS WRH$_SYSSTAT~WRH$_SYSSTA_2410857060_95950 3560<\/pre>\n<p>The biggest object is &#8220;WRH$_EVENT_HISTOGRAM~WRH$_EVENT__2410857060_95950&#8221;.<\/p>\n<h3>Now we can check the minimum and maximum snap_id in dba_hist_snapshot:<\/h3>\n<pre class=\"lang:default decode:true \">select min(snap_id),MAX(snap_id) from dba_hist_snapshot;\n\n139799\u00a0 \u00a0 142735<\/pre>\n<p>In large AWR tables, snapshot data is stored in partitions. One method of purging data from these tables is by removing partitions that only contain rows that have exceeded the retention criteria.<\/p>\n<h3>To check these partitions:<\/h3>\n<pre class=\"lang:default decode:true  \">SELECT owner, \u00a0segment_name, \u00a0partition_name, \u00a0segment_type, \u00a0bytes\/1024\/1024\/1024 Size_GB FROM dba_segments WHERE segment_name='WRH$_EVENT_HISTOGRAM';<\/pre>\n<p>Here we can see WRH$_ACTIVE_SESSION_HISTORY WRH$_ACTIVE_2410857060_95950 partition didn&#8217;t dropped although the snapshot data in it has expired.<\/p>\n<pre class=\"lang:default decode:true\">select min(snap_id), max(snap_id) from sys.WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2410857060_95950)\n\n95950 141582<\/pre>\n<p>If the data in partition didn&#8217;t expire but the partition grows manually, splitting the partition is a solution:<\/p>\n<pre class=\"lang:default decode:true\">alter session set \"_swrf_test_action\"=72;<\/pre>\n<h3>After this we can start manually dropping the old partition range:<\/h3>\n<pre class=\"lang:default decode:true\">exec dbms_workload_repository.drop_snapshot_range(95950,141582,2410857060);<\/pre>\n<p>After this procedure ends, the old and big partition will be dropped.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_1449\" class=\"pvc_stats all  \" data-element-id=\"1449\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Sysaux tablespace is an auxiliary tablespace to the SYSTEM tablespace. If SYSAUX tablespace becomes unusable database functionality will remain operational. Occupants of the SYSAUX tablespace can be monitored from V$SYSAUX_OCCUPANTS\u00a0view. The largest component of the SYSAUX tablespace is the Automatic Workload Repository (AWR) When the sysaux tablespace grows, the components are investigated: SELECT \u00a0occupant_name &#8220;Item&#8221;, &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_1449\" class=\"pvc_stats all  \" data-element-id=\"1449\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":13,"featured_media":11152,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[1379,2927,2928,1378,2929,2933,2935,2934,2931,1377,2930,2932],"class_list":["post-1449","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-awr","tag-how-to-reclaim-space-from-sysaux-tablespace","tag-how-to-shrink-sysaux-tablespace","tag-purge","tag-query-to-check-sysaux-tablespace-usage","tag-reduce-size-of-sysaux","tag-resize-sysaux","tag-shrink-sysaux","tag-sysaux","tag-sysaux-tablespace","tag-what-is-in-sysaux-tablespace","tag-what-is-the-use-of-system-tablespace-in-oracle"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":8499,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to purge sysaux tablespace - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How to purge sysaux tablespace\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to purge sysaux tablespace - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How to purge sysaux tablespace\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-09T12:02:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-28T11:42:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/Ads\u0131z-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"568\" \/>\n\t<meta property=\"og:image:height\" content=\"351\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Selcen Sahin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Selcen Sahin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/\"},\"author\":{\"name\":\"Selcen Sahin\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/87438a648f4fcee5ebc050fa2d1b68ca\"},\"headline\":\"How to purge sysaux tablespace\",\"datePublished\":\"2018-08-09T12:02:45+00:00\",\"dateModified\":\"2019-03-28T11:42:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/\"},\"wordCount\":201,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/Ads\u0131z-2.png\",\"keywords\":[\"AWR\",\"how to reclaim space from sysaux tablespace\",\"how to shrink sysaux tablespace\",\"purge\",\"query to check sysaux tablespace usage\",\"Reduce Size of SYSAUX\",\"resize sysaux\",\"Shrink sysaux\",\"sysaux\",\"sysaux tablespace\",\"What is in Sysaux tablespace?\",\"What is the use of system tablespace in Oracle?\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/\",\"name\":\"How to purge sysaux tablespace - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/Ads\u0131z-2.png\",\"datePublished\":\"2018-08-09T12:02:45+00:00\",\"dateModified\":\"2019-03-28T11:42:22+00:00\",\"description\":\"How to purge sysaux tablespace\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/Ads\u0131z-2.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/Ads\u0131z-2.png\",\"width\":568,\"height\":351},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to purge sysaux tablespace\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/87438a648f4fcee5ebc050fa2d1b68ca\",\"name\":\"Selcen Sahin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/403f3e1ed22269aba4b27e275764c81032219d846808ea020c5512c9ffe300f6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/403f3e1ed22269aba4b27e275764c81032219d846808ea020c5512c9ffe300f6?s=96&d=mm&r=g\",\"caption\":\"Selcen Sahin\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/selcensahin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to purge sysaux tablespace - Database Tutorials","description":"How to purge sysaux tablespace","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:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/","og_locale":"en_US","og_type":"article","og_title":"How to purge sysaux tablespace - Database Tutorials","og_description":"How to purge sysaux tablespace","og_url":"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/","og_site_name":"Database Tutorials","article_published_time":"2018-08-09T12:02:45+00:00","article_modified_time":"2019-03-28T11:42:22+00:00","og_image":[{"width":568,"height":351,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/Ads\u0131z-2.png","type":"image\/png"}],"author":"Selcen Sahin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Selcen Sahin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/"},"author":{"name":"Selcen Sahin","@id":"https:\/\/dbtut.com\/#\/schema\/person\/87438a648f4fcee5ebc050fa2d1b68ca"},"headline":"How to purge sysaux tablespace","datePublished":"2018-08-09T12:02:45+00:00","dateModified":"2019-03-28T11:42:22+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/"},"wordCount":201,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/Ads\u0131z-2.png","keywords":["AWR","how to reclaim space from sysaux tablespace","how to shrink sysaux tablespace","purge","query to check sysaux tablespace usage","Reduce Size of SYSAUX","resize sysaux","Shrink sysaux","sysaux","sysaux tablespace","What is in Sysaux tablespace?","What is the use of system tablespace in Oracle?"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/","url":"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/","name":"How to purge sysaux tablespace - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/Ads\u0131z-2.png","datePublished":"2018-08-09T12:02:45+00:00","dateModified":"2019-03-28T11:42:22+00:00","description":"How to purge sysaux tablespace","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/Ads\u0131z-2.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/Ads\u0131z-2.png","width":568,"height":351},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/how-to-purge-sysaux-tablespace\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How to purge sysaux tablespace"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/87438a648f4fcee5ebc050fa2d1b68ca","name":"Selcen Sahin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/403f3e1ed22269aba4b27e275764c81032219d846808ea020c5512c9ffe300f6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/403f3e1ed22269aba4b27e275764c81032219d846808ea020c5512c9ffe300f6?s=96&d=mm&r=g","caption":"Selcen Sahin"},"url":"https:\/\/dbtut.com\/index.php\/author\/selcensahin\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1449","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=1449"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1449\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11152"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=1449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=1449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=1449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}