{"id":97,"date":"2009-12-23T13:52:00","date_gmt":"2009-12-23T11:52:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2009\/12\/23\/oracle-undo\/"},"modified":"2010-08-24T22:35:41","modified_gmt":"2010-08-24T20:35:41","slug":"oracle-undo","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2009\/12\/23\/oracle-undo\/","title":{"rendered":"ORACLE UNDO"},"content":{"rendered":"<p><b>shrink undo tablespace:<\/b><br \/>* CREATE UNDO TABLESPACE [name] DATAFILE '[path]&#8217; size [nr]G ;<br \/>* ALTER SYSTEM SET UNDO_TABLESPACE = [name];<br \/>* DROP TABLESPACE [old_name] including contents and datafiles;<\/p>\n<p><b>check rollback status:<\/b><br \/><span style=\"font-weight: bold;\"><\/span>SELECT used_urec FROM v$transaction; &#8211;records<br \/>SELECT used_ublk FROM v$transaction; &#8211;blocks<br \/>SELECT time_remaning FROM v$session_longops WHERE sid = [sid];<\/p>\n","protected":false},"excerpt":{"rendered":"<p>shrink undo tablespace:* CREATE UNDO TABLESPACE [name] DATAFILE '[path]&#8217; size [nr]G ;* ALTER SYSTEM SET UNDO_TABLESPACE = [name];* DROP TABLESPACE [old_name] including contents and datafiles; check rollback status:SELECT used_urec FROM v$transaction; &#8211;recordsSELECT used_ublk FROM v$transaction; &#8211;blocksSELECT time_remaning FROM v$session_longops WHERE sid = [sid];<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[14],"class_list":["post-97","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-undo"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/97","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=97"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/97\/revisions"}],"predecessor-version":[{"id":172,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/97\/revisions\/172"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=97"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=97"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=97"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}