ALso, what does "1GB" actually mean? That much data, if you dumped it
all out into a CSV file? A 1GB tablespace to hold all the data (and how
is that tablespace organized)? 1GB being the sum of the sizes of all the
datafiles? So, even if there were such a saying, it would be
meaningless.
What I like to do, and perhaps this is just me, is to have all the
datafiles within a tablespace the same size. So, if I calculated that I
needed a 2G tablespace, I might create 4 500M datafiles, and when I
needed more I would add more 500M datafiles. I just think this makes
things easier to manage, from a physical storage perspective. And
contrary to the letter (rather than the spirit) of OFA, I name
datafiles:
/<mount point>/<sid>_<tablespace>_<number>.dbf
Anyone else do something like this?
guy
-----Original Message-----
Sent: Thursday, July 05, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L
Perhaps it is confusion with filesize and then it is a whole different
ball
game and not only for NT but some older unixes and other OS's as well.
and
then we can start the arguments for using raw or not using raw for files
under unix.
Peter
At 10:45 PM 5/07/2001, you wrote:
>Antje
>
>"I know there was a saying - put no database larger than 1 GB on a NT
>machine."
>
>The above is nonsense. I have a database that is 200G on NT. I know
of no
>limit regarding database size on NT.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-----Original Message-----
>Sent: Thursday, July 05, 2001 7:02 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi,
>
>Regarding the issue of databases larger than 1GB on NT, could someone
please
>explain this to me, as I was not aware of this 'saying'.
>
>Thanks in advance,
>
>Steven H.
>
>-----Original Message-----
>Antje
>Sent: 05 July 2001 10:51
>To: Multiple recipients of list ORACLE-L
>
>
>Hi,
>I' hav to build up foolowing matrix
>
> DB Size <..
>Operating system
>NT
>Sun Solaris
>AIX
>...
>Has anyone a similar matrix to share?
>Especially I'm interested in the size for NT.
>I know there was a saying - put no database larger than 1 GB on a NT
>machine.
>Is this still true with 8.1.7 or is it stable with larger databases
also?
>
>Regards,
>Antje
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steven Hovington
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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.com
>--
>Author: Mercadante, Thomas F
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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.com
--
Author: Peter McLarty
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
--
Author: Guy Hammond
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
