Jump to content

Roshan

Members
  • Content count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Roshan

  • Rank
    Newbie

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Roshan

    storage sizing

    Oracle Database 12.2.0 RHEL 7.4 Hi, I am planning to calculate the storage capacity for 18 months after which tables would be compressed. increase size of partition BIMOBSMS 01-SEP-17->30-SEP-17 21.2 GB 01-oct-17->30-oct-17 600 mb 21.26 GB 01-NOV-17->30-NOV-17 19.8 GB 01-DEC-17->30-DEC-17 1.66 GB 21.46 GB 01-JAN-18->30-JAN-18 20.4 GB 01-FEB-18->28-FEB-18 19.3 GB 01-MAR-18->28-MAR-18 1.98 GB 21.28 GB 01-APR-18->28-APR-18 20.47 GB 01-MAY-18->28-MAY-18 20.47 GB 01-JUNE-18->28-JUNE-18 5.73 GB 26.2 GB 01-JULY-18->28-JULY-18 3.92 GB 30.12 GB 01-AUG-18->28-AUG-18 30 GB 01-SEP-18->28-SEP-18 28.4 GB 01-OCT-18->26-OCT-18 22.25 GB could you please advise how I should calculate it? What compression mechanism should I implement it? Thanks, Roshan
  2. Oracle Database 12.2.0 RHEL 7.4 Hi, Could you please help me on how I should build my tablespaces on my new environment. I am actually migrating tables from different sources and also loading into tables from flat files. 1. First, from 1 source(source A), almost all tables are constant in size for last 3 months. The table size varies from DWH_BI_CB0 - 1kb - 23 mb(table size) DWH_BI_CB1 - 50 mb - 435 mb(table size) DWH_BI_CB2 - 800 mb - 3.77 gb(table size) For some tables, the daily increase could be like shown below TABLEX 289.5 mb 7 kb increase 290.2 mb 1 mb 291.1 mb 281.3 mb 7 mb 288.3 mb 2 mb 290.2 mb 1 mb 291.1 mb 291.0 mb How should I build the tablespaces? Should I build 3 tablespaces for example DWH_BI_CB0 - 1kb - 23 mb(table size) DWH_BI_CB1 - 50 mb - 435 mb(table size) DWH_BI_CB2 - 800 mb - 3.77 gb(table size) where table sizings shown above go into their respective tablespaces? or should I build a single tablespace where all tables which are contant in size go into it(1KB - 3.77 GB)? or should I build tablespaces based on the size of the daily increment(for example monthly increment of 1g to into 1 tablespace and increment of 1mb go into another tablespace)? Taking into consideration the increment parameter and maximum file size Thanks, Roshan
×