RE: skip scan index
Stephane, The queries will almost always include data from the data blocks in addition to the index information. The only query I can think of where that would not be true would be a simple count of orders by date. I'm beginning to think, based on this discussion and others we've had here where it's been proven that a full table scan is more efficient than an index lookup plus data block read, that perhaps NO index would be best. We are talking row counts in the (at most) 10's of thousands, not millions. I wish it were millions of rows, that would mean the store site was making money :) Rachel --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > Rachel, > >You are right about 'skip scan' being a way to scan the index > rather than something else. In fact, it's an improvement on a full > index scan. >IMHO, since you say that the volume is not that big, there is no > such thing as giving it a try, and possibly comparing it to a full > scan. An index scan (skip or not skip) makes sense if the index is > much smaller than the table. If there is no enormous difference, and > if your query requires other columns than the ones in the index, the > cost of scanning the index plus fetching data blocks (especially if > the clustering factor is low) may well be higher that the cost of > scanning the table in the first place - when I say 'cost', read > 'elapsed time' more than any obscure CBO cooking recipe. >I would naturally tend to consider either two indices or none at > all. > > SF > > >- --- Original Message --- - > >From: Rachel Carmichael <[EMAIL PROTECTED]> > >To: Multiple recipients of list ORACLE-L > ><[EMAIL PROTECTED]> > >Sent: Wed, 28 May 2003 02:59:39 > > > >Okay, I have a developer here who has been reading > >the docs (this can > >be dangerous!) > > > >we are adding functionality to one of our > >applications, this will > >involve using multiple fulfillment houses, so we'll > >be adding the > >fulfillment vendor id to the order table. Easy, > >this is not a problem. > >We want to be able to search by order date and by > >fulfillment vendor > >id/order date > > > >Traditional design would be to add two indexes: one > >on order date, and > >a concatenated one on fulfillment vendor id/order > >date. > > > >The developer is telling me to create a "skip scan > >index" instead of > >two different ones. MY reading in the FM tells me > >that skip scan index > >is not a type of index, but rather a way Oracle > >uses to use an index > >even if the leftmost column is not in the query. > > > >Is there any benefit in my building only the one > >index? Our order > >volume is not so high (and never will be) that > >there is a visible > >performance impact if I have the two indices. > > > >This is 9i, 9.2.0.1, will be upgrading to 9.2.0.2 > >in the near future. > >Solaris > > > >Any suggestions/comments/war stories would be > >appreciated. I know I've > >seen Jonathan post on skip scan indexes before but > >I can't find the > >specific reference at the moment. > > > >Rachel > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephane Faroult > 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). > __ 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).
Re: Oracle 11i new features
H ... Oracle 11 h beer http://www.oracle.com/appsnet/technology/upgrade/docs/features.html JP On Wednesday 28 of May 2003 12:07, you wrote: > Hi > > Can anybody tell me a website where I can know about new features in Oracle > 11/11i? > > Thanks in Advance > Ajay K. Garg -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - On a quiet Night, you can hear the Windows machines reboot. -- 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).
RE: Is there an Oracle 9i on 32-bit ??
If you check out "product availability" on MetaLink there is NO 9i 32 bit for HP. It's all 64 bit. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, May 27, 2003 9:10 PM To: Multiple recipients of list ORACLE-L On Tue, May 27, 2003 at 03:19:40PM -0800, Leyden, Joseph wrote: > Is there an Oracle 9i on 32-bit ?? http://otn.oracle.com/software/products/oracle9i/content.html Oracle9i Release 2 (9.2.0.1) Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for Windows Server 2003 (32-bit) New Oracle9i Database Release 2 Enterprise/Standard Edition for Linux Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (32-bit) Oracle9i Database Release 2 Enterprise Edition for Sun SPARC Solaris (64-bit) Oracle9i Database Release 2 Enterprise/Standard Edition for HP-UX Oracle9i Database Release 2 Enterprise/Standard Edition for Compaq Tru64 Oracle9i Database Release 2 Enterprise/Standard Edition for AIX Oracle9i Database Release 2 Enterprise/Standard Edition for AIX-Based 5L Systems Oracle9i Database Release 2 Enterprise Edition for Linux/390 Oracle9i Database Release 2 Client for Windows 98/NT/2000/XP I assume you mean windows, the only true and righteous path...gag. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Leyden, Joseph > 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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: Goulet, Dick 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).
Re: Oracle, IBM fight of whose DB is more manageable
It's an oxymoron, I'd say. Gogala, Mladen wrote: What is a predictable corporate environment? I know of no such thing. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 27, 2003 4:50 PM To: Multiple recipients of list ORACLE-L "Both will do most jobs, with Oracle excelling in the high-end, highly available marketplace. MSSQL costs far less, both in purchase and TCO and excels in the 2-4 processor predictable corporate environment without a HA requirement." Cheers Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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).
RE: skip scan index
Title: RE: skip scan index Rachel, Skip scan index is not a index type, it is a index scan type. Maybe the developer should re-read the relevant portion of the manual. If your order volume is low, you probably won't see much performance impact by having two indexes (like you need to hear this from ME), but one should suffice ... BTW, it works, really. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 28, 2003 7:00 AM To: Multiple recipients of list ORACLE-L Subject: skip scan index Okay, I have a developer here who has been reading the docs (this can be dangerous!) [ much stuff deleted to conserve electrons ] This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: Alternative way to write delete query
If anybody knows, it must be Lex... Lex, you genius of geniuses and SQL Logician of them all - can you help here? Mogens Mark Richard wrote: This is quite close to what I was thinking of however it doesn't seem to work for Oracle. Does anyone know if there is similar syntax available in the Oracle world? I've looked at the Oracle (8.1.7) doco but can't see how I can achieve what I want to do. "Igor Neyman" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> on.com> cc: Sent by: Subject: RE: Alternative way to write delete query [EMAIL PROTECTED] 28/05/2003 02:34 Please respond to ORACLE-L Small correction for SQL Server / Sybase, if anyone cares, of course -:) Delete table1 from table_a where column1 = col_a or column1 = col_b Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- OLLIG Sent: Tuesday, May 27, 2003 9:35 AM To: Multiple recipients of list ORACLE-L Mark - you could also do it with 2 deletes something like this: delete from (select column1 from table1 , table_a where column1 = col_a) delete from (select column1 from table1 , table_b where column1 = col_b) couldn't find a way to avoid the "ORA-01752: cannot delete from view without exactly one key-preserved table" with the or condition. perhaps someone who isn't still clearing the brain cobwebs after a long weekend can see a solution there. FWIW - i'm pretty sure SQL Server & Sybase will let you get by with this: delete from table1 , table_a , table_b where column1 = col_a or column1 = col_b (don't have a sandbox handy to confirm though) maybe that's what you were thinking of? -Original Message- Sent: Tuesday, May 27, 2003 12:27 AM To: Multiple recipients of list ORACLE-L Hi List, I'm having a mental blank and looking for suggestions... I'm trying to remember alternative ways to write the below query: delete from table where column in (select col_a from table_b union all select col_b from table_b); Having said that, I don't mind if you simplify the nested query down to "select col_a from table_b" even. I just have a feeling that I've seen an equivalent query written totally differently but I can't remember how. I have a feeling it effectively allows more than one table to be mentioned in the delete without needing a nested query (like the options available in normal selects). Any suggestions? Thanks, Mark. <<>> Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. <
RE: skip scan index
Mark, thanks, interesting article. But I'm still getting the feeling that the index skip scan is helpful only when you don't want to create a secondary index on columns that are not the left-most column. since I believe that we will be doing a LOT of queries by order date as well, I'm not sure that the benefits of defaulting to index skip scan outweigh the benefits of just having the second index. Rachel --- Mark Leith <[EMAIL PROTECTED]> wrote: > Rachel, > > http://technet.oracle.com/oramag/webcolumns/2003/techarticles/schumacher_ski > pscan.html > http://www.oracle-base.com/Articles/9i/IndexSkipScanning.asp > > I don't have any personal experience with them myself :( The first > link > gives a pretty good overview though.. > > Mark > > -Original Message- > Carmichael > Sent: 28 May 2003 12:00 > To: Multiple recipients of list ORACLE-L > > > Okay, I have a developer here who has been reading the docs (this can > be dangerous!) > > we are adding functionality to one of our applications, this will > involve using multiple fulfillment houses, so we'll be adding the > fulfillment vendor id to the order table. Easy, this is not a > problem. > We want to be able to search by order date and by fulfillment vendor > id/order date > > Traditional design would be to add two indexes: one on order date, > and > a concatenated one on fulfillment vendor id/order date. > > The developer is telling me to create a "skip scan index" instead of > two different ones. MY reading in the FM tells me that skip scan > index > is not a type of index, but rather a way Oracle uses to use an index > even if the leftmost column is not in the query. > > Is there any benefit in my building only the one index? Our order > volume is not so high (and never will be) that there is a visible > performance impact if I have the two indices. > > This is 9i, 9.2.0.1, will be upgrading to 9.2.0.2 in the near future. > Solaris > > Any suggestions/comments/war stories would be appreciated. I know > I've > seen Jonathan post on skip scan indexes before but I can't find the > specific reference at the moment. > > Rachel > > __ > 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). > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/2003 > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/2003 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Leith > 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). > __ 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).
Re: skip scan index
I tried it and what it does is, essentially, a fast full index scan on the remaining columns of the index. To resolve the query, oracle does a full sequential scan on the index instead on the table. If your index is one third size of the table, you saved quite a few IOs but don't expect anything like search on unique key performance. On 2003.05.28 07:54 Mark Leith wrote: > Rachel, > > http://technet.oracle.com/oramag/webcolumns/2003/techarticles/schumacher_ski > pscan.html > http://www.oracle-base.com/Articles/9i/IndexSkipScanning.asp > > I don't have any personal experience with them myself :( The first link > gives a pretty good overview though.. > > Mark > > -Original Message- > Carmichael > Sent: 28 May 2003 12:00 > To: Multiple recipients of list ORACLE-L > > > Okay, I have a developer here who has been reading the docs (this can > be dangerous!) > > we are adding functionality to one of our applications, this will > involve using multiple fulfillment houses, so we'll be adding the > fulfillment vendor id to the order table. Easy, this is not a problem. > We want to be able to search by order date and by fulfillment vendor > id/order date > > Traditional design would be to add two indexes: one on order date, and > a concatenated one on fulfillment vendor id/order date. > > The developer is telling me to create a "skip scan index" instead of > two different ones. MY reading in the FM tells me that skip scan index > is not a type of index, but rather a way Oracle uses to use an index > even if the leftmost column is not in the query. > > Is there any benefit in my building only the one index? Our order > volume is not so high (and never will be) that there is a visible > performance impact if I have the two indices. > > This is 9i, 9.2.0.1, will be upgrading to 9.2.0.2 in the near future. > Solaris > > Any suggestions/comments/war stories would be appreciated. I know I've > seen Jonathan post on skip scan indexes before but I can't find the > specific reference at the moment. > > Rachel > > __ > 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). > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/2003 > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/2003 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Leith > 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). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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).
Re: skip scan index
Hi Rachel, Correct, "Skip Scan Index" is not a type of index but a method whereby Oracle can eliminate the need to visit leaf nodes by determining whether the leading column(s) have changed by sussing out only the branch nodes. It's possibly useful in situations where previously Oracle would not consider a concatenated index if the leading column of the index is unknown whereas now the optimizer might determine that sufficient leaf nodes can be avoided for the index to be of benefit. It's a kinda improved version of the full index scan (or not so full if you know what I mean), However this requires the leading column to have *low* cardinality, low enough for the same repeated column from one leaf node to extent across all values of it's neighbouring leaf node. If the leading column changes from one leaf node to the next, then that leaf node must be at least visited (although subsequent inspection of the index values may enable Oracle to "pull out early" from having to read all index values, if a subsequent change in the leading column rules out all remaining entries). A quick (and nasty) formula would be to consider the ratio of leaf nodes to distinct values (LN/DV). The higher the ratio the better with any value somewhat greater than 1 giving a skip scan index path a chance with the number representing an approximate number of leaf nodes that could be "skipped" per leading index value. This obviously assumes evenish distribution of leading column(s) index values. However, getting back to your actual situation, if table access is only to be made via the order date or by order date and order id (and not necessarily by order id only), then you may find a single index order date || order id would meet all your requirements. Cheers Richard Foote - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, May 28, 2003 8:59 PM > Okay, I have a developer here who has been reading the docs (this can > be dangerous!) > > we are adding functionality to one of our applications, this will > involve using multiple fulfillment houses, so we'll be adding the > fulfillment vendor id to the order table. Easy, this is not a problem. > We want to be able to search by order date and by fulfillment vendor > id/order date > > Traditional design would be to add two indexes: one on order date, and > a concatenated one on fulfillment vendor id/order date. > > The developer is telling me to create a "skip scan index" instead of > two different ones. MY reading in the FM tells me that skip scan index > is not a type of index, but rather a way Oracle uses to use an index > even if the leftmost column is not in the query. > > Is there any benefit in my building only the one index? Our order > volume is not so high (and never will be) that there is a visible > performance impact if I have the two indices. > > This is 9i, 9.2.0.1, will be upgrading to 9.2.0.2 in the near future. > Solaris > > Any suggestions/comments/war stories would be appreciated. I know I've > seen Jonathan post on skip scan indexes before but I can't find the > specific reference at the moment. > > Rachel > > __ > 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). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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).
where is info stored when using the ANALYZE cmd?
1. If I analyze the code using the explain plan, where is info created from this explain plan stored at? 2. If I added more buffers to the buffer-cache, where should I go check if they made any positive difference? thx, maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson 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).
Re: 10053 trace
If it has only the query part then the sql was not parsed by the CBO but by the RBO. Make sure the tables in the query are analyzed, or force the CBO by putting a hint in, even a bogus one that doesn't affect the plan like asking for a non-existing index. At 09:14 PM 5/27/2003 -0800, you wrote: hi thanks for the info.i could make it work for some 9i sqls but a particular sql is not generating trace. the 10053 trace file has only the query para but no other details. the query selects from a simple view built on a table. will this make a difference? here is the query select id from sai.ext_view where (sai.ext_view.ind=0) order by id; where sai is the schema name,ext_view is a view built on a table and ind is a column in the table to force it to parse everytime(test1 to testn..is this a good approach?), i used hints like this below select /*test1 */ id from sai.ext_view where (sai.ext_view.ind=0) order by id; and finally when i see the 8i trace, there is a line which says "bitmap access path rejected" under access path:index(index only). what does this mean? btw,the platform is aix 5l and oracle version is 9.2.0.3 thanks again for taking some time to look into this sai -- Wolfgang Breitling <[EMAIL PROTECTED]> wrote: > At 04:15 PM 5/27/2003 -0800, you wrote: > >hi gurus > >i am trying to generate 10053 trace in 9i and have > met > >with no success. > > > >i used both 'alter session set events' and > >'dbms_system.set_ev'. > > > >i used the above two to generate 10053 trace for > the > >same query in 8i w/o problems. > > > >has anything changed in 9i? > >can you please help me on this? > > There is no difference in creating the 10053 event > trace in 9i as compared > to 8i. The trace itself is a bit different in some > areas. What is the > problem you are having? No trace at all? Can you > greate an ordinary > sql_trace and find it in the udump directory? BTW > what platform? > > Wolfgang Breitling > Centrex Consulting Corporation > http://www.centrexcc.com > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Wolfgang Breitling > 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: Sai Selvaganesan 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). Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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).
RE: skip scan index
I have doubt about the real advantages of index-skip-scan operation. Someone please clarify my doubts. 1. Its more like multiple indexes for unique values of the leading column, won't it be logically equivalent to scanning as many indexes as the number of distinct values of the leading column? If this is the case, until the row size is large, won't it be advisable to use a full-table scan rather than multiple index scans? 2. The real advantage will be in case the leading column has less number of unique values. If that is the case would it not be advisable not to have a index on that column at all? Regards Naveen > -Original Message- > From: Mark Leith [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 28, 2003 5:25 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: skip scan index > > > Rachel, > > http://technet.oracle.com/oramag/webcolumns/2003/techarticles/ > schumacher_ski > pscan.html > http://www.oracle-base.com/Articles/9i/IndexSkipScanning.asp > > I don't have any personal experience with them myself :( The > first link > gives a pretty good overview though.. > > Mark > > -Original Message- > Carmichael > Sent: 28 May 2003 12:00 > To: Multiple recipients of list ORACLE-L > > > Okay, I have a developer here who has been reading the docs (this can > be dangerous!) > > we are adding functionality to one of our applications, this will > involve using multiple fulfillment houses, so we'll be adding the > fulfillment vendor id to the order table. Easy, this is not a problem. > We want to be able to search by order date and by fulfillment vendor > id/order date > > Traditional design would be to add two indexes: one on order date, and > a concatenated one on fulfillment vendor id/order date. > > The developer is telling me to create a "skip scan index" instead of > two different ones. MY reading in the FM tells me that skip scan index > is not a type of index, but rather a way Oracle uses to use an index > even if the leftmost column is not in the query. > > Is there any benefit in my building only the one index? Our order > volume is not so high (and never will be) that there is a visible > performance impact if I have the two indices. > > This is 9i, 9.2.0.1, will be upgrading to 9.2.0.2 in the near future. > Solaris > > Any suggestions/comments/war stories would be appreciated. I know I've > seen Jonathan post on skip scan indexes before but I can't find the > specific reference at the moment. > > Rachel > > __ > 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). > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/2003 > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/2003 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Leith > 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). > > DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are sus
RE: skip scan index
Rachel, You are right about 'skip scan' being a way to scan the index rather than something else. In fact, it's an improvement on a full index scan. IMHO, since you say that the volume is not that big, there is no such thing as giving it a try, and possibly comparing it to a full scan. An index scan (skip or not skip) makes sense if the index is much smaller than the table. If there is no enormous difference, and if your query requires other columns than the ones in the index, the cost of scanning the index plus fetching data blocks (especially if the clustering factor is low) may well be higher that the cost of scanning the table in the first place - when I say 'cost', read 'elapsed time' more than any obscure CBO cooking recipe. I would naturally tend to consider either two indices or none at all. SF >- --- Original Message --- - >From: Rachel Carmichael <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Wed, 28 May 2003 02:59:39 > >Okay, I have a developer here who has been reading >the docs (this can >be dangerous!) > >we are adding functionality to one of our >applications, this will >involve using multiple fulfillment houses, so we'll >be adding the >fulfillment vendor id to the order table. Easy, >this is not a problem. >We want to be able to search by order date and by >fulfillment vendor >id/order date > >Traditional design would be to add two indexes: one >on order date, and >a concatenated one on fulfillment vendor id/order >date. > >The developer is telling me to create a "skip scan >index" instead of >two different ones. MY reading in the FM tells me >that skip scan index >is not a type of index, but rather a way Oracle >uses to use an index >even if the leftmost column is not in the query. > >Is there any benefit in my building only the one >index? Our order >volume is not so high (and never will be) that >there is a visible >performance impact if I have the two indices. > >This is 9i, 9.2.0.1, will be upgrading to 9.2.0.2 >in the near future. >Solaris > >Any suggestions/comments/war stories would be >appreciated. I know I've >seen Jonathan post on skip scan indexes before but >I can't find the >specific reference at the moment. > >Rachel > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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).
RE: Oracle 11i new features
Oracle 11/11i: http://www.vapourware.com Oracle Apps 11/11i http://www.oracle.com/appsnet/content.html http://www.oaug.org/ http://www.appsdba.com HTH Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ajay K. GargSent: 28 May 2003 11:08To: Multiple recipients of list ORACLE-LSubject: Oracle 11i new features Hi Can anybody tell me a website where I can know about new features in Oracle 11/11i? Thanks in Advance Ajay K. Garg
RE: skip scan index
Rachel, http://technet.oracle.com/oramag/webcolumns/2003/techarticles/schumacher_ski pscan.html http://www.oracle-base.com/Articles/9i/IndexSkipScanning.asp I don't have any personal experience with them myself :( The first link gives a pretty good overview though.. Mark -Original Message- Carmichael Sent: 28 May 2003 12:00 To: Multiple recipients of list ORACLE-L Okay, I have a developer here who has been reading the docs (this can be dangerous!) we are adding functionality to one of our applications, this will involve using multiple fulfillment houses, so we'll be adding the fulfillment vendor id to the order table. Easy, this is not a problem. We want to be able to search by order date and by fulfillment vendor id/order date Traditional design would be to add two indexes: one on order date, and a concatenated one on fulfillment vendor id/order date. The developer is telling me to create a "skip scan index" instead of two different ones. MY reading in the FM tells me that skip scan index is not a type of index, but rather a way Oracle uses to use an index even if the leftmost column is not in the query. Is there any benefit in my building only the one index? Our order volume is not so high (and never will be) that there is a visible performance impact if I have the two indices. This is 9i, 9.2.0.1, will be upgrading to 9.2.0.2 in the near future. Solaris Any suggestions/comments/war stories would be appreciated. I know I've seen Jonathan post on skip scan indexes before but I can't find the specific reference at the moment. Rachel __ 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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).
RE: Re: Is there an Oracle 9i on 32-bit ??
>64 is a bigger number than 32. Therefor the human >mind tends to like it >better. Man, I can't wait for the 512-bit OS'es. >The Law Of Bigger >Numbers (LOB-N) applies everywhere you go. This is >just one LOB. There >are other LOBs. LOB-D (Law Of Bigger Dudes), LOB-S >(Law Of Bigger >Salary), LOB-C (Law Of Bigger Car), LOB-F (Law Of >Bigger Fish), and many >more. When I consider some of the spam I receive, stopping the enumeration here is probably wise ... Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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).
RE: Oracle, IBM fight of whose DB is more manageable
Spoken like a true economist. So we end up with half-baked programs that don't meet the minimum requirements. Better to choose what to do, and do it well, than do everything badly, don't you think? Anyway this is falling into OT now. Besides, it's only opinion, since none of the "soft" sciences are really science. : ) Pat. -Original Message- Sent: Tuesday, May 27, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Patrice writes > When I took sociology they decried the use of what they > called "policy science", where someone has an objective but > wants to find the best way to get there. (e.g. "we want the > best education system at a budget reduced by 15 percent." > Then they turn around an talk about "improving" the education > system, or medicare, or... you name it.) They do this a lot > in public policy. They rarely ask: "What level of funding > is ideal for delivery of the following standards of services?" I, at the risk of seeming heretical - but hey I am an economics grad and was an accountant so I'm comfortable with that - find this unhelpful. The objective 'I have the following resources available to me - how can I best use them?' sounds correct to me. Your alternative question ' How many resources do I need to deliver the outcome x - changing how I provide x is not an option' sounds like a recipe for waste and inefficiency. Consider that Connor's excellent choose_a_hit_ratio script essentially asks 'what resources do I need for the following outcome?' and then consumes them. > I still haven't seen an honest comparison of SQL Server vs. > Oracle vs. DB2 vs. Informix vs. SyBase vs. MySQL that I can trust. Here's mine of Oracle vs SQL Server. How honest it is you can judge yourself. "Both will do most jobs, with Oracle excelling in the high-end, highly available marketplace. MSSQL costs far less, both in purchase and TCO and excels in the 2-4 processor predictable corporate environment without a HA requirement." Cheers Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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: Boivin, Patrice J 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).
Oracle 11i new features
Hi Can anybody tell me a website where I can know about new features in Oracle 11/11i? Thanks in Advance Ajay K. Garg
skip scan index
Okay, I have a developer here who has been reading the docs (this can be dangerous!) we are adding functionality to one of our applications, this will involve using multiple fulfillment houses, so we'll be adding the fulfillment vendor id to the order table. Easy, this is not a problem. We want to be able to search by order date and by fulfillment vendor id/order date Traditional design would be to add two indexes: one on order date, and a concatenated one on fulfillment vendor id/order date. The developer is telling me to create a "skip scan index" instead of two different ones. MY reading in the FM tells me that skip scan index is not a type of index, but rather a way Oracle uses to use an index even if the leftmost column is not in the query. Is there any benefit in my building only the one index? Our order volume is not so high (and never will be) that there is a visible performance impact if I have the two indices. This is 9i, 9.2.0.1, will be upgrading to 9.2.0.2 in the near future. Solaris Any suggestions/comments/war stories would be appreciated. I know I've seen Jonathan post on skip scan indexes before but I can't find the specific reference at the moment. Rachel __ 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).
Can't start listener after installing 9.2.0.3 Patch ?
Guys, I have installed 9.2.0.3 Patch over 9.2.0.1 on a win2k server machine ( DELL PE2650 Xeon ). i followed the README file along with patch. while installing the patch,the universal installer requested to stop "DISTRIBUTED TRANSACTION COORDINATOR" service on the OS. after stopping that,the installation of the patch was successful. but while starting the listener,i get the error: "PROCEDURE ENTRY POINT OF LXHLCMOD NOT FOUND IN ORANLS9.DLL". and i am not able to start the listener. am i missing out something ? have anyone faced the same before ? TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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).
how to use Blob instead of BLOB?
i get trouble using the supplying standard package of oracle 8.1.7 for
jdbc2.0 support! , i'm trying to write a standard code that could be
available for any database, and i don't want to use oracle BLOB
datype,but instead the standard Blob java datatype..
here is the code i'm trying to execute, is it correct? can somebody
write to me please, a sample code with Blob instead of BLOB?:
db = DBBroker.getInstance().getConnection();
con = db.getConnection();
stmt = con.createStatement();
...
java.sql.Blob blob =(java.sql.Blob) rset.getBlob("FILE_ATTACHMENT");
OutputStream outstream =
(OutputStream)blob.setBinaryStream(blob.position(blob,1));
..
END of code
the application has a problem when executing the second instruction
(OutputStrem..)
thank you very much for your precious help ..
othman HADDAD
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Othman HADDAD
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).
Re: Is there an Oracle 9i on 32-bit ??
Commit; Can I sit besides you? Mogens Anjo Kolk wrote: Unskyld ! Yes, I have the info for the presentation ready. Can I do it at the DBForum? Can I please come and present this at the Beach Party in the large Jacuzzi? Anjo. Mogens Nørgaard wrote: Yes. What platform are you interested in? 64 is a bigger number than 32. Therefor the human mind tends to like it better. Man, I can't wait for the 512-bit OS'es. The Law Of Bigger Numbers (LOB-N) applies everywhere you go. This is just one LOB. There are other LOBs. LOB-D (Law Of Bigger Dudes), LOB-S (Law Of Bigger Salary), LOB-C (Law Of Bigger Car), LOB-F (Law Of Bigger Fish), and many more. Most systems will work splendidly (sp?) on the 32-bit limit. And 64-bit stuff is always slower than 32-bit stuff. They have to move more stuff around. Thanks to Anjo for (again and again) pointing out the obvious and startling facts to me. Anjo - you promised me you'd make a 32/64-bit presentation one day. Is that gonna be at the Database Forum in October or what? If not, you're fired, of course. Mogens Leyden, Joseph wrote: Is there an Oracle 9i on 32-bit ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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).
RE: Redo generation rate
Tim, Thanks so much for your response.ur query was of immense help. Cheers Samir -Original Message- Sent: 27 May 2003 18:50 To: Multiple recipients of list ORACLE-L Samir, I find this query useful... select first_time, mb, mb - (avg(mb) over ()) dev_from_avg from(select trunc(first_time) first_time, sum(blocks*block_size)/1048576 mb fromv$archived_log group by trunc(first_time)) order by first_time; Hope this helps -Tim > All, > > Can anybody please help me on this : > > We are trying to find out the bandwidth required for > keeping our DR database updated using Dataguard. > There is an equation the networking guys use for this but > I need to give them the redo generation rate > or redo copy rate in bytes per second. Is there any way I > can find this out without using Statspack ?? > > Thanks and Regards, > > Samir > > Samir Sarkar > Oracle DBA > SchlumbergerSema > Email : [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6028 > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > Fax : +44 (0) 115 - 957 6018 > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net -- > Author: SARKAR, Samir > 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: 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: SARKAR, Samir 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).
RE: ocp discount
put OTN20 in the discount code -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]En nombre de AKEnviado el: martes, 27 de mayo de 2003 18:45Para: Multiple recipients of list ORACLE-LAsunto: ocp discount I heard/read they give 20% discount on ocp exam fee if u are registered with technet . Can any body confirm that . How do I get that discount ? -ak
Re: Is there an Oracle 9i on 32-bit ??
Unskyld ! Yes, I have the info for the presentation ready. Can I do it at the DBForum? Can I please come and present this at the Beach Party in the large Jacuzzi? Anjo. Mogens Nørgaard wrote: > > Yes. > > What platform are you interested in? > > 64 is a bigger number than 32. Therefor the human mind tends to like it > better. Man, I can't wait for the 512-bit OS'es. The Law Of Bigger > Numbers (LOB-N) applies everywhere you go. This is just one LOB. There > are other LOBs. LOB-D (Law Of Bigger Dudes), LOB-S (Law Of Bigger > Salary), LOB-C (Law Of Bigger Car), LOB-F (Law Of Bigger Fish), and many > more. > > Most systems will work splendidly (sp?) on the 32-bit limit. And 64-bit > stuff is always slower than 32-bit stuff. They have to move more stuff > around. Thanks to Anjo for (again and again) pointing out the obvious > and startling facts to me. > > Anjo - you promised me you'd make a 32/64-bit presentation one day. Is > that gonna be at the Database Forum in October or what? If not, you're > fired, of course. > > Mogens > > Leyden, Joseph wrote: > > >Is there an Oracle 9i on 32-bit ?? > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > 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: Anjo Kolk 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).
(no subject)
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Radu Deliu 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).
PLSql and printing
Hi all, is there a possibility to directly print to the standardprinter from without plsql procedures ? Maybe it is possible to utl_file.fOpen a printer in some way ? any hints are welcome ! TNX > Frank < -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Foelz.Frank 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).
uploade using pl/sql gateway, ias
applogies for posting this in the DBA forum...
list, i'm uploading files from my client browser to the database using the
pl/sql gateway (mod pl/sql)
on ias. Everything is working, but i cannot find the procedure which
actually uploads the file!!! the upload
procedure is simply.. a procedure that dosnt do anything, it's jsut called
!!
PROCEDURE upload_doc(name IN owa.vc_arr) IS
BEGIN
htp.p('uploaded');
END;
now i hv made the name of the documents as a PK in the document table.. and
when uploading the same document again,
i want to display an eror... but where to put that pl/sql code to display
the error i hv tried writing the expection
in the above procedure.. but seems like this procedure is called AFTER the
file is magically uploaded in the DB !!
TIA
-rahul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: rahul sharma
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).
