Server Capacity Planning

1) Existing server configuration (Processor, No of CPU, RAM, Disk Capacity, … , …)

2) No. of running databases on server

3) Databases folder size of all years

4) No of Users ( concurrent connections) in the database

5) Weekly or monthly growth of databases.

6) Oracle core license??

----------------------------Memory----------------

select * from dba_high_water_mark_statistics where name in ('SESSIONS','DB_SIZE');

select * from v$resource_limit;

--------maximum amount of memory allocated by the currently connected sessions

SELECT SUM (value) "max memory allocation" FROM v$sesstat ss, v$statname st WHERE st.name = 'session uga memory max' AND ss.statistic# = st.statistic#;

------------------pga requirement------------

select

(select highwater from dba_high_water_mark_statistics where name = ('SESSIONS');)*(2048576+a.value+b.value) pga_size

from

v$parameter a,

v$parameter b

where

a.name = 'sort_area_size'

and

b.name = 'hash_area_size'

;

-----------------------CPU Benchmark------------------------------

http://www.cpubenchmark.net/multi_cpu.html

-----------------------Space Management---------------

As per database growth weekly /monthly and planning for how many year