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: Data Warehouse on Windows -more

RE: Data Warehouse on Windows -more

From: Bishop Lewis <Lewis.Bishop_at_woolwich.co.uk>
Date: Tue, 20 Aug 2002 01:09:24 -0800
Message-ID: <F001.004B9A23.20020820010924@fatcity.com>


Adar,

>From what I understand and have seen it's not just at 4GB - it's EVERY 4GB.
So for example if your database extends from 3.8GB - 4.2GB it fail just as it will extending from 7.8GB-8.2GB or 11.8GB - 12.2GB (for example).

It certainly DOESN'T mean that you can't use files larger than 4GB!

Lewis Bishop

---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - lewis.bishop_at_woolwich.co.uk


-----Original Message-----
Sent: 19 August 2002 19:19
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
----------------------------------------------------------------------

Hello Aleem

This is not a boundary. It is a problem if you use autoextend and the file
grows from less then 4Gb to more then 4GB.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Monday, August 19, 2002 1:48 PM



> Where can I find the more information on this boundary? Is there any such
> limit for Oracle/Linux?
> TIA!
>
> Aleem
>
> -----Original Message-----
> Sent: Thursday, August 15, 2002 7:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Data Warehouse on Windows
>
> Don't forget the Oracle/Windows 4GB boundary corruption problem!
>
> Lewis Bishop
> ---
> Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
> Phone - 020 8298 3418
> Mobile - 07950 380857
> Email - lewis.bishop_at_woolwich.co.uk
>
>
> -----Original Message-----
> Sent: 15 August 2002 14:58
> To: Multiple recipients of list ORACLE-L
>
> This header confirms that this email message has been swept for the
> presence of computer viruses.
>
> Corporate IT
> THE WOOLWICH
> ----------------------------------------------------------------------
>
> Hi,
> I was asked to give some hint for the hardware for a data warheouse
running
> on Win 2k and holding about 20-40 GB data.
> Project will have about 40 small and 7-8 large tables. Users <20.
Probably
> long running queries.
> Which hardware would you use? How many processors? Which disks?
> The os-system is set and cannot be Unix/Linux according to management
> decision.
> Any tips/recommendations appreciated
> Antje Sackwitz
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sackwitz, Antje
> INET: Antje.Sackwitz_at_ppi.de
>
> 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: 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).
>
>
> The information, attachments and opinions contained in this message are
> those of its author only and do not necessarily represent those of The
> Woolwich and or any other members of the Barclays Group and are intended
> solely for the use of the individual or entity to whom they are addressed.
> The sender may not be authorised to give financial advice, and nothing in
> this message should be construed as offering such advice.
>
> The message may contain privileged and confidential information and you
may
> not copy, distribute or take any action in reliance on it. If you have
> received this email in error please notify the Information Security
Manager
> at ADMINISTRATOR_at_WOOLWICH.CO.UK
>
> Replies to this email may be monitored for operational or business
reasons.
>
> Woolwich plc. Registered in England Number : 3295699.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bishop Lewis
> INET: Lewis.Bishop_at_woolwich.co.uk
>
> 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: 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: Abdul Aleem
> INET: dmit_at_beaconhouse.edu.pk
>
> 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: 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: Yechiel Adar INET: adar76_at_inter.net.il 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: 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). The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at ADMINISTRATOR_at_WOOLWICH.CO.UK Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: Lewis.Bishop_at_woolwich.co.uk 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: 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 Tue Aug 20 2002 - 04:09:24 CDT

Original text of this message

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