troubleshooting Question

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

Avatar of raghx_2000
raghx_2000 asked on
Oracle Database
3 Comments1 Solution629 ViewsLast Modified:
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!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
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.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros