For anyone interested. I took one of those old scripts, modified it into a data
warehouse sort of implementation then publish it every day at month end as an
internal web page. There's a copy of today's output at
http://vdac2.vicr.com/space_new.html if your interested.
Dick Goulet
Senior
Jared, David, Listers,
Another very useful method that I have used in the
past is the Ratio Modeling Technique. It is a
low-precision method, but it is better than
no-precision. Craig Shallahamer et al., wrote a paper
on it within the Oracle context. I am sure there are
many more out there, but I
In a nutshell:
Collect stats from dbms_free_space once a week, save them in a table.
Once a month, load the stats into another database for calculation.
Run them through a Perl filter to create a summary table by tablespace.
Use Oracle's Linear Regression functions to make a prediction of
blush Let's just say it's the same as Jared's...Yeah, that's it! The
very same! And my wife, Morgan Fairchild, whom I've seen naked.
sigh When you don't update those old scripts with newer versions of
Oracle they really look old and convoluted.
Rich
Rich Jesse
Hey, beauty is in the eye of the beholder. And if that were not true I sure could not
explain some of my friends wives.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, August 12, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
Took it a few years ago. Highly recommended.
Capacity planning is about a lot more than disk space,
which is probably the easiest part of it.
Jared
On Mon, 2003-08-11 at 17:24, Johnson, Michael wrote:
Just lurking as usual, but Craig Schallahammer (sp) has a fairly extensive
technical
David
I analyze the tables each week primarily to populate NUM_ROWS in
USER_TABLES. I use ANALYZE TABLE because that works better in 8.1.6. Then I
save the data to a separate table along with the date I did it. The primary
rows are schema_name (if there is more than one schema of interest),
Title: Capacity Planning Methods?
Just
lurking as usual, but Craig Schallahammer (sp) has a fairly extensive
technical
seminar on methods DBAs can use for capacity
planning.
Here
is the link to his web-site.
http://www.orapub.com/cgi/genesis.cgi
-Original Message-From: David
Title: RE: Capacity Planning Methods?
Rich,
I'd love to see the procedure and table that you use. Thanks for offering.
Best regards,
David B. Wagoner
Database Administrator
Arsenal Digital Solutions
Come on Brad, this is the guy's wife you're talking about !!
=)
Mike
-Original Message-
Sent: 12 August 2003 15:14
To: Multiple recipients of list ORACLE-L
EWWAH! Morgan FairchildYUK!
-Original Message-
Sent: Tuesday, August 12, 2003 9:44 AM
To: Multiple
EWWAH! Morgan FairchildYUK!
-Original Message-
Sent: Tuesday, August 12, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L
blush Let's just say it's the same as Jared's...Yeah, that's it! The
very same! And my wife, Morgan Fairchild, whom I've seen naked.
sigh
OK, I'll post it. Salt to taste or toss it in the garbage. Note that this
is just collecting data and doesn't make any recommendations or such.
Comments and critiques welcome, except from Mladen... (running for cover)
;)
And, of course, standard disclaimers apply!
Rich
Rich Jesse
PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 4:49 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Capacity Planning Methods?
David
I analyze the tables each week
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
: 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 business object to correlate with the DB size . I think in
our case both
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 do not belong to a
capacity
planning group in my shop , I mostly concentrate on the DB growth
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 -- Expecting the DB growth !!!
Hello All,
It should include all as you said
to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Capacity Planning -- Expecting the DB growth !!!
Jared,
Can you send me the script you use. I can't even figure out the syntax
for
DBMS_SPACE from the docs. I would be very
', 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]
cc:
Subject:Re: Capacity Planning
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
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
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
:
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 business object to correlate with the DB
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
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 ofdatabase
Title: Blank
Craig Shallahamer has a good training class
on this topic : http://www.orapub.com/cgi/genesis.cgi?p1=subp2=cp_course
- Kirti
-Original Message-From: Reddy, Madhusudana
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002
8:19 PMTo: Multiple recipients of list
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
-
Check out the courses offered by Craig Shallahammar (sp?) at
www.orapub.com
--- Schauss, Peter [EMAIL PROTECTED] wrote:
Thanks to everyone who made suggestions on training courses.
Looking at my skill set and the requirements of my current
position, I am thinking about taking a course in
Check out www.orapub.com. Craig Shallahamer conducts Capacity Planning
course. I have not yet attended one but I have heard from others that the
course is very good.
- Kirti
-Original Message-
Sent: Monday, June 24, 2002 8:43 AM
To: Multiple recipients of list ORACLE-L
Thanks to
Craig Shallahamer, www.orapub.com.
I've taken the class, it's excellent.
Two things you will learn:
* There's more to capacity planning than you thought
* It's not that hard to do, given the tools and techniques.
Jared
On Monday 24 June 2002 06:43, Schauss, Peter wrote:
Thanks to
Mike
You have not specified how much memory is on the machine, neither have you
specified which application you will be running against the box. also, are
you going to be using an intelligent RAID controller device (EMC, Shark,
similar) with this ? Are you running this across a LAN / WAN ? Are
Check Craig Shallahamer's web site (http://www.orapub.com) for Capacity
Planning documents. He also conducts a training class on this topic. I have
yet to attend it, but I have heard that it is good and worth attending.
- Kirti
-Original Message-
Sent: Thursday, May 30, 2002 12:57
Shibu,
Go
to
http://www.orapub.com
Craig
Shallahamer is THE Guru on the subject. I took his course a couple years
ago - excellent!
Jack
Jack C.
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit,
Inc.Austin,
Texaswww.iNetProfit.com[EMAIL
]
cc:
Subject:RE: capacity planning??
Shibu,
Go to
http://www.orapub.com
Craig Shallahamer is THE Guru on the subject. I took his course a couple
years ago - excellent!
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
for sun: Configuration and capacity planning for Solaris servers by Brian L.
Wong.
-Original Message-
Sent: Tuesday, February 05, 2002 10:46 AM
To: Multiple recipients of list ORACLE-L
Could anyone direct me to some excellent documentation on capacity planning
or give any insights that
Hi Shreepad,
Check out http://www.orapub.com//cgi//genesis.cgi?p1=subp2=train_main.
Craig Shallahamer offers a training class on all the things you are looking
for. Worth attending.
HTH,
Regards,
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
-Original
Adrian's Sun performance tuning book has some great comments on this.
Highly recommend looking at it, even though not Oracle specific entirely,
VERY good start.
-Original Message-
Sent: Tuesday, May 22, 2001 9:22 AM
To: Multiple recipients of list ORACLE-L
Hi List ,
Any one has any
For starters, you are going to require some information from
the project manager/developers/users or whoever is driving
the project.
Avg # of users simultaneously connected
Avg # of transactions
Avg transaction size
Desired average response time. This should really be part
of a Service Level
Excellent resource I might add.
-Original Message-
Sent: Tuesday, May 22, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L
Hi Shreepad,
Check out http://www.orapub.com//cgi//genesis.cgi?p1=subp2=train_main.
Craig Shallahamer offers a training class on all the things you are
39 matches
Mail list logo
