Home » SQL & PL/SQL » SQL & PL/SQL » Detemine table is big or small (10.2.0.4.0 ,windows)
Detemine table is big or small [message #426898] Tue, 20 October 2009 05:05 Go to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Hi,

Table size can be found using dba_segments view .I want to know how to determine
whether a table is big or small ?

Thanks in advance.
Re: Detemine table is big or small [message #426900 is a reply to message #426898] Tue, 20 October 2009 05:09 Go to previous messageGo to next message
pablolee
Messages: 2813
Registered: May 2007
Location: Scotland
Senior Member
Define big and small.
(So many possible jokes)

[Updated on: Tue, 20 October 2009 05:10]

Report message to a moderator

Re: Detemine table is big or small [message #426901 is a reply to message #426898] Tue, 20 October 2009 05:11 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select * from dba_segments where bytes='few';
select * from dba_segments where bytes='alot';

Regards
Michel
Re: Detemine table is big or small [message #426902 is a reply to message #426901] Tue, 20 October 2009 05:14 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Michel Cadot wrote on Tue, 20 October 2009 12:11
select * from dba_segments where bytes='few';
select * from dba_segments where bytes='alot';


NO!!

Never store a number as a string. Not even a "few" or "alot" of bytes!



[edit: great one, btw Smile]

[Updated on: Tue, 20 October 2009 05:14]

Report message to a moderator

Re: Detemine table is big or small [message #426903 is a reply to message #426901] Tue, 20 October 2009 05:19 Go to previous messageGo to next message
pablolee
Messages: 2813
Registered: May 2007
Location: Scotland
Senior Member
Bwahahahahah Laughing Nice one.
Re: Detemine table is big or small [message #426906 is a reply to message #426903] Tue, 20 October 2009 05:28 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Laughing Laughing Laughing
Re: Detemine table is big or small [message #426910 is a reply to message #426898] Tue, 20 October 2009 05:41 Go to previous messageGo to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
Joke of the day Smile

[Updated on: Tue, 20 October 2009 05:42]

Report message to a moderator

Re: Detemine table is big or small [message #426912 is a reply to message #426910] Tue, 20 October 2009 05:45 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member


yes, because they dont know the answer for my question and laughing instead.

Re: Detemine table is big or small [message #426915 is a reply to message #426912] Tue, 20 October 2009 05:50 Go to previous messageGo to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
No, Your question was pointless.



Table that have large number of rows you can treat as BIG tables
and those that have less data you can call it as SMALL ones.


But again its only by comparing the tables in your database you can define BIG or SMALL.


How you treat a table as BIG ones ? The table that have 1000 records, 10000 records? 1 million records?




[Updated on: Tue, 20 October 2009 05:55]

Report message to a moderator

Re: Detemine table is big or small [message #426917 is a reply to message #426912] Tue, 20 October 2009 05:52 Go to previous messageGo to next message
pablolee
Messages: 2813
Registered: May 2007
Location: Scotland
Senior Member
No, the joke is that your question is meaningless. Size is relative. What is big to you, may well be small to me. You stated that you were able to get the size of a table via %_segments. You then ask how to determine whether a table is large or small. Completely subjective and impossible to answer without some sensible parameters. So why not answer the question that was asked of you instead of going in a huff.
Re: Detemine table is big or small [message #426918 is a reply to message #426915] Tue, 20 October 2009 05:56 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

let it be pointless.Those who can understand my question ,can answer and
those who understand my question and act as if though they dont , can scribble here.
Re: Detemine table is big or small [message #426920 is a reply to message #426918] Tue, 20 October 2009 05:58 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Mohan10g wrote on Tue, 20 October 2009 11:56
let it be pointless.Those who can understand my question ,can answer and
those who understand my question and act as if though they dont , can scribble here.


We all understood your question.
You need to define big and small.
Re: Detemine table is big or small [message #426924 is a reply to message #426918] Tue, 20 October 2009 06:07 Go to previous messageGo to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
@Mohan,
How Big Is Small? Smile Do you have the answer to it?
Re: Detemine table is big or small [message #426928 is a reply to message #426898] Tue, 20 October 2009 06:23 Go to previous messageGo to next message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member

Mohan,

Can you please be specific to your question .. what are you expecting from this forum tell me.

What exactly you wanted to do with BIG and SMALL in your Database.

One question from my side .. How do say that your database size is big or small on what basis you justify this . can you answer me this ?

Regards

Bala

Re: Detemine table is big or small [message #426934 is a reply to message #426928] Tue, 20 October 2009 06:35 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

If database size is in MB or KB in size ,we can say it is small in size.If DB is GB or in TB in size ,
we can say db size is big.

Similarly,the table size can be determined (how big it is) based on number of records it contains.
As Ved says ,if table contains 1000 records or more than it , we can say the table size is big.

Correct me if im wrong .

Regards,



Re: Detemine table is big or small [message #426938 is a reply to message #426934] Tue, 20 October 2009 06:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
If database size is in MB or KB in size ,we can say it is small in size.If DB is GB or in TB in size ,
we can say db size is big.


Seems you already answered your own question.

>>Table size can be found using dba_segments view

If that was NOT your question, what would it be?
Re: Detemine table is big or small [message #426942 is a reply to message #426934] Tue, 20 October 2009 06:42 Go to previous messageGo to next message
pablolee
Messages: 2813
Registered: May 2007
Location: Scotland
Senior Member
Mohan10g wrote on Tue, 20 October 2009 12:35

As Ved says ,if table contains 1000 records or more than it , we can say the table size is big.

Correct me if im wrong .

Regards,


I completely disagree. 1000 rows is very small as far as I'm concerned. 1 million rows is still small as far as I'm concerned. But the point is that that is just my opinion. I happen to be working with some fairly large datasets at the moment (several million rows) But then, maybe you can say that 1000 rows [i]is[/b] big, based on your opinion.
Re: Detemine table is big or small [message #426943 is a reply to message #426898] Tue, 20 October 2009 06:44 Go to previous messageGo to next message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member
Mohan,

You have the answer with you right!! . when you can say the size in kb,mb,gb,tb,Pb,Eb etc. why dont you just write queries by yourself and you decide what is BIG and SMALL instead of posting questions in forums. Am i write ?

Regards

Bala
Re: Detemine table is big or small [message #426944 is a reply to message #426934] Tue, 20 October 2009 06:45 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Here's where we see the problem.

You say a table with more than a 1000 rows in it is big.
I routinely produce test cases on 10,000 - 100,000 row tables, and consider them no more than medium sized at best.
I wouldn't consider a table to be big with less than 10,000,000 rows in it.

I'd agree that a database that is measuerd in MB is small, but a GB
database is routine, not large.

Oracle view a large tablespace as one requireing a bigfile datafile, which will hold roughly 4,000,000,000 blocks (32-128 TB, depending on block size)

Re: Detemine table is big or small [message #426945 is a reply to message #426934] Tue, 20 October 2009 06:45 Go to previous message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
@Mohan,
You cant say anything BIG without the existance of SMALL.
Its just a matter of perception.

Quote:

How you treat a table as BIG ones ? The table that have 1000 records, 10000 records? 1 million records?

It was a question raised to you. How you treat a table as Big ones? Table with 1000 rows? 10000 rows ? I million and so on.

I did not meant that tables with 1000 rows can be treat as a BIG one. I only said its just by comparing other ones.


And thats the reason why I asked

Quote:

How BIG is small? Ask yourself ..think for a while
and you will understand How pointless the question is

[Updated on: Tue, 20 October 2009 06:54]

Report message to a moderator

Previous Topic: Page break in pl/sql
Next Topic: Using Case in Cursor
Goto Forum:
  


Current Time: Thu Sep 29 14:16:23 CDT 2016

Total time taken to generate the page: 0.07683 seconds