geez, back to the very very first presentation Marlene Theriault and I
did together, about version 6, called "All the Things THEY Didn't Tell
You"
you mean I hafta update it AGAIN?????????
:)
- "Orr, Steve" <[EMAIL PROTECTED]> wrote:
> And thanks for the note recommendation Dennis...
>
> There's too many of these bullets flying around. Need a short list
> called: "Things you should know that Oracle doesn't tell you straight
> out."
>
> Of course there's the bug list but who has time for that and can
> remember it all? Sigh...
>
>
> Steve
>
>
> -----Original Message-----
> Sent: Wednesday, June 04, 2003 4:40 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Steve
> Personally I am VERY glad you mentioned this today. Since I run
> 64-bit
> Unix, I didn't think this applied to me, but after reading the note,
> I ran
> their formula and found a file on one of my databases that was very
> close to
> the limit. Plenty happy to dodge that bullet.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -----Original Message-----
> Sent: Wednesday, June 04, 2003 4:15 PM
> To: Multiple recipients of list ORACLE-L
>
>
> We are on 8.1.7.4 and it aflicted us anyway. Maybe I'll just wait a
> couple
> of years and let other customers QA this Oracle feature until they
> get it
> right.
>
>
> Steve
>
>
> -----Original Message-----
> Sent: Wednesday, June 04, 2003 2:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Ahem . . . according to Note 112011.1, "these problems can affect all
> platforms except OS/390 which does NOT support datafile resizing"
> (fiendishly clever those mainframe types).
> It looks like 8.1.7.4 and above is not affected. I would highly
> recommend
> that all Oracle DBAs take a look at this note.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -----Original Message-----
> Sent: Wednesday, June 04, 2003 3:00 PM
> To: Multiple recipients of list ORACLE-L
>
>
> It doesn't seem to be a problem on other platforms... Just when I
> stopped
> feeling like a neglected step child for running on Linux. Don't
> worry... Be
> happy... There's a workaround... Upgrade and buy more software...
>
> D'ai jobu desu... er, eh, Ca ne fais rien.
>
>
> -----Original Message-----
> Sent: Wednesday, June 04, 2003 12:46 PM
> To: Multiple recipients of list ORACLE-L
>
>
> This almost sounds like the problem that existed for Oracle 7.3 and
> the 2G
> threshold a couple of years ago...
>
> J'ai une impression d'avoir déjà vu ceci.
>
> : )
>
> Patrice.
>
> -----Original Message-----
> Sent: Wednesday, June 04, 2003 3:10 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Steve - are you saying that there is a workaround by increasing the
> size of
> the file manually to something larger than 4G?
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> Sent: Wednesday, June 04, 2003 1:25 PM
> To: Multiple recipients of list ORACLE-L
>
>
> See my note: "There is no such O/S file size limit."
>
> We have datafiles > 2GB which work just fine. The problem is with
> autoextending datafiles that extend from <2GB to >2GB. It's not a
> Linux
> limitation but a limitation imposed by Oracle's implementation on
> Linux.
> Oracle 9i on Linux doesn't have this problem. And my peeve is that it
> took
> OWS 4 days to "discover" this "limit."
>
>
> Still peeved, :-)
> Steve
>
>
>
> -----Original Message-----
> Sent: Wednesday, June 04, 2003 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I think it is the limitation of Linux, not Oracle.
> Use LVM and don't worry about file size limit. :-)
>
> JP
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 04, 2003 5:40 PM
>
>
> > I've just been informed that there is a 2GB datafile size limit
> with
> Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had
> files
> in excess of this for some time and they work just fine. The problem
> occurs
> when the autoextend "feature" reaches the 2GB threshhold. Of course,
> Oracle
> didn't tell me this until after about 4 days of back and forth
> testing for
> them. (There is no such O/S file size limit.) I've reviewed the Linux
> release notes, the Linux install guide, the Linux admin guide and the
> contents of $ORACLE_HOME/relnotes and I don't find any such
> limitation in
> the documentation. Did I miss it? Can anyone find any such published
> limitation in the docs? Is this a secret?
> >
> >
> > Peeved at Oracle... AGAIN,
> > Steve Orr
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Orr, Steve
> > 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: Jan Pruner
> 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
> --
>
=== message truncated ===
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
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).
Received on Thu Jun 05 2003 - 13:05:17 CDT
