{"id":94,"date":"2023-04-10T15:13:52","date_gmt":"2023-04-10T13:13:52","guid":{"rendered":"http:\/\/130.61.57.200\/?p=94"},"modified":"2023-04-12T11:15:40","modified_gmt":"2023-04-12T09:15:40","slug":"find-the-column-of-a-lob-even-in-dropped-objects","status":"publish","type":"post","link":"http:\/\/130.61.57.200\/index.php\/2023\/04\/10\/find-the-column-of-a-lob-even-in-dropped-objects\/","title":{"rendered":"Find the column of a LOB (even in dropped objects)"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>select u.name, o.name TABLENAME, decode(bitand(c.property, 1), 1, ac.name, c.name) as column_name,s.bytes\/1024\/1024 MB\nfrom sys.obj$ o, sys.col$ c, sys.attrcol$ ac,sys.lob$ l,sys.obj$ lo,sys.obj$ io,\nsys.user$ u,sys.ts$ ts, DBA_SEGMENTS s  \nwhere o.owner# = u.user#\nand o.obj# = c.obj#\nand c.obj# = l.obj# and c.intcol# = l.intcol#\nand l.lobj# = lo.obj# and l.ind# = io.obj# and l.ts# = ts.ts# and c.obj# =\nac.obj#(+)\nand c.intcol# = ac.intcol#(+) and lo.name = s.SEGMENT_name\nORDER BY s.bytes DESC fetch FIRST 10 ROW ONLY;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":106,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[39,40,29],"class_list":["post-94","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-lob","tag-segment","tag-size"],"blocksy_meta":[],"_links":{"self":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/94","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/comments?post=94"}],"version-history":[{"count":1,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/94\/revisions"}],"predecessor-version":[{"id":95,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/94\/revisions\/95"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/media\/106"}],"wp:attachment":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/media?parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/categories?post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/tags?post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}