Re: working with datafile 2Gb in HadHat 7.3
This is a multi-part message in MIME format. --=002_Dragon033825381083_= Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: quoted-printable Adriano Freire=A3=AC=C4=FA=BA=C3=A3=A1 =A1=A1=A1=A1This is the limit of oracle8i in linux.Redhat support 2GB= file in kernel 2.4+, but oracle8i does not support it. Oracle 9i in linux can handle large files.I have a database= using one big 20G raw partition in production. =3D=3D=3D=3D=3D=3D=3D=3D 2002-08-29 06:53:00 =C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using= datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2 =C0=F1=A3=A1 =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1zhu chao [EMAIL PROTECTED] =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-09-02 --=002_Dragon033825381083_= Content-Type: text/html; charset=GB2312 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=3Dtext/html; charset=3Dgb2312= http-equiv=3DContent-Type META content=3DMSHTML 5.00.3315.2870 name=3DGENERATOR/HEAD BODY bgColor=3D#eaeaeaFONT size=3D2FONT face=3D=CB=CE=CC=E5Adriano= Freire=A3=AC=C4=FA=BA=C3=A3=A1/FONT /FONT DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1This is the limit of oracle8i in= linux.Redhat support gt;2GB file in kernel 2.4+, but oracle8i does not= support it./FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2nbsp;nbsp;nbsp; Oracle 9i in linux= can handle large files.I have a database using one big 20G raw partition in production./FONT/DIV DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=3D=3D=3D=3D=3D=3D=3D=3D= 2002-08-29nbsp;06:53:00nbsp;=C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2 TABLE width=3D100% TBODY TR TD width=3D100% BLOCKQUOTE style=3DBORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px;= MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px DIVFONT face=3DArial size=3D2Gurus,/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2I've some problems with= datafiles gt; 2Gb in HadHat 7.3. I'm using datafile type ext3 and= /FONT/DIV DIVFONT face=3DArial size=3D2when i try create a datafile= with 2Gb the database is catching./FONT/DIV DIVFONT face=3DArial size=3D2Anybody have the some= problem?/FONT/DIV DIVFONT face=3DArial size=3D2any= suggestion?/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial = size=3D2Adriano./FONT/DIV/BLOCKQUOTE/TD/TR/TBODY/TAB= LE/FONT/DIV DIV PFONT face=3D=CB=CE=CC=E5 size=3D2=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D= =3D =3D /FONT/P PFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2BR=C0=F1=A3=A1/FONT/P DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1zhu= chao/FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2FONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1/FONTA href=3Dmailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/A/FONT/DIV DIVFONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-09-02/FONT/DIV= DIVnbsp;/DIV/DIV/BODY/HTML --=002_Dragon033825381083_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zhu chao 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).
RE: working with datafile 2Gb in HadHat 7.3
I read something about Oracle on Windows not being able to extend past the 2G limit, but haven't verified. I believe it has to do with Oracle on Windows, not windows or hardware. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 29, 2002 5:34 PM To: Multiple recipients of list ORACLE-L Subject:RE: working with datafile 2Gb in HadHat 7.3 Ltiu, Intel hardware can only handle 2Gb files sizes max. Are you sure? I don't think that's true. -Original Message- Sent: Thursday, August 29, 2002 2:44 PM To: Multiple recipients of list ORACLE-L It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: ltiu 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: Seefelt, Beth 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: Boivin, Patrice J 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).
RE: working with datafile 2Gb in HadHat 7.3
It was a bug on windows - with auto extend on and crossing 4Gb filesize. -Original Message- Sent: Friday, August 30, 2002 6:58 AM To: Multiple recipients of list ORACLE-L I read something about Oracle on Windows not being able to extend past the 2G limit, but haven't verified. I believe it has to do with Oracle on Windows, not windows or hardware. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 29, 2002 5:34 PM To: Multiple recipients of list ORACLE-L Subject:RE: working with datafile 2Gb in HadHat 7.3 Ltiu, Intel hardware can only handle 2Gb files sizes max. Are you sure? I don't think that's true. -Original Message- Sent: Thursday, August 29, 2002 2:44 PM To: Multiple recipients of list ORACLE-L It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: ltiu 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: Seefelt, Beth 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: Boivin, Patrice J 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: Shaw John-P55297 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
RE: working with datafile 2Gb in HadHat 7.3
Nope. -Original Message- Sent: Thursday, August 29, 2002 7:47 PM To: Multiple recipients of list ORACLE-L If you can't do it in hardware, do it in software. Right? ltiu Ji, Richard wrote: There is no such hardware limitation like that. Those are the OS i.e. software limitations. For instance, the 2gb file size limit is because of the 32 bit OS, actually, to be more specific, it's the 32 bit file system. You can have a 32bit OS kernel, but if your file system supports 64bit, then you can support 2gb files. Same thing for the memory. Richard Ji -Original Message- Sent: Thursday, August 29, 2002 5:59 PM To: Multiple recipients of list ORACLE-L OK. I stand corrected. You do need third party tools though. But I suppose engineers can always hack their way through hardware limitations to make thing work. Like the 4GB memory limit of intels - this is not more since I believe Windows 2K and XP have this feature(in software?) where it can access greater than 4GB memory.. Philip Douglass wrote: Uh... don't think so! -- we're running UnixWare 7 on Intel hardware (Xeons) and large file support is a matter of enabling the largefiles option on the Veritas (VxFS) filesystem. That being said, I only use 2Gig datafiles because it seems foolhardy to me to use 2Gig datafiles unless you have an obvious need for them. And if you do, then test it a lot! And make sure all of your programs support large files too (some versions of tar/cpio/gzip don't) -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 2:43 PM It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: ltiu 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: ltiu 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: Ji, Richard 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]
Re: working with datafile 2Gb in HadHat 7.3
What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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).
Re: working with datafile 2Gb in HadHat 7.3
Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: Adriano Freire 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).
Re: working with datafile 2Gb in HadHat 7.3
It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: ltiu 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).
Re: working with datafile 2Gb in HadHat 7.3
Uh... don't think so! -- we're running UnixWare 7 on Intel hardware (Xeons) and large file support is a matter of enabling the largefiles option on the Veritas (VxFS) filesystem. That being said, I only use 2Gig datafiles because it seems foolhardy to me to use 2Gig datafiles unless you have an obvious need for them. And if you do, then test it a lot! And make sure all of your programs support large files too (some versions of tar/cpio/gzip don't) -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 2:43 PM It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: ltiu 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: Philip Douglass 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).
RE: working with datafile 2Gb in HadHat 7.3
Ltiu, Intel hardware can only handle 2Gb files sizes max. Are you sure? I don't think that's true. -Original Message- Sent: Thursday, August 29, 2002 2:44 PM To: Multiple recipients of list ORACLE-L It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: ltiu 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: Seefelt, Beth 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).
Re: working with datafile 2Gb in HadHat 7.3
My question is only this: Linux 7.3 REDHAT with ext3 work with datafiles or = 2Gb? If is true. How? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 3:43 PM It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: ltiu 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: Adriano Freire 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).
Re: working with datafile 2Gb in HadHat 7.3
No. Not really. I stand corrected. Got confused again. ltiu Seefelt, Beth wrote: Ltiu, Intel hardware can only handle 2Gb files sizes max. Are you sure? I don't think that's true. -Original Message- Sent: Thursday, August 29, 2002 2:44 PM To: Multiple recipients of list ORACLE-L It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: ltiu 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).
Re: working with datafile 2Gb in HadHat 7.3
Plain ext3 = No. Adriano Freire wrote: My question is only this: Linux 7.3 REDHAT with ext3 work with datafiles or = 2Gb? If is true. How? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 3:43 PM It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: ltiu 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: ltiu 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).
Re: working with datafile 2Gb in HadHat 7.3
OK. I stand corrected. You do need third party tools though. But I suppose engineers can always hack their way through hardware limitations to make thing work. Like the 4GB memory limit of intels - this is not more since I believe Windows 2K and XP have this feature(in software?) where it can access greater than 4GB memory.. Philip Douglass wrote: Uh... don't think so! -- we're running UnixWare 7 on Intel hardware (Xeons) and large file support is a matter of enabling the largefiles option on the Veritas (VxFS) filesystem. That being said, I only use 2Gig datafiles because it seems foolhardy to me to use 2Gig datafiles unless you have an obvious need for them. And if you do, then test it a lot! And make sure all of your programs support large files too (some versions of tar/cpio/gzip don't) -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 2:43 PM It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: ltiu 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: ltiu 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).
RE: working with datafile 2Gb in HadHat 7.3
From the link: http://www.in.redhat.com/products/linux/enterprise_oracle.php3 Only in the enterprise edition: 64-bit file I/O - allows access to files greater than 2GB in size for large database implementations Regards, Waleed -Original Message- Sent: Thursday, August 29, 2002 4:44 PM To: Multiple recipients of list ORACLE-L My question is only this: Linux 7.3 REDHAT with ext3 work with datafiles or = 2Gb? If is true. How? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 3:43 PM It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: ltiu 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: Adriano Freire 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: Khedr, Waleed 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).
RE: working with datafile 2Gb in HadHat 7.3
There is no such hardware limitation like that. Those are the OS i.e. software limitations. For instance, the 2gb file size limit is because of the 32 bit OS, actually, to be more specific, it's the 32 bit file system. You can have a 32bit OS kernel, but if your file system supports 64bit, then you can support 2gb files. Same thing for the memory. Richard Ji -Original Message- Sent: Thursday, August 29, 2002 5:59 PM To: Multiple recipients of list ORACLE-L OK. I stand corrected. You do need third party tools though. But I suppose engineers can always hack their way through hardware limitations to make thing work. Like the 4GB memory limit of intels - this is not more since I believe Windows 2K and XP have this feature(in software?) where it can access greater than 4GB memory.. Philip Douglass wrote: Uh... don't think so! -- we're running UnixWare 7 on Intel hardware (Xeons) and large file support is a matter of enabling the largefiles option on the Veritas (VxFS) filesystem. That being said, I only use 2Gig datafiles because it seems foolhardy to me to use 2Gig datafiles unless you have an obvious need for them. And if you do, then test it a lot! And make sure all of your programs support large files too (some versions of tar/cpio/gzip don't) -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 2:43 PM It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: ltiu 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: ltiu 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: Ji, Richard 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).
Re: working with datafile 2Gb in HadHat 7.3
If you can't do it in hardware, do it in software. Right? ltiu Ji, Richard wrote: There is no such hardware limitation like that. Those are the OS i.e. software limitations. For instance, the 2gb file size limit is because of the 32 bit OS, actually, to be more specific, it's the 32 bit file system. You can have a 32bit OS kernel, but if your file system supports 64bit, then you can support 2gb files. Same thing for the memory. Richard Ji -Original Message- Sent: Thursday, August 29, 2002 5:59 PM To: Multiple recipients of list ORACLE-L OK. I stand corrected. You do need third party tools though. But I suppose engineers can always hack their way through hardware limitations to make thing work. Like the 4GB memory limit of intels - this is not more since I believe Windows 2K and XP have this feature(in software?) where it can access greater than 4GB memory.. Philip Douglass wrote: Uh... don't think so! -- we're running UnixWare 7 on Intel hardware (Xeons) and large file support is a matter of enabling the largefiles option on the Veritas (VxFS) filesystem. That being said, I only use 2Gig datafiles because it seems foolhardy to me to use 2Gig datafiles unless you have an obvious need for them. And if you do, then test it a lot! And make sure all of your programs support large files too (some versions of tar/cpio/gzip don't) -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 2:43 PM It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: ltiu 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: ltiu 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).
