| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Large File Support
--=_ORCL_5857295_0r0
Content-Type:text/plain; charset="iso-8859-1"
Content-Transfer-Encoding:quoted-printable
That is a feature of fatcity mailing list. Those who are members of ODTUG will be familiar with this. You also cannot just do a reply and get that person only. All replys go to the list.
kimberly.smith_at_eds.com
--=_ORCL_5857295_0r0
content-type:message/rfc822
Date: 26 Apr 2000 11:03:14
From:Chuck Hamilton <chuck_hamilton_at_yahoo.com>
To:Multiple recipients of list ORACLE-L <ORACLE-L>
Subject:Re: Large File Support
Reply-to:UNIX.IOGMD:ORACLE-L_at_fatcity.com
Return-Path:root_at_fatcity.cts.com
Received:from gmd.fujitsu.com (ducks.gmd.fujitsu.com [198.6.119.2]) by hdoc02.gmd.fujitsu.com with SMTP (8.7.1/8.7.1) id LAA03425 for <ksmith1.ofcmail_at_hdbi01>; Wed, 26 Apr 2000 11:43:32 -0700 (PDT) Received:from dfwl01.gmd.fujitsu.com by gmd.fujitsu.com (SMI-8.6/) id LAA12794; Wed, 26 Apr 2000 11:43:26 -0700 Received:from dfwl01.gmd.fujitsu.com (root_at_localhost) by dfwl01.gmd.fujitsu.com with ESMTP id LAA07051 for <ksmith1_at_gmd.fujitsu.com>; Wed, 26 Apr 2000 11:43:26 -0700 (PDT) Received:from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199]) by dfwl01.gmd.fujitsu.com with ESMTP id LAA07035 for <ksmith1_at_gmd.fujitsu.com>; Wed, 26 Apr 2000 11:43:21 -0700 (PDT) Received:from fatcity.UUCP (uucp_at_localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id LAA06527; Wed, 26 Apr 2000 11:42:56 -0700 (PDT) Received:by fatcity.com (02-Mar-2000/v1.0f-b68/bab) via UUCP id 001517D3; Wed, 26 Apr 2000 10:03:14 -0800Message-ID:<F001.001517D3.20000426100314_at_fatcity.com> X-Comment:Oracle RDBMS Community Forum
boundary="=_ORCL_5856273_0r2.0"
--=_ORCL_5856273_0r2.0
Content-Type:text/plain; charset=us-ascii
Content-Transfer-Encoding:7bit
Just a guess, but reducing # of datafiles could speed up checkpoints. You'd have less datafile headers to update.
BTW how come when I reply-all to the new list, it doesn't CC the original poster? It just doubles up on oracle-l_at_fatcity.com? I had to manuall add you to the CC of this message.
Jared Still <jkstill_at_bcbso.com> wrote:
What is the reason for reducing the number of tablespaces and datafiles?
Jared
On Tue, 25 Apr 2000, Madhavan Amruthur wrote:
> Hi,
> We did a proof of concept (but on 8.0.5) with about 4.3TB of data hosted
in
> about 600 tablespaces and 900 datafiles each of 5G. We had good
performance
> and also we had different RAID set up for different types of data.
> Please let me know if you need more information
> Hope this helsp.
> Regards,
>
> Madhavan
> IBM Corporation Webserver Div
>
>
> >From: powerbar1_at_hotmail.com
> >Reply-To: powerbar1_at_hotmail.com
> >To: "oracle list"
> >Subject: Large File Support
> >Date: Tue, 25 Apr 2000 14:09:18 -0700
> >
> >Has anyone done any benchmarking with large files (> 2gb) on Oracle 7.3.4?
> >We currently have Oracle Apps 10.7 (Financials)running on 7.3.4. There are
> >88 tablespace and 90 datafiles that make up the database. One of the plans
> >on the table is to reduce the tablespaces and datafiles to a smaller
> >number. Of course this will happen by way of consolidating multiple
> >tablespaces into one and having larger datafiles.
> >
> >I am not so certain about the performance aspect though. Since this is a
> >large undertaking, I would like to hear from folks out there who have done
> >something along these lines and are willing to share their experiences.
> >
> >Sincerely,
> >
> >Vik.
> >
> >---
> >You are currently subscribed to oracle as: mad012000_at_hotmail.com
> >To unsubscribe send a blank email to leave-oracle-114301Q_at_telelists.com
> >or visit the Oracle mailing list on the Web at:
> >http://www.telelists.com/cgi-bin/lyris.pl?enter=oracle
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>
> ---
> You are currently subscribed to oracle as: jkstill_at_bcbso.com
> To unsubscribe send a blank email to leave-oracle-20875Y_at_telelists.com
> or visit the Oracle mailing list on the Web at:
> http://www.telelists.com/cgi-bin/lyris.pl?enter=oracle
>
Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-)
Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address
jkstill_at_teleport.com - private
-- Author: Jared Still INET: jkstill_at_bcbso.com 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). --------------------------------- Do You Yahoo!? Send online invitations with Yahoo! Invites. --=_ORCL_5856273_0r2.0 Content-Type:text/html; charset=us-ascii Content-Transfer-Encoding:7bit <P>Just a guess, but reducing # of datafiles could speed up checkpoints. You'd have less datafile headers to update.</P> <P>BTW how come when I reply-all to the new list, it doesn't CC the original poster? It just doubles up on <A href="mailto:oracle-l_at_fatcity.com">oracle-l_at_fatcity.com</A>? I had to manuall add you to the CC of this message.</P> <P><B><I>Jared Still <jkstill_at_bcbso.com></B></I> wrote:<BR> <BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><BR>What is the reason for reducing the number of tablespaces<BR>and datafiles?<BR><BR>Jared<BR><BR>On Tue, 25 Apr 2000, Madhavan Amruthur wrote:<BR><BR>> Hi,<BR>> We did a proof of concept (but on 8.0.5) with about 4.3TB of data hosted in <BR>> about 600 tablespaces and 900 datafiles each of 5G. We had good performance <BR>> and also we had different RAID set up for different types of data.<BR>> Please let me know if you need more information<BR>> Hope this helsp.<BR>> Regards,<BR>> <BR>> Madhavan<BR>> IBM Corporation Webserver Div<BR>> <BR>> <BR>> >From: powerbar1_at_hotmail.com<BR>> >Reply-To: powerbar1_at_hotmail.com<BR>> >To: "oracle list" <ORACLE_at_TELELISTS.COM><BR>> >Subject: Large File Support<BR>> >Date: Tue, 25 Apr 2000 14:09:18 -0700<BR>> ><BR>> >Has anyone done any benchmarking with large files (> 2gb) on ! ! ! ! ! Oracle 7.3.4?<BR>> >We currently have Oracle Apps 10.7 (Financials)running on 7.3.4. There are<BR>> >88 tablespace and 90 datafiles that make up the database. One of the plans<BR>> >on the table is to reduce the tablespaces and datafiles to a smaller<BR>> >number. Of course this will happen by way of consolidating multiple<BR>> >tablespaces into one and having larger datafiles.<BR>> ><BR>> >I am not so certain about the performance aspect though. Since this is a<BR>> >large undertaking, I would like to hear from folks out there who have done<BR>> >something along these lines and are willing to share their experiences.<BR>> ><BR>> >Sincerely,<BR>> ><BR>> >Vik.<BR>> ><BR>> >---<BR>> >You are currently subscribed to oracle as: mad012000_at_hotmail.com<BR>> >To unsubscribe send a blank email to leave-oracle-114301Q_at_telelists.com<BR>> >or visit the Oracle mailing list on the Web! ! ! ! ! at:<BR>> >http://www.telelists.com/cgi-bin/lyris.pl?enter=oracle<BR>> <BR>> ________________________________________________________________________<BR>> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com<BR>> <BR>> <BR>> ---<BR>> You are currently subscribed to oracle as: jkstill@bcbso.com<BR>> To unsubscribe send a blank email to leave-oracle-20875Y@telelists.com<BR>> or visit the Oracle mailing list on the Web at:<BR>> http://www.telelists.com/cgi-bin/lyris.pl?enter=oracle<BR>> <BR><BR><BR>Jared Still<BR>Certified Oracle DBA and Part Time Perl Evangelist ;-)<BR>Regence BlueCross BlueShield of Oregon<BR>jkstill@bcbso.com - Work - preferred address<BR>jkstill@teleport.com - private<BR><BR><BR>-- <BR>Author: Jared Still<BR>INET: jkstill@bcbso.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>-------------------------------! ! ! ! ! -------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br> Send online invitations with Yahoo! Invites. --=_ORCL_5856273_0r2.0-- --=_ORCL_5857295_0r0-- ------------------------------ From: "Oak, Sameer" <Sameer.Oak_at_CWUSA.COM> Date: Wed, 26 Apr 2000 15:50:15 -0400 Subject: Re: Add more index or not ? Colin Thanks for replying. I remember someone asking me this question in interview. Two cases on diff databases 1. Table with index on only one column say c1. where clause is := where c1 = 'something' (Returning 100 records , total 100000 records) 2. Table with index on two columns say c1,c2 where clause is := where c1 = 'something' (Returning 100 records , total 100000 records) The question was in which case the retrieval is faster (Assuming rest all identical for indexes) I answered case 1. Is it correct ?? Or in both cases there is really no difference how oracle traverse thro' index & fetches required rows??? Sameer -----Original Message----- From: shawc_at_willis.com [mailto:shawc_at_willis.com] Sent: Wednesday, April 26, 2000 11:53 AM To: Multiple recipients of list ORACLE-L Subject: Re: Add more index or not ?Received on Wed Apr 26 2000 - 14:48:04 CDT
> Both uses a hashing algorithm to convert the key value before it...
Actually, no. A B-tree (or variation thereof) uses NO hashing techniques. That would be a Hash Index. A B-tree is a sorted (or ordered) index. Sameer: An index on columns A and B will obviously use more storage than a index on just column A, but if you access the data by mostly column A and sometimes columns A & B, then there is NO point having both an index on columns A & B and another one on A alone. The "A" index is just un-needed overhead. Please re-post if you'd like to discuss this further. Remember: The purpose of an index is to speed up reads and slow down writes. Colin. Please respond to "Rajagopal Venkataramany" <rajagopalvr_at_hotmail.com> To: "oracle list" <oracle_at_telelists.com> cc: oracle_at_telelists.com bcc: Hi, Both uses a hashing algorithm to convert the key value before it stored or used in search. Obviously the storage requirements would be more for a composite index when compared with a independent index. Regarding the effect on performance when using a composite index (A+B) instead of a index on A alone : It depends on the data distribution. With the combination of A+B, if we are able to hit a few set of records then this would be the best approach. You can use this in situation where both the values of A and B are known. If the requirement is that most of the time only A is known, then it would make sense to have a independent index on just A alone. Regards Rajagopal Venkataramany ----Original Message Follows---- Reply-To: "Oak, Sameer" <Sameer.Oak_at_CWUSA.COM> To: "oracle list" <oracle_at_telelists.com> Date: Tue, 25 Apr 2000 13:11:51 -0400 Raj I missed ur message which was posted on 4/18 How sure are u about the statement The composite index on A & B will give the same effect as of having a independent index on just A alone. (Apart from the update/delete overhead) What I was under impression that composit index will be technically slower since it has to read A,B,rowid. & the index only on A will have to read A,rowid. Is this true??? Thanks $ameer << snip >> ______________________________________________________________________ The information in this email and in any attachments is confidential and may be privileged. If you are not the intended recipient, please destroy this message, delete any copies held on your systems and notify the sender immediately. You should not retain, copy or use this email for any purpose, nor disclose all or any part of its content to any other person. -- Author: INET: shawc_at_willis.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------
 |
 |