All Questions
4 questions
0
votes
0
answers
276
views
Oracle Database Capacity Planning
Just want to know if there is a formula I can use how to estimate database storage size needed based on estimated number of records and data types of those records that will be stored.
Are there ...
0
votes
1
answer
90
views
Best way to design for one-to-many code values in Oracle
We receive several millions of records per day on temperature metrics. Most of the pertinent metadata for these records is maintained in a single partitioned table by date (month). We are going to ...
- 7
6
votes
1
answer
600
views
One large table partitioned and then subpartitioned or several smaller partitioned tables?
I currently have several audit tables that audit specific tables data.
e.g. ATAB_AUDIT, BTAB_AUDIT and CTAB_AUDIT auditing inserts, updates and deletes from ATAB, BTAB and CTAB respectively.
These ...
- 17.6k
3
votes
5
answers
2k
views
Partition by Date and PK
I am designing a new laboratory database.
My primary data tables will have at least id (PK NUMBER) and created_on (DATE). Also, for any two entries, the entry with a higher id will have a later ...
- 13.8k