EWWAH! Morgan FairchildYUK!
-Original Message-
Sent: Tuesday, August 12, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L
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.
When you don'
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 recipien
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
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 W
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
> se
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), dat
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
EWW
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.
When you don't update those old scripts with newer versions of
Oracle they really look old and convoluted.
Rich
Rich Jesse System/Databa
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 fut
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
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
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
istrator
[EMAIL 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?
>
>
13 matches
Mail list logo