| Maximum Rowsize in Oracle [message #129441] |
Mon, 25 July 2005 05:04  |
nirmalnarayan
Messages: 261
Registered: April 2005
Location: India
|
Senior Member |
|
|
Hi,
What is the maximum row size allowed in a Oracle table, how can we know that maximum of how many rows can be inserted into a Oracle Table, Is there any method to find it out ?
Thanx and Regards,
Nirmal
|
|
|
|
|
|
| Re: Maximum Rowsize in Oracle [message #129550 is a reply to message #129441] |
Mon, 25 July 2005 14:07  |
oraclejo
Messages: 50
Registered: July 2005
Location: Ammar
|
Member |
|
|
hello
it is practically unlimited.
Each row can accomodate 2000 field
the max size of each field is type dependent
varchar2 is 4000 , however, Large Objects (LOBs) can be 4GB each. Therefore, you could have 4GB * 4000 or 16000 GB 16 Tera
however, such question should not occur to you, because a normalized database design tend to make row size smaller. As a matter of fact, a large number of column in a row is an indicative of poor design
RGDS
Ammar Sajdi
www.e-ammar.com
|
|
|
|
| Re: Maximum Rowsize in Oracle [message #129603 is a reply to message #129550] |
Mon, 25 July 2005 22:47 |
nirmalnarayan
Messages: 261
Registered: April 2005
Location: India
|
Senior Member |
|
|
Hi,
Thank you for your reply . Actually what i meant to say was, is there any limit in number of rows that we can insert in a table.
For eg., i have a table with 4 columns, can i insert more than, say '1000000 rows' into this table. Will it slow down the database while accessing this table, which is also well indexed ?.
i.e., there is any limit for Number of Rows i can insert into a table, irrespective of the number of columns in that table.
Thanx and Regards,
Nirmal.
|
|
|
|
| Re: Maximum Rowsize in Oracle [message #129621 is a reply to message #129441] |
Tue, 26 July 2005 00:33 |
oraclejo
Messages: 50
Registered: July 2005
Location: Ammar
|
Member |
|
|
Hi
The number of rows that you can insert into a table is beyond your imagination.
with regard to performance, if you want to select a specific row from the table then you need to create the proper indexes. Only then the performance will be acceptable. without indexing, you have to read the entire table, and in this case the larger the table, the longer it will take to read.
think of a phone directory of 1 page and another of 1000 pages
assume that these directories are not sorted alphabatically, how long would it take you to perform lookup of your own name, do it again, but this time assuming that the directories are sort alphabatically by name!!!
Database tables behave (more or less the same)
Ammar
|
|
|
|
| Re: Maximum Rowsize in Oracle [message #129732 is a reply to message #129441] |
Tue, 26 July 2005 07:58 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
The link that Jim posted is a good one. Basically at some number of rows (really size, but rows lead to size) you will want to start using partitioning. But that is going to be a table specific thing.
But don't spend any time worrying about "breaking" oracle or putting "too many" rows into a table. Do worry about performance implications and managability implications, and that is where indexes and partitioning etc come in to play.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
