Re: How to set up an extremely large database
Posted by:
Rick James
Date: October 16, 2016 03:41PM
First, a bit of perspective. 1M rows is about the 80th percentile of tables, so I don't call it "extremely large"; I would say that about a billion rows.
A convenient rule of thumb for a table without any TEXT or BLOB columns is to say 200 bytes per row. So, your description adds up to well under a 1GB. On the other hand, your storeys may add a few GB.
Again, the 80th percentile for table size (in bytes this time) is about 170GB.
Subject
Written By
Posted
Re: How to set up an extremely large database
October 16, 2016 03:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.