RE: RE: LMT ASSM & next extent

  • From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 11 Feb 2004 08:48:37 -0600

CREATE TABLE tmp_quickie
        (mycol VARCHAR2(12))
        STORAGE (INITIAL 10240 M);

Whoops, that was supposed to be "K" not "M".  Oh well, I'll just delete the
table and redo it -- no harm done.

Been there, done that.

Rich


Rich Jesse                        System/Database Administrator
rich.jesse@xxxxxxxxxxxxxxxxx      QuadTech, Sussex, WI USA


-----Original Message-----
From: ryan.gaffuri@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx]
Sent: Wednesday, February 11, 2004 8:25 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: RE: LMT ASSM & next extent


i poll for the size of the file and the total bytes of the segments in each
file. I keep repository of past sizes of the data files(its just a table).
if it extends i get an email. I work from there. 

I find it to be one less thing to have to worry about. Is this approach
flawed? 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: