{"id":4527,"date":"2014-11-12T06:39:53","date_gmt":"2014-11-12T11:39:53","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=4527"},"modified":"2014-11-12T06:39:53","modified_gmt":"2014-11-12T11:39:53","slug":"purge-dba_recyclebin-taking-a-long-time","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2014\/11\/12\/purge-dba_recyclebin-taking-a-long-time\/","title":{"rendered":"PURGE DBA_RECYCLEBIN taking a long time"},"content":{"rendered":"<p>Just check DBA_SEGMENTS for SEGMENT_NAME like &#8216;BIN%&#8217;, and it should be dropping in number&#8230;<\/p>\n<pre>\r\nSQL> select count(*) from dba_segments where segment_name like 'BIN%';\r\n\r\n  COUNT(*)\r\n----------\r\n      2307\r\n\r\nSQL> select count(*) from dba_segments where segment_name like 'BIN%';\r\n\r\n  COUNT(*)\r\n----------\r\n      2297\r\n\r\nSQL> select count(*) from dba_segments where segment_name like 'BIN%';\r\n\r\n  COUNT(*)\r\n----------\r\n      2281\r\n\r\nSQL> select count(*) from dba_segments where segment_name like 'BIN%';\r\n\r\n  COUNT(*)\r\n----------\r\n      2275\r\n\r\nSQL> select count(*) from dba_segments where segment_name like 'BIN%';\r\n\r\n  COUNT(*)\r\n----------\r\n      2207\r\n\r\nSQL>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Just check DBA_SEGMENTS for SEGMENT_NAME like &#8216;BIN%&#8217;, and it should be dropping in number&#8230; SQL> select count(*) from dba_segments where segment_name like &#8216;BIN%&#8217;; COUNT(*) &#8212;&#8212;&#8212;- 2307 SQL> select count(*) from dba_segments where segment_name like &#8216;BIN%&#8217;; COUNT(*) &#8212;&#8212;&#8212;- 2297 SQL> select&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2014\/11\/12\/purge-dba_recyclebin-taking-a-long-time\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[19,22],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/4527"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=4527"}],"version-history":[{"count":1,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/4527\/revisions"}],"predecessor-version":[{"id":4529,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/4527\/revisions\/4529"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=4527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=4527"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=4527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}