1833107 Members
3255 Online
110051 Solutions
New Discussion

capacity planing

 
khilari
Regular Advisor

capacity planing

Hi guys, i wanted to ask as to how do u do capacity planning. How to predict when the systems need more disk. Talking with dba's etc.
Thanks
4 REPLIES 4
tkc
Esteemed Contributor

Re: capacity planing

you can try using the 'du' command to monitor your disk usage on a regular basis and check for its growth.

more info about this command :

http://www.docs.hp.com/en/B2355-60127/du.1.html
TY 007
Honored Contributor

Re: capacity planing

Hello Khilari,

Planning Storage for Oracle 10g RAC:
http://docs.hp.com/en/T1859-90048/ch02s05.html

Planning Database Storage:
http://docs.hp.com/en/T1859-90048/ch03s01.html

Thanks
AwadheshPandey
Honored Contributor

Re: capacity planing

here is a good pdf to follow
http://www.teamquest.com/pdfs/whitepaper/tqwp23.pdf
It's kind of fun to do the impossible
Wim Rombauts
Honored Contributor

Re: capacity planing

One good tool is glance (if you have it) or sar.
Run it from time to time and check :
-> Is your system running above 80% CPU for a longer time during the day, or multiple times only for short durations : Then you are ready for a CPU upgrade.
-> Glance has a nice memory report that shows memory usage and free memory. It also shows process deactivations,which are really bad things for performance.

ut the best way to talk about capacity planning, are your DBA's themselves : Let them plan for data growth, memory growth of the SGA and PGA, and growth in CPU usage. Then you can size your system according to their numbers (with a little space for expansion). If the suddenly come screeming in that there database has insufficient storage (or CPU or memory), while they had not planned it in advance, you can blame them :-)