Thursday, February 09, 2006

Size of the table in bytes

To find the size of bytes allocated to a table:

sql > analyze table emp compute statistics;

sql > select num_rows * avg_row_len "Bytes Used" from dba_tables where table_name = 'TEST';

Bytes Used
-----------
560

sql > select bytes "Bytes Allocated" from dba_segments where segment_name = 'TEST';


Bytes Allocated
----------
524288

The result of the query shows that the emp table is using 560 bytes of the 524,288 bytes allocated to it.

**** you can use user_segments too...if u don't have the dba privileges ******

23 comments:

Changa said...

This would be of good help, man! I would have known this when I was there at Cinti. We were trying to measure up the OLAP DB and give stats but did not know this. Thanks for this information. It would be of good help.

Changa said...

SELECT
SUBSTR(s.segment_name,1,20) TABLE_NAME,
SUBSTR(s.tablespace_name,1,20) TABLESPACE_NAME,
ROUND(DECODE(s.extents, 1, s.initial_extent,
(s.initial_extent + (s.extents-1) * s.next_extent))/1024000,2) ALLOCATED_MB,
ROUND((t.num_rows * t.avg_row_len / 1024000),2) REQUIRED_MB
FROM
dba_segments s,
dba_tables t
WHERE
s.owner = t.owner AND
s.segment_name = t.table_name
ORDER BY s.segment_name;

Ralf said...

Big thanks man. I was looking for this for so long!

Anonymous said...

Great article. It is quite unfortunate that over the last years, the travel
industry has already been able to to take on terrorism, SARS, tsunamis, bird flu, swine flu, and also the first ever entire global recession.
Through all of it the industry has really proven
to be solid, resilient along with dynamic, obtaining new
approaches to deal with difficulty

Look into my web site: microfinance.ca

Anonymous said...

You can definitely see your skills in the work you write.
The world hopes for even more passionate writers like you who aren't afraid to say how they believe. Always follow your heart.

Check out my web site; bad boy dating

Anonymous said...

As I website possessor I believe the content
matter here is rattling magnificent , appreciate it for your efforts.
You should keep it up forever! Best of luck.

Here is my web blog - adults dating

Anonymous said...

Someone essentially help to make seriously articles I would
state. This is the very first time I frequented your website
page and thus far? I surprised with the research you made to create this particular publish
incredible. Wonderful job!

Feel free to surf to my website :: http://www.hbr.cl/wiki/index.php?title=Online_Facebook_Of_Sex_-_Tips_On_Writing_A_Beneficial_Profile

Anonymous said...

I'm truly enjoying the design and layout of your website. It's a very easy on the eyes which makes it much more pleasant for me to come here and
visit more often. Did you hire out a developer to create your theme?
Excellent work!

My weblog :: skype sex

Anonymous said...

Today, I went to the beach with my children. I found a sea shell and gave it to my 4 year old daughter and said "You can hear the ocean if you put this to your ear." She placed the shell to her
ear and screamed. There was a hermit crab inside and it pinched her ear.
She never wants to go back! LoL I know this
is totally off topic but I had to tell someone!

Here is my web blog :: facebook of sex

Anonymous said...

I have observed that of all kinds of insurance, medical care insurance is
the most dubious because of the issue between the insurance coverage
company's obligation to remain adrift and the buyer's need to have insurance plan.

Insurance companies' profits on overall health plans are very low, hence some organizations struggle to earn profits. Thanks for the suggestions you reveal through your blog.

Here is my web blog :: skype sex

Anonymous said...

I am suгe thіs article hаs tοuchеd аll the internеt рeople,
itѕ really really nice post on builԁing up new blog.


Μy websіte - Premature Ejaculation Pills

Anonymous said...

Can I simply just say what a comfort to uncover a
person that truly knows what they are talking about on the internet.

You actually understand how to bring an issue to light and
make it important. A lot more people really need to check this out and understand this side of your story.
I was surprised you're not more popular since you most certainly have the gift.

Here is my page - samsung galaxy s3 cases and covers

Anonymous said...

I savor, гesult in I ԁiscoverеd exactly whаt I uѕed
to be looking for. You have ended my four day lengthy hunt!
God Bleѕs you mаn. Have a great day. Bye

Hеre iѕ my ωeb page; cell phone cases iphone 4

Anonymous said...

[url=http://is.gd/co5g6s][img]http://stomsk.ru/pics/spymobile.ol1[/img][/url]
[url=http://purchaseraspberryketone.webs.com/apps/profile/109034678/]Can You Read Your Text Messages Online With Telus[/url] [url=http://archive.org/details/nosistsebe]Como Rastrear O Celular Perdido Usando Gps[/url] [url=http://archive.org/details/pauspeedleto] Pelicula Completa De Spy Kids 2 Ingles [/url] [url=http://spymobileaf49wx.carbonmade.com/projects/4790262]Como Posso Encontrar Meu Celular Perdido Usando O Gps[/url] http://archive.org/details/ormuevaro spion kamera programvara mac gratis omvand telefon nummer sparning finns det en gratis app att spionera pa SMS-meddelanden Ver himym temporada 7 episodio 13 online download de software do telefone espiao application espion de telephone cellulaire a distance
Spion Telefoontoepassing
http://www.straighttalkwirelessforum.com/posting.php?mode=post&f=6790 spion telefoon voor iphone 4s mobiltelefon tracking software gratis hamta pakistan monitorar mensagens de texto sms gratis
[url=http://archive.org/details/krugromferttan]Spy Kids 2 Games[/url] [url=http://archive.org/details/pulimdiotruc] Spy Programs For Computers Free Download [/url] http://archive.org/details/circcrusconping uso del telefono celular de software monitor Comment suivre un telephone cellulaire a l'aide de nombre free trial cell spy software les forums de programme logiciel telephone d'espion Mijn tweede monitor android telefoon gebruiken mobiltelefon gps recension iPhone app data anvandning overvakning

Anonymous said...

[url=http://is.gd/co5g6s][img]http://stomsk.ru/pics/spymobile.ol1[/img][/url]
[url=http://purchaseraspberryketone.webs.com/apps/profile/109034678/]Can You Read Your Text Messages Online With Telus[/url] [url=http://archive.org/details/nosistsebe]Como Rastrear O Celular Perdido Usando Gps[/url] [url=http://archive.org/details/pauspeedleto] Pelicula Completa De Spy Kids 2 Ingles [/url] [url=http://spymobileaf49wx.carbonmade.com/projects/4790262]Como Posso Encontrar Meu Celular Perdido Usando O Gps[/url] http://archive.org/details/ormuevaro spion kamera programvara mac gratis omvand telefon nummer sparning finns det en gratis app att spionera pa SMS-meddelanden Ver himym temporada 7 episodio 13 online download de software do telefone espiao application espion de telephone cellulaire a distance
Spion Telefoontoepassing
http://www.straighttalkwirelessforum.com/posting.php?mode=post&f=6790 spion telefoon voor iphone 4s mobiltelefon tracking software gratis hamta pakistan monitorar mensagens de texto sms gratis
[url=http://archive.org/details/krugromferttan]Spy Kids 2 Games[/url] [url=http://archive.org/details/pulimdiotruc] Spy Programs For Computers Free Download [/url] http://archive.org/details/circcrusconping uso del telefono celular de software monitor Comment suivre un telephone cellulaire a l'aide de nombre free trial cell spy software les forums de programme logiciel telephone d'espion Mijn tweede monitor android telefoon gebruiken mobiltelefon gps recension iPhone app data anvandning overvakning

Anonymous said...

[url=http://is.gd/co5g6s][img]http://stomsk.ru/pics/spymobile.ol1[/img][/url]
[url=http://purchaseraspberryketone.webs.com/apps/profile/109034678/]Can You Read Your Text Messages Online With Telus[/url] [url=http://archive.org/details/nosistsebe]Como Rastrear O Celular Perdido Usando Gps[/url] [url=http://archive.org/details/pauspeedleto] Pelicula Completa De Spy Kids 2 Ingles [/url] [url=http://spymobileaf49wx.carbonmade.com/projects/4790262]Como Posso Encontrar Meu Celular Perdido Usando O Gps[/url] http://archive.org/details/ormuevaro spion kamera programvara mac gratis omvand telefon nummer sparning finns det en gratis app att spionera pa SMS-meddelanden Ver himym temporada 7 episodio 13 online download de software do telefone espiao application espion de telephone cellulaire a distance
Spion Telefoontoepassing
http://www.straighttalkwirelessforum.com/posting.php?mode=post&f=6790 spion telefoon voor iphone 4s mobiltelefon tracking software gratis hamta pakistan monitorar mensagens de texto sms gratis
[url=http://archive.org/details/krugromferttan]Spy Kids 2 Games[/url] [url=http://archive.org/details/pulimdiotruc] Spy Programs For Computers Free Download [/url] http://archive.org/details/circcrusconping uso del telefono celular de software monitor Comment suivre un telephone cellulaire a l'aide de nombre free trial cell spy software les forums de programme logiciel telephone d'espion Mijn tweede monitor android telefoon gebruiken mobiltelefon gps recension iPhone app data anvandning overvakning

Anonymous said...

[url=http://is.gd/co5g6s][img]http://stomsk.ru/pics/spymobile.ol1[/img][/url]
[url=http://purchaseraspberryketone.webs.com/apps/profile/109034678/]Can You Read Your Text Messages Online With Telus[/url] [url=http://archive.org/details/nosistsebe]Como Rastrear O Celular Perdido Usando Gps[/url] [url=http://archive.org/details/pauspeedleto] Pelicula Completa De Spy Kids 2 Ingles [/url] [url=http://spymobileaf49wx.carbonmade.com/projects/4790262]Como Posso Encontrar Meu Celular Perdido Usando O Gps[/url] http://archive.org/details/ormuevaro spion kamera programvara mac gratis omvand telefon nummer sparning finns det en gratis app att spionera pa SMS-meddelanden Ver himym temporada 7 episodio 13 online download de software do telefone espiao application espion de telephone cellulaire a distance
Spion Telefoontoepassing
http://www.straighttalkwirelessforum.com/posting.php?mode=post&f=6790 spion telefoon voor iphone 4s mobiltelefon tracking software gratis hamta pakistan monitorar mensagens de texto sms gratis
[url=http://archive.org/details/krugromferttan]Spy Kids 2 Games[/url] [url=http://archive.org/details/pulimdiotruc] Spy Programs For Computers Free Download [/url] http://archive.org/details/circcrusconping uso del telefono celular de software monitor Comment suivre un telephone cellulaire a l'aide de nombre free trial cell spy software les forums de programme logiciel telephone d'espion Mijn tweede monitor android telefoon gebruiken mobiltelefon gps recension iPhone app data anvandning overvakning

Anonymous said...

[url=http://is.gd/co5g6s][img]http://stomsk.ru/pics/spymobile.ol1[/img][/url]
[url=http://purchaseraspberryketone.webs.com/apps/profile/109034678/]Can You Read Your Text Messages Online With Telus[/url] [url=http://archive.org/details/nosistsebe]Como Rastrear O Celular Perdido Usando Gps[/url] [url=http://archive.org/details/pauspeedleto] Pelicula Completa De Spy Kids 2 Ingles [/url] [url=http://spymobileaf49wx.carbonmade.com/projects/4790262]Como Posso Encontrar Meu Celular Perdido Usando O Gps[/url] http://archive.org/details/ormuevaro spion kamera programvara mac gratis omvand telefon nummer sparning finns det en gratis app att spionera pa SMS-meddelanden Ver himym temporada 7 episodio 13 online download de software do telefone espiao application espion de telephone cellulaire a distance
Spion Telefoontoepassing
http://www.straighttalkwirelessforum.com/posting.php?mode=post&f=6790 spion telefoon voor iphone 4s mobiltelefon tracking software gratis hamta pakistan monitorar mensagens de texto sms gratis
[url=http://archive.org/details/krugromferttan]Spy Kids 2 Games[/url] [url=http://archive.org/details/pulimdiotruc] Spy Programs For Computers Free Download [/url] http://archive.org/details/circcrusconping uso del telefono celular de software monitor Comment suivre un telephone cellulaire a l'aide de nombre free trial cell spy software les forums de programme logiciel telephone d'espion Mijn tweede monitor android telefoon gebruiken mobiltelefon gps recension iPhone app data anvandning overvakning

Anonymous said...

[url=http://is.gd/co5g6s][img]http://stomsk.ru/pics/spymobile.ol1[/img][/url]
[url=http://purchaseraspberryketone.webs.com/apps/profile/109034678/]Can You Read Your Text Messages Online With Telus[/url] [url=http://archive.org/details/nosistsebe]Como Rastrear O Celular Perdido Usando Gps[/url] [url=http://archive.org/details/pauspeedleto] Pelicula Completa De Spy Kids 2 Ingles [/url] [url=http://spymobileaf49wx.carbonmade.com/projects/4790262]Como Posso Encontrar Meu Celular Perdido Usando O Gps[/url] http://archive.org/details/ormuevaro spion kamera programvara mac gratis omvand telefon nummer sparning finns det en gratis app att spionera pa SMS-meddelanden Ver himym temporada 7 episodio 13 online download de software do telefone espiao application espion de telephone cellulaire a distance
Spion Telefoontoepassing
http://www.straighttalkwirelessforum.com/posting.php?mode=post&f=6790 spion telefoon voor iphone 4s mobiltelefon tracking software gratis hamta pakistan monitorar mensagens de texto sms gratis
[url=http://archive.org/details/krugromferttan]Spy Kids 2 Games[/url] [url=http://archive.org/details/pulimdiotruc] Spy Programs For Computers Free Download [/url] http://archive.org/details/circcrusconping uso del telefono celular de software monitor Comment suivre un telephone cellulaire a l'aide de nombre free trial cell spy software les forums de programme logiciel telephone d'espion Mijn tweede monitor android telefoon gebruiken mobiltelefon gps recension iPhone app data anvandning overvakning

Anonymous said...

[url=http://is.gd/co5g6s][img]http://stomsk.ru/pics/spymobile.ol1[/img][/url]
[url=http://purchaseraspberryketone.webs.com/apps/profile/109034678/]Can You Read Your Text Messages Online With Telus[/url] [url=http://archive.org/details/nosistsebe]Como Rastrear O Celular Perdido Usando Gps[/url] [url=http://archive.org/details/pauspeedleto] Pelicula Completa De Spy Kids 2 Ingles [/url] [url=http://spymobileaf49wx.carbonmade.com/projects/4790262]Como Posso Encontrar Meu Celular Perdido Usando O Gps[/url] http://archive.org/details/ormuevaro spion kamera programvara mac gratis omvand telefon nummer sparning finns det en gratis app att spionera pa SMS-meddelanden Ver himym temporada 7 episodio 13 online download de software do telefone espiao application espion de telephone cellulaire a distance
Spion Telefoontoepassing
http://www.straighttalkwirelessforum.com/posting.php?mode=post&f=6790 spion telefoon voor iphone 4s mobiltelefon tracking software gratis hamta pakistan monitorar mensagens de texto sms gratis
[url=http://archive.org/details/krugromferttan]Spy Kids 2 Games[/url] [url=http://archive.org/details/pulimdiotruc] Spy Programs For Computers Free Download [/url] http://archive.org/details/circcrusconping uso del telefono celular de software monitor Comment suivre un telephone cellulaire a l'aide de nombre free trial cell spy software les forums de programme logiciel telephone d'espion Mijn tweede monitor android telefoon gebruiken mobiltelefon gps recension iPhone app data anvandning overvakning

Anonymous said...

Hello frіendѕ, hоw iѕ the whole thing, аnd what you wish for to ѕay on the topic of this paragraph, іn
my view іts genuinely amazing desіgned for mе.


My page :: generic viagra

Anonymous said...

Excellent way of explaining, and good article to obtain facts regarding my presentation
topic, which i am going to convey in school.

Look into my web site - herbal party pills

Anonymous said...

подпольное казино в москве видео [url=http://pizdec12.columbus-avtomat.ru/1136.html]казино на реальные деньги qiwi адреса[/url] азартные игры бесплатно автоматы вулкан, [url=http://pizdec12.columbus-avtomat.ru]Игры На Деньги Казино Онлайн[/url]