RE: Capacity Planning Methods?

2003-08-14 Thread Odland, Brad
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't update those old scripts with newer versions of
Oracle they really look old and convoluted.


Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


-Original Message-
Sent: Monday, August 11, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L


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 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Capacity Planning Methods?

2003-08-14 Thread Hately, Mike (LogicaCMG)
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 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't update those old scripts with newer versions of
Oracle they really look old and convoluted.


Rich



E mail Disclaimer

You agree that you have read and understood this disclaimer and you agree to be bound 
by its terms.

The information contained in this e-mail and any files transmitted with it (if any) 
are confidential and intended for the addressee only.  If you have received this  
e-mail in error please notify the originator.

This e-mail and any attachments have been scanned for certain viruses prior to sending 
but CE Electric UK Funding Company nor any of its associated companies from whom this 
e-mail originates shall be liable for any losses as a result of any viruses being 
passed on.

No warranty of any kind is given in respect of any information contained in this   
e-mail and you should be aware that that it might be incomplete, out of date or 
incorrect. It is therefore essential that you verify all such information with us 
before placing any reliance upon it.

CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hately, Mike (LogicaCMG)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Capacity Planning Methods?

2003-08-14 Thread David Wagoner
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





RE: Capacity Planning Methods?

2003-08-14 Thread Johnson, Michael
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 Wagoner 
  [mailto:[EMAIL PROTECTED]Sent: Monday, August 11, 2003 
  2:24 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Capacity Planning Methods?
  How do you guys collect capacity planning metrics, 
  such as DB size? 
  Do you use StatsPack, Oracle OEM, others?  I'm 
  interested in an efficient method to track DB growth in GB month over 
  month.
  Best regards, 
  David B. Wagoner Database Administrator 


RE: Capacity Planning Methods?

2003-08-14 Thread Jared Still

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
> 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-
> Sent: Monday, August 11, 2003 2:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> How do you guys collect capacity planning metrics, such as DB size? 
> 
> Do you use StatsPack, Oracle OEM, others?  I'm interested in an efficient
> method to track DB growth in GB month over month.
> 
> 
> Best regards, 
> 
> David B. Wagoner 
> Database Administrator 
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Capacity Planning Methods?

2003-08-14 Thread DENNIS WILLIAMS
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), date,
num_rows, chained_rows, blocks. Whatever suits your purposes. Then I can go
back and see the pattern of growth over time. 



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, August 11, 2003 4:24 PM
To: Multiple recipients of list ORACLE-L



How do you guys collect capacity planning metrics, such as DB size? 

Do you use StatsPack, Oracle OEM, others?  I'm interested in an efficient
method to track DB growth in GB month over month.


Best regards, 

David B. Wagoner 
Database Administrator 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Capacity Planning Methods?

2003-08-14 Thread Goulet, Dick
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


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't update those old scripts with newer versions of
Oracle they really look old and convoluted.


Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


-Original Message-
Sent: Monday, August 11, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L


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 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Capacity Planning Methods?

2003-08-14 Thread Jesse, Rich
  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/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


-Original Message-
Sent: Monday, August 11, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L


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 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Capacity Planning Methods?

2003-08-14 Thread Jared . Still

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 future
usage at the end of the year, middle of next year, and end of next year.

LR is also used to predict the current usage based on past space.  The
difference between the actual and the prediction is used to adjust future
predictions.

It ain't perfect, but it's fairly accurate.

Jared







David Wagoner <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/11/2003 02:24 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Capacity Planning Methods?


How do you guys collect capacity planning metrics, such as DB size? 
Do you use StatsPack, Oracle OEM, others?  I'm interested in an efficient method to track DB growth in GB month over month.

Best regards, 
David B. Wagoner 
Database Administrator 



Re: Capacity Planning Methods?

2003-08-14 Thread Gaja Krishna Vaidyanatha
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 wanted to mention this,
just in case you have not seen it. If you do a Google
search on the keyword "Ratio Modeling Technique", you
should get it.

Cheers,

Gaja
--- [EMAIL PROTECTED] wrote:
> 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 future
> usage at the end of the year, middle of next year,
> and end of next year.
> 
> LR is also used to predict the current usage based
> on past space.  The
> difference between the actual and the prediction is
> used to adjust future
> predictions.
> 
> It ain't perfect, but it's fairly accurate.
> 
> Jared
> 
> 
> 
> 
> 
> David Wagoner <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  08/11/2003 02:24 PM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:Capacity Planning Methods?
> 
> 
> How do you guys collect capacity planning metrics,
> such as DB size? 
> Do you use StatsPack, Oracle OEM, others?  I'm
> interested in an efficient 
> method to track DB growth in GB month over month.
> 
> Best regards, 
> David B. Wagoner 
> Database Administrator 
> 
> 


=


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Capacity Planning Methods?

2003-08-14 Thread Goulet, Dick
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 Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Tuesday, August 12, 2003 10: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't update those old scripts with newer versions of
Oracle they really look old and convoluted.


Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


-Original Message-
Sent: Monday, August 11, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L


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 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Capacity Planning Methods?

2003-08-12 Thread Jesse, Rich
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   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA

--


CREATE TABLE TS_ACTIVITY
(
  TABLESPACE_NAME  VARCHAR2(30),
  FREE_SPACE   NUMBER,
  USED_SPACE   NUMBER,
  MAX_FREE_SPACE   NUMBER,
  TIMESTAMPDATE
)
TABLESPACE USERS
/

COMMENT ON TABLE TS_ACTIVITY IS 'Tablespace Activity: Records changes in
physical attributes of all permanent, dictionary-managed tablespaces.'
/

CREATE INDEX TS_ACTIVITY_TS_NAME ON TS_ACTIVITY
(TABLESPACE_NAME)
TABLESPACE USERS
/


CREATE OR REPLACE PROCEDURE TS_CHECK IS
--
-- Explicit SELECT access must be granted to this schema on the following
SYS views:
--
--  DBA_TABLESPACES
--  DBA_DATA_FILES
--  DBA_FREE_SPACE
--
-- Modification History
-- -
-- 12/19/2001   REJ Created.

v_tablespace_name   ts_activity.tablespace_name%TYPE;
v_free_spacets_activity.free_space%TYPE;
v_used_spacets_activity.used_space%TYPE;
v_max_free_spacets_activity.max_free_space%TYPE;
v_rowcount  NUMBER;

CURSOR C_TS IS
SELECT d.tablespace_name, f.bytes "FREE_SPACE",
NVL(a.bytes - NVL(f.bytes, 0), 0) "USED_SPACE",
f.max_free_space
FROM sys.dba_tablespaces d,
(SELECT tablespace_name, SUM(bytes) bytes
FROM dba_data_files
GROUP BY tablespace_name) a,
(SELECT tablespace_name, SUM(bytes) bytes, MAX(bytes)
max_free_space
FROM dba_free_space
GROUP BY tablespace_name) f
WHERE d.tablespace_name = a.tablespace_name(+) AND
d.tablespace_name = f.tablespace_name(+)
AND d.contents = 'PERMANENT';

BEGIN

FOR tsrec IN C_TS LOOP

SELECT COUNT(*)
INTO v_rowcount
FROM ts_activity
WHERE tablespace_name = tsrec.tablespace_name;

IF v_rowcount > 0 THEN
SELECT q.tablespace_name, q.free_space, q.used_space,
q.max_free_space
INTO v_tablespace_name, v_free_space, v_used_space,
v_max_free_space
FROM
ts_activity q,
(SELECT MAX(timestamp) timestamp
FROM ts_activity
WHERE tablespace_name = tsrec.tablespace_name) ts
WHERE q.tablespace_name = tsrec.tablespace_name
AND q.timestamp = ts.timestamp;
END IF;

IF tsrec.free_space != v_free_space
OR tsrec.used_space != v_used_space
OR tsrec.max_free_space != v_max_free_space
OR v_rowcount = 0 THEN
INSERT INTO ts_activity
(tablespace_name, free_space, used_space,
max_free_space, timestamp)
VALUES (tsrec.tablespace_name, tsrec.free_space,
tsrec.used_space, tsrec.max_free_space, SYSDATE);
END IF;
END LOOP;

END TS_CHECK;
/


-Original Message-
Sent: Monday, August 11, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L


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 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Capacity Planning Methods?

2003-08-11 Thread Jesse, Rich
I also grab freespace from dba_free_space, dump it into a table, and watch
the deltas there, too.  It helps for watching less predictable object
growth, like perhaps with an index.  Although my procedure is
tablespace-oriented, so it won't give detail as to exactly what's doing all
the growing.

If you'd like, I could post the smallish 68-line procedure and the table
create that I use to do this.  There are perhaps better ways of doin g this,
but it works for me in 8.1.7 on dictionary managed tablespaces.


Rich

Rich Jesse   System/Database Administrator
[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?
> 
> 
> 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), date,
> num_rows, chained_rows, blocks. Whatever suits your purposes. 
> Then I can go
> back and see the pattern of growth over time. 
> 
> 
> 
> Dennis Williams 
> DBA, 80%OCP, 100% DBA 
> Lifetouch, Inc. 
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Monday, August 11, 2003 4:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> How do you guys collect capacity planning metrics, such as DB size? 
> 
> Do you use StatsPack, Oracle OEM, others?  I'm interested in 
> an efficient
> method to track DB growth in GB month over month.
> 
> 
> Best regards, 
> 
> David B. Wagoner 
> Database Administrator 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).