Showing posts with label capacity planning. Show all posts
Showing posts with label capacity planning. Show all posts
Monday, May 7, 2012

Table Reorganization, Rebuild

›
Tables in Oracle database become fragmented after mass deletion, or after so many delete and/or insert operations. BEGIN  FOR cur_rec IN ...
Thursday, March 15, 2012

Server Configuration Planning

›
1) Existing server configuration (Processor, No of CPU, RAM, Disk Capacity, … , …) 2) No. of running databases on server 3) Databases fol...

Hardware Requirement

›
Minimum Hardware Requirements On small instances, server load is primarily driven by peak visitors. 5 Concurrent Users 2GHz+ CPU 512MB RAM 5...

Database Growth Monitoring

›
Step : 1 Calculate total Size of tablespace select sum(bytes)/1024/1024 "TOTAL SIZE (MB)" from dba_Data_files; Step : 2 Calculate ...

Table Actual Size

›
SELECT owner, table_name, TRUNC(sum(bytes)/1024/1024) Meg FROM (SELECT segment_name table_name, owner, bytes FROM dba_segments WHERE se...
Monday, February 13, 2012

Server Capacity Planning

›
1) Existing server configuration (Processor, No of CPU, RAM, Disk Capacity, … , …) 2) No. of running databases on server 3) Databases fol...

SGA PGA measuring

›
select * from v$sgastat order by 1; select * from v$pgastat order by 1; I noticed that you have some Pools in your SGA which are not used: l...
Tuesday, December 13, 2011

Resizing Recreating RedoLogs / Increase Redo log / Archivelog generation fast size

›
--------------------------------------------final steps-------------------------- select group#, status from v$log; ALTER SYSTEM CHECKPOINT ...
Monday, December 12, 2011

Archivelog Frequency

›
A script to check the frequency of log switches col MidN format 999 col 1AM format 999 col 2AM format 999 col 3AM format 999 col 4AM format ...
Saturday, December 3, 2011

Buffer Cache Size

›
High CPU_COUNT and increased granule size can cause ORA-0431 error. ------CPU_COUNT specifies the number of CPUs available to Oracle. On sin...
Saturday, April 9, 2011

Memory management SGA PGA

›
RAM=16 GB WINDOW PROCESS=16*20%=3.2 GB ORACLE SERVICES=12 GB PGA_AGGREGATE_TARGET==(RAM*80%)*50% FOR DSS PGA_AGGREGATE_TARGET==(RAM*80%)*20%...
Friday, April 8, 2011

SGA Tuning

›
There are two parameters SGA_TARGET: RAM SPACE IS ASSIGNED TO ORACLE SERVICES, CAN SEE ON TASK MANAGER PROCESS This parameter is new with O...

PGA Tuning

›
Select Name,Value/1024/1024 From V$parameter where name like '%pga%'; Make a first estimate for PGA_AGGREGATE_TARGET , based on a r...

Shrink datafile space from dropped table

›
Shrink datafile space from dropped table ================================================== select sum(bytes) / 1024 / 1024 / 1024 from dba_...
Wednesday, April 6, 2011

Check Unused Space

›
SQL> set serveroutput on SQL> set pages 1000 SQL> set lines 160 SQL> DECLARE 2 alc_bks NUMBER; 3 alc_bts NUM...