{"id":1446,"date":"2018-03-02T09:59:38","date_gmt":"2018-03-02T01:59:38","guid":{"rendered":"http:\/\/www.821121.com\/?p=1446"},"modified":"2021-03-02T10:51:18","modified_gmt":"2021-03-02T02:51:18","slug":"check-the-number-of-rows-per-block","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1446","title":{"rendered":"Check the Number of Rows per Block"},"content":{"rendered":"<pre><code class=\"language-sql\">--\n-- Check the Number of Rows per Block.\n--\n\nSET PAUSE ON\nSET PAUSE &#039;Press Return to Continue&#039;\nSET PAGESIZE 60\nSET LINESIZE 300\nCOLUMN &quot;Rows per Block&quot; FORMAT 9999\n\nSELECT\n   count(*) as &quot;Rows per Block&quot;\nFROM\n   &amp;&amp;tabname\nWHERE\n   dbms_rowid.rowid_block_number(rowid) =\n     (\n     SELECT\n        min(dbms_rowid.rowid_block_number(rowid))\n     FROM &amp;&amp;tabname\n     )\n\/<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8212; &#8212; Check the Number of<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,48],"tags":[],"class_list":["post-1446","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category-sql"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1446","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1446"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1446\/revisions"}],"predecessor-version":[{"id":1447,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1446\/revisions\/1447"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1446"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}