Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: datafile sizing question

RE: datafile sizing question

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Wed, 25 Sep 2002 12:48:30 -0800
Message-ID: <F001.004D94EA.20020925124830@fatcity.com>


Rachel, if you can execute sqlplus, you can do the "nm" thing. You don't need to log in as "oracle".

> -----Original Message-----
> From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com]
> Sent: Wednesday, September 25, 2002 3:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: datafile sizing question
>
>
> I'm betting that it's not 64-bit Oracle. See, I am the
> development DBA.
> As an employee, I get to create the scripts, but I don't get to run
> them or even get access as "oracle" to the servers.
>
> In other words, all the grunt work, all the responsibility
> for problems
> (production is managed by a hosting company) but none of the power to
> make sure it's right.
>
> I love my job. Why?
>
> Rachel
>
> --- "Gogala, Mladen" <MGogala_at_oxhp.com> wrote:
> > I know that wuth 64 bit HP-UX and 64 bit Oracle RDBMS,
> > I have no problems with 1 8GB file. I don't know much
> > about Solaris, but I suppose the following will work:
> >
> > nm $ORACLE_HOME/lib/libclntsh.so|grep lseek64
> >
> > Results should be nonempty and look something like
> > this:
> > __lseek64 | |undef |code |
> > __lseek64 | 6589540|uext |stub |
> > __lseek64 | 7173576|uext |stub |
> >
> >
> > That meens that lseek64 is used, as an external symbol, from
> > the OS libraries. That, in turn, means that your oracle is using
> > 64 bit routines and is, therefore, 64 bit itself and can handle
> > large files.
> >
> > > -----Original Message-----
> > > From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com]
> > > Sent: Wednesday, September 25, 2002 12:33 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: datafile sizing question
> > >
> > >
> > > Okay, I'm about to create some locally managed
> tablespaces for some
> > > large partitioned tables. I plan on making each datafile 2GB, with
> > an
> > > extent of 20M.
> > >
> > > What I've done other times when I use LMTs is add 64K to the
> > > file size,
> > > for the bitmap header, so that I don't waste most of an
> extent. But
> > in
> > > those cases, the datafile size has been less than 2GB.
> > >
> > > We will be on Solaris 2.8, I know that the OS can handle files
> > larger
> > > than 2GB but it makes me nervous to do this.
> > >
> > > I hate to waste most of 20M just for the bitmap header.
> > >
> > > Is my thinking way off? If you've been doing this sort of sizing
> > (it's
> > > a data warehouse, yes), what have you done?
> > >
> > > thanks!
> > >
> > > Rachel
> > >
> > >
> > > __________________________________________________
> > > Do you Yahoo!?
> > > New DSL Internet Access from SBC & Yahoo!
> > > http://sbc.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Rachel Carmichael
> > > INET: wisernet100_at_yahoo.com
> > >
> > > 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: ListGuru_at_fatcity.com (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.com
> > --
> > Author: Gogala, Mladen
> > INET: MGogala_at_oxhp.com
> >
> > 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: ListGuru_at_fatcity.com (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).
>
>
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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.com
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.com

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: ListGuru_at_fatcity.com (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).
Received on Wed Sep 25 2002 - 15:48:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US