OCP Blog
Super DBA
How Find Large Object in DB
by vazha mantua Monday, November 8, 2010 11:48 AM
This is small script which provide how oracle developer can find large object in oracle DB for a schema.

script :

select round(sum(s),2),t
from (
select sum(b.bytes)/1024/1024/1024 s, a.table_name t from dba_indexes a, dba_segments b
where b.segment_type in ('INDEX','INDEX PARTITION')
and a.index_name=b.segment_name
and a.owner=&SCHEMA
group by a.table_name

union all

select sum(a.bytes)/1024/1024/1024 s,a.segment_name t from dba_segments a
where a.owner=&SCHEMA
and a.segment_type in ('TABLE','TABLE PARTITION')
group by a.segment_name

union all

select sum(b.bytes)/1024/1024/1024 s,a.table_name t from dba_lobs a, dba_segments b
where a.owner=&SCHEMA
and a.segment_name=b.segment_name
group by a.table_name

)
group by t
order by 1 desc

Tags: , ,

Comments (6) -

11/18/2011 6:15:11 AM #

Dsi solutions reviews

This is really interesting, You are a very skilled blogger. I have joined your rss feed and look forward to seeking more of your fantastic post. Also, I’ve shared your website in my social networks!

Dsi solutions reviews United States

1/17/2012 4:28:09 AM #

electricians Sydney

Pretty good article. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.

electricians Sydney United States

6/10/2012 3:29:06 PM #

Iraqi Dinar

Pretty good article. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.

Iraqi Dinar United Kingdom

6/20/2012 2:27:48 PM #

Iraqi Dinar

Excellent post you have here.PageRank has also been used to rank spaces or streets to predict how many people (pedestrians or vehicles) come to the individual spaces or streets.Thanks for sharing this article.

Iraqi Dinar United Kingdom

6/20/2012 2:28:45 PM #

Diminished Value

I would like to thank you for the efforts you have put in writing this website. I’m hoping the same high-grade site post from you in the upcoming as well. In fact your creative writing abilities has inspired me to get my own site now. Actually the blogging is spreading its wings quickly. Your write up is a great example of it.

Diminished Value United Kingdom

9/4/2012 12:41:27 AM #

Dell Virtualization

This is one technology that I would love to be able to use for myself. It’s definitely a cut above the rest and I can’t wait until my provider has it. Your insight was what I needed. Thanks

Dell Virtualization United States

Pingbacks and trackbacks (1)+

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Filter by APML

Calendar

<<  February 2018  >>
MoTuWeThFrSaSu
2930311234
567891011
12131415161718
19202122232425
2627281234
567891011

View posts in large calendar

TextBox