I can't with the account they have given me. At least, not yet :(
this is so well planned I will be amazed if it goes live on time. and I
(and my boss) are living by two mottos "failure to plan on your part
does not constitute an emergency on mine" and "if it fails, it will NOT
be because of anything the DB group did or failed to do"
- "Gogala, Mladen" <MGogala_at_oxhp.com> wrote:
> 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).
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).
Received on Wed Sep 25 2002 - 22:43:20 CDT
