h growth is not
alwasy linear, it's still better than a SWAG.
Jared
"Reddy, Madhusudana" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/17/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
t Used Block', l_last_used_block);
end;
/
show error procedure show_space
"Ruth Gramolini" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/18/2002 07:04 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
n a SWAG.
Jared
"Reddy, Madhusudana" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/17/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Capacity Planning -- Expecti
nt by: [EMAIL PROTECTED]
12/17/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Capacity Planning -- Expecting the DB growth !!!
Hello All,
It should include all as you said , but since I
ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Capacity Planning -- Expecting the DB growth !!!
Hello All,
It should include all as you said , but since I do not belong to a
capacity
planning group in my shop , I mostly concentrate on the DB growth . I have
taken Sales as
One thing I don't think I've seen mentioned is the issue of storage
configuration and uptime requirements impact on capacity planning. Is the
planned system 7x24 or will there be maintenance windows to add storage?
Can storage be added hot or is downtime required. These issues will require
the f
> -Original Message-
> From: Stephane Paquette [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 17, 2002 3:13 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Capacity Planning -- Expecting the DB growth !!!
>
>
> There is not really capac
There is not really capacity planning here. I'm
starting a new job as a permanent employee and since
my first project is quite small, I've started writing
a capacity planning guide hoping the other groups will
collaborate.
One thing we do is to run statspack each hour on all
production databases
s of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Capacity Planning -- Expecting the DB growth !!!
Hello All,
It should include all as you said , but since I do not belong to a
capacity
planning group in my shop , I mostly concentrate on the DB growth . I have
taken Sale
Hello All,
It should include all as you said , but since I do not belong to a capacity
planning group in my shop , I mostly concentrate on the DB growth . I have
taken Sales as business object to correlate with the DB size . I think in
our case both of them are directly proportional. ( Business ob
Check the link Kirti has posted (orapub).
Is capacity planning only on the database size ?
In my mind it also includes :
Transaction description (online and batch)
Transaction frequency (online and batch)
Transaction window
Networking requirements
Number of users (all and concurren
Reddy - Step number one is to immediately begin collecting size data. For
most sites, storing a weekly count of the number of rows in each table is
sufficient. Usually combine it with regular ANALYZE TABLE or DBMS_STATS
executions. This will be your basis for making projections.
Then get to kno
Title: Blank
Load 5-10% of the stuff and see how much
it takes .
From this you can calculate.
No formula will give you accurate results, mainly because
actual field length vary so much that approximation is useless.
(based on a lot of years checking this)
Yechiel AdarMehish
- Origi
Title: Blank
Craig Shallahamer has a good training class
on this topic : http://www.orapub.com/cgi/genesis.cgi?p1=sub&p2=cp_course
- Kirti
-Original Message-From: Reddy, Madhusudana
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002
8:19 PMTo: Multiple recipients of list OR
Title: Blank
so how r u gonna do it?
1 business object = n number of rows in m
different tables + indexes
if regular day then x number of
business objects are created
if holiday then y number of business objects
are created
and are u going to considering the
historical growth of data
15 matches
Mail list logo