Tuesday, October 9, 2007

Get Oracle Table Size

First, we must remember that table size is constantly changing as DML adds and removes rows. Also, we have many other factors that determine the "actual" size of a table:

The high water mark for the Oracle table
The number of allocated extents
The amount of spaced reserved on each block for row expansion (PCTFREE)


You need to ask yourself exactly which Oracle table size, you wish to query:

Do you want only the row space consumed? ( select avg_row_len*num_rows from dba_tables)

Do you want to include allocated file space for the table? (select . . . from dba_segments)

Do you want to include un-used extent space? (select . . . from dba_data_files, dba_extents . . )

Do you want to include un-used space up to the high water mark? This may over-estimate the real Oracle table size.

Do you want table sizes for Oracle growth monitoring?

23 comments:

Anonymous said...

Hey would you mind sharing which blog platform you're working with? I'm going to start my own blog
soon but I'm having a hard time choosing between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your layout seems different then most blogs and I'm looking for something
unique. P.S My apologies for getting off-topic but I had to ask!


Review my blog post :: facebookofsex

Anonymous said...

This website online is really a stroll-via for all of the information you needed about this and didn�t know who to ask.
Glimpse right here, and you�ll positively uncover it.

My web site :: http://wiki.phy.queensu.ca/PHYS350/index.php?title=User:Wesley19O

Anonymous said...

Thanks for the guidelines you have contributed here.
Another thing I would like to mention is that pc memory
specifications generally increase along with other developments in the technological
know-how. For instance, whenever new generations of processor chips are made in the market, there's usually a similar increase in the type eferences of both the laptop or computer memory along with hard drive room. This is because the program operated by way of these cpus will inevitably surge in power to make new technological innovation.

Check out my homepage :: facebook sex

Anonymous said...

certainly like your web site however you need to
test the spelling on several of your posts. Many of them
are rife with spelling problems and I in finding it very troublesome to inform the truth however I will definitely come back again.


Here is my website http://tkpedia.tamm-kreiz.com/

Anonymous said...

I�m not sure where you are getting your info, but good topic.
I needs to spend some time learning much
more or understanding more. Thanks for fantastic info I was looking for this info for my mission.


my web blog; good dating sites

Anonymous said...

Good blog post. What I would like to bring up is that computer memory must be purchased should your computer
is unable to cope with anything you do with it.
One can mount two good old ram boards of 1GB
each, as an illustration, but not certainly
one of 1GB and one with 2GB. One should check
the s documentation for one's PC to make sure what type of memory space is required.

Review my page: http://auto-bookmarks.de/

Anonymous said...

I have read several good stuff here. Definitely worth bookmarking for
revisiting. I wonder how much effort you put to make
such a wonderful informative web site.

My web site: face book of sex

Anonymous said...

There are definitely loads of details like that to take into consideration.
That could be a nice level to bring up. I supply the ideas above as common inspiration
but clearly there are questions like the one you convey up the place the most important thing might be
working in honest good faith. I don?t know if finest
practices have emerged around issues like that, however
I'm positive that your job is clearly identified as a fair game. Both boys and girls feel the impact of just a moment�s pleasure, for the rest of their lives.

my web-site: sex facebook

Anonymous said...

Hiya! I know this is kinda off topic but I'd figured I'd ask.
Would you be interested in exchanging links or maybe guest writing a
blog post or vice-versa? My site goes over a lot of the same topics as yours and I think we could greatly benefit from
each other. If you're interested feel free to shoot me an email. I look forward to hearing from you! Awesome blog by the way!

Here is my blog - inlocaltv.com

Anonymous said...

Hi, Neat post. There's a problem with your website in internet explorer, would check this� IE still is the market leader and a big portion of people will miss your great writing due to this problem.

my web-site; facebook sex

Anonymous said...



My web-site; american singles

Anonymous said...

I�ll immediately grab your rss as I can not find your e-mail subscription link or newsletter service.
Do you have any? Please let me know so that I could subscribe.

Thanks.

Look into my website ... singles adult

Anonymous said...

magnificent issues altogether, you just won a new reader.
What would you suggest in regards to your post that you just made some days in the past?
Any positive?

Look into my blog - free sex personals

Anonymous said...

This website online is known as a stroll-by means of for the entire info you needed about this and didn�t
know who to ask. Glimpse right here, and also you�ll positively discover it.


Have a look at my page ... adult finder

Anonymous said...

You made several nice points there. I did a search on the topic and found nearly all people will have the
same opinion with your blog.

Feel free to surf to my weblog facebook sex

Anonymous said...

Generally I don't read post on blogs, but I would like to say that this write-up very forced me to try and do it! Your writing style has been amazed me. Thanks, very nice post.

Here is my site ... adult finder

Anonymous said...

Thanks for your post. Another issue is that being
a photographer involves not only problems in capturing award-winning photographs but in addition hardships in
acquiring the best digicam suited to your needs and most especially hardships in maintaining the grade of your camera.
This is very true and apparent for those photographers that are in to
capturing this nature's eye-catching scenes -- the mountains, the particular forests, the particular wild or seas. Visiting these exciting places definitely requires a digicam that can surpass the wild's tough environments.



Have a look at my weblog: facebook of sex

Anonymous said...

It's awesome in support of me to have a web site, which is good in support of my know-how. thanks admin

Also visit my web site - iphone 5 cases ifrogz

Anonymous said...

ӏ knοw this web pаge provides qualіty depеnding aгtіcles and extra datа,
iѕ therе any other web page ωhich giveѕ such data in quality?


My web pаge; best phone cases

Anonymous said...

Hey! Do уοu know if they make аnу plugins to hеlр with Search Engine Оptimizatіon?
I'm trying to get my blog to rank for some targeted keywords but I'm not seeing
very gooԁ gaіns. If yоu know of any please shaгe.

Cheers!

Mу websitе iphone 4 cases

Anonymous said...

Thanκѕ foг sharing youг thoughts about
pro iphone cаsе. Regards

Heге is my blog post; iphone 4ss aluminum bumper

Anonymous said...

Greetings, I do think yоur web site might be having web browsеr compatibility
issueѕ. Whеn I take a look at your web site in Safarі, it looκs fine hοωever when opening in
IE, it's got some overlapping issues. I simply wanted to provide you with a quick heads up! Besides that, wonderful website!

My weblog :: rednecksgonecrazy.com

Brandon Hudson said...

Nice and very helpful information i have got from your post. Even your whole blog is full of interesting information which is the great sign of a great blogger.

Acer - 13.3" Aspire Ultrabook - 4 GB Memory and 256 GB Solid State Drive (S3-391-73514)

Acer - 11.6" TravelMate Notebook - 4 GB Memory - 320 GB Hard Drive