Detemine table is big or small [message #426898] |
Tue, 20 October 2009 05:05  |
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 #426915 is a reply to message #426912] |
Tue, 20 October 2009 05:50   |
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   |
pablolee
Messages: 2882 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 #426920 is a reply to message #426918] |
Tue, 20 October 2009 05:58   |
cookiemonster
Messages: 13963 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Mohan10g wrote on Tue, 20 October 2009 11:56let 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 #426928 is a reply to message #426898] |
Tue, 20 October 2009 06:23   |
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 #426942 is a reply to message #426934] |
Tue, 20 October 2009 06:42   |
pablolee
Messages: 2882 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   |
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   |
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  |
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
|
|
|