How To Do Capacity Planning For DB

Oct 31, 2011

how to do a capacity planning for a DB ?

View 1 Replies


ADVERTISEMENT

Performance Tuning :: Capacity Planning For 250 User OLTP Shop

Mar 19, 2013

installing Oracle for a new Data-Center(still in planning).It will be an OLTP shop working 24/7, with 250 concurrent users.

1. Can it, in theory run with good performance on a quad processor(something like Intel Xeon Series 56XX) , with 32GB of memory?
2. What is the Oracle Database Edition required for this configuration?
3. What additional things should one take into account to plan the most cost-effective configuration?

View 2 Replies View Related

SQL & PL/SQL :: To Select IDs Which Have No IN Or PLANNING Status In AREA 9

Apr 23, 2012

I want to select the IDs which have no IN or PLANNING status in AREA 9

ID 1 has AREA 9 and STATUS IN so dont select
ID 2 SELECT
ID 3 has area 9 BUT STATUS is OUT so Select.

So if an ID has has IN or PLANNING status in AREA 9 i do not wish to see it!

CREATE TABLE DAN_T1
(
ID varchar(8),
AREA varchar(8),
UNIT varchar(8),
STATUS varchar(8)
)
INSERT INTO DAN_T1 (ID,AREA,UNIT,STATUS) VALUES (1,6,'AA','IN');
[code]......

ID AREA UNIT STATUS
16AAIN
17ABPLANNING
17ACOUT
19ADIN
25ACIN
25AAOUT
35BAPLANNING
36DAIN
35CAIN
39CGOUT

WANT:

ID
2
3

View 2 Replies View Related

Performance Tuning :: Increased LOGFILE Capacity Not Decrease Execution Time?

Aug 6, 2012

I'm planning to decrease the time taken to execute data by managing the redo log file but I'm kinda stuck in some aspect : > Why is my OPTIMAL_LOGFILE_SIZE is showing NULL ? > I'm trying to resize the LOGFILE capacity from 100M to 200M and I'm also adding 1 more LOG GROUP with 200M capacity too but turned out that didn't decrease my execution time.

View 12 Replies View Related

PL/SQL :: Resource Planning And Jobs Grouping In Oracle

Mar 20, 2013

I have a requirement where I need to group sessions which takes time as given below when ran individually .There are a total of 32 sesions.I want to divide them into 7 groups.I want to submit each one of the 7 groups in a job.So there will be seven jobs on the whole.Execution flow will be group 1 completes ,then group 2 starts like that.Actually I don't want to bombard the database at a time with 32 jobs ,hence the idea of grouping 32 jobs among 7 groups.grouping the sessions so that on the whole ,resources are equally allocated among sessions in a group and which in turn makes the process complete faster. I want to achieve parallelism but at the same time database should not be loaded too much.I just want to know is there any good practice from oracle side while doing this type of grouping. I am planning to group the most time taking one with least time taking jobs.

S.NO     Session_Name     DURATION(HH:MM:SEC)
1     Session_1     00:11:56.202368
1     Session_2     00:00:00.058542
1     Session_3     00:00:00.055205
1     Session_4     00:00:00.043454
1     Session_5     00:00:00.039994
2     Session_6     00:08:05.786031
2     Session_7     00:00:00.579035
2     Session_8     00:00:00.537957
[code]...

View 0 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved