Planning for Table and Index Storage Planning the storage of tables and indexes is best done during the physical design stage in order to improve performance and to streamline data administration tasks. This section will help you to do this and is comprised of the following topics. In order to ensure optimal database performance, it is important that you assess your storage needs and plan accordingly. Oracle Capacity Planning And Sizing Spreadsheets Crack DownloadĬontents.This is how we have done capacity planning in our environment. u03/oradata/TESTDB/–>37GB=15G(at filesystem level)+13G(remaining half of tablespace level)+6G(at database Level)+3GB(extra space)īoth file system should be extended by 37GB. u02/oradata/TESTDB/–>37GB=15G(at filesystem level)+13G(half of tablespace level)+6G(at database Level)+3GB (Extra space) SQL> !df -k /u02/oradata/TESTDB/įilesystem 1K-blocks Used Available Use% Mounted onĦ7088008 61150856 2529472 97% /u02/oradataįor above filesystem–>16 GB is 75% of 64GB–already exists 2GB–> space to be added 15GB. u02/oradata/TESTDB/edsdata07.dbf 11 rows selected.
In database execute below query to find datafile location. Step 4: At File system level calculation: To make all tablespaces at 75%–> 25GB is required. Check tablespace utilization and bring down the utilization below 80% for all tablespaces if possible.If not check how much space needed at tablespace level to make it 80% and add that space also in total calculation.įor EDSDATA tablespace –> 24G needed to make it to 75%(99172/1024=96G*25/100= 25% 0f origninal value(this space to be added to make it to 75%)
Step 3: At Tablespace Level:Ĭlick here for tablespace scripts. Growth rate: 1GB/month–> For one year 12GB. Sdb.report_date in (select next_day(trunc(report_date, 'MONTH')-1, 'Monday') from system.db_trends where report_date= sdb.report_date) Where sdb.report_date > sysdate - 180 and sdb.database='TESTDB' and Step 1: Login into the database: step 2: Calculate database growth by using below script: select sdb.database, sdb.report_date, sum(sdb.used_space/1024/1024) "used_space-GB", sum(sdb.total_space/1024/1024) "total_space-GB" The UNIX team will receive file system utilization alert and since its ORACLE database disk, they will ask us to clear some space to bring it under threshold.īefore asking for space, we need to check last one year database growth, tablespace utilization in database and how much space needed at disk level to bring it below threshold.īelow is the real time example steps for oracle database capacity planning(the database name TESTDB and server name is UNIXSERVER). Capacity planning for ORACLE database comes into play when ORACLE file system reaches above threshold level.
0 kommentar(er)
