troubleshooting Question

# How to estimate the space that can be occupied for new tables and indexes in Oracle 8i

Oracle Database
Hello There,
Firstly I am not a DBA. I have been asked to calculate the required space when I have introduced a new tables and indexes for my application. Can you please help me as how can I estimate / project that this much of space will be occpuied or required.
Eg:
Currently i have the following figures:
Database Disk Space:
Allocated:            65.30GB
Used:                  31.37GB
Available:            33.93GB
--------------------------------------------
I have created a (Table A) comprising of the following column lengths:
CHAR(5) not null,      -- 100% used
NUMBER(4) not null,    -- 100% used
NUMBER(4) not null,    -- 100% used
NUMBER(2) not null,    -- 100% used
CHAR(8) not null,      -- 100% used
CHAR(17) not null,     -- 100% used
CHAR(10),              -- 100% used
DATE,                  -- 100% used dd/mm/yyyy
CHAR(3),               -- 100% used
CHAR(3),               -- 100% used
CHAR(10),              -- 100% used
CHAR(2),               -- 100% used
NUMBER(13),            -- 100% used
NUMBER(4),             -- 100% used
NUMBER(7),             -- 100% used
NUMBER(4),             -- 100% used
NUMBER(2),             -- 100% used
CHAR(1),               -- 100% used
CHAR(1)                -- 100% used
tablespace ABC
pctfree 20
pctused 40
initrans 5
maxtrans 255
storage
(
initial 40M
next 10M
minextents 1
maxextents unlimited
pctincrease 0
);

I also have the below Index created for the above table
eg:
-- Create/Recreate indexes
create index TABLE_A_IDX1 on TABLE_A (FNN, SRVC_NO, CA_DATE)
tablespace &&12 -- MCP_MAST_IDX1
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 20M
next 10M
minextents 1
maxextents unlimited
pctincrease 0
);
-----------------------------------
I would expect around 3000 records going into this table everyday. Therefore how do I:
a) Calculate the space it can occupy or it requires (to be extended).
b) Do we have a generic formula to calculate the space that a new table can take
eg: No Rows, n Rows.
c) How can we calculate an average growth by considering the below given figures
3000 Rows per day. 7 Days a Week

Please assist with some scripts / formula so that I can estimate.
Join the community to see this answer!
###### Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.