OLAP Financial Function Calculators for Oracle 9i.
Hi I would like to know if the Oracle Express feature of Financial Function Calculators are available with Oracle enterprise Edition 9.0.1.0.0. If my memory serves me correctly , I think Oracle has incorporated OLAP services as part of the 9i database enterprise edition. But I am not certain if Financial Functions such as IRR, NPV are part of the embedded OLAP services in Oracle 9i enterprise Edition . I am specifically looking for functions such as IRR, NPV, etc. Here are some of the functions: DEPRDECL Calculates declining?balance depreciation DEPRDECLSW Calculates depreciation using a combination of the decliningbalance and straight-line methods DEPRSL Calculates straight?line depreciation DEPRSOYD Calculates sum?of?year?s?digits depreciation FINTSCHED Calculates the interest on a series of fixed?rate installment loans FPMTSCHED Calculates payments for a series of fixed?rate installment loans GROWRATE Calculates the growth rate of a time-series expression IRR Calculates the internal rate of return for a stream of cash flows NPV Calculates the net present value of a stream of cash flows VINTSCHED Calculates the interest portion of the payments on a series of variable-rate installment loans VPMTSCHED Calculates a payment schedule for a series of variable-rate installment loans Please let me know what needs to be installed, if this functionality is not part of OLAP services of Oracle enterprise edition 9.0.1.0.0. Thanks Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: OLAP Financial Function Calculators for Oracle 9i.
Hi I would like to know if the Oracle Express feature of Financial Function Calculators are available with Oracle enterprise Edition 9.0.1.0.0. If my memory serves me correctly , I think Oracle has incorporated OLAP services as part of the 9i database enterprise edition. But I am not certain if Financial Functions such as IRR, NPV are part of the embedded OLAP services in Oracle 9i enterprise Edition . I am specifically looking for functions such as IRR, NPV, etc. Here are some of the functions: DEPRDECL Calculates declining?balance depreciation DEPRDECLSW Calculates depreciation using a combination of the decliningbalance and straight-line methods DEPRSL Calculates straight?line depreciation DEPRSOYD Calculates sum?of?year?s?digits depreciation FINTSCHED Calculates the interest on a series of fixed?rate installment loans FPMTSCHED Calculates payments for a series of fixed?rate installment loans GROWRATE Calculates the growth rate of a time-series expression IRR Calculates the internal rate of return for a stream of cash flows NPV Calculates the net present value of a stream of cash flows VINTSCHED Calculates the interest portion of the payments on a series of variable-rate installment loans VPMTSCHED Calculates a payment schedule for a series of variable-rate installment loans Please let me know what needs to be installed, if this functionality is not part of OLAP services of Oracle enterprise edition 9.0.1.0.0. Thanks Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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).
OLAP Financial Function Calculators for Oracle 9i.
Hello: I would like to know if the Oracle Express feature of Financial Function Calculators are available with Oracle enterprise Edition 9.0.1.0.0. If my memory serves me correctly , I think Oracle has incorporated OLAP services as part of the 9i database enterprise edition. But I am not certain if Financial Functions such as IRR, NPV are part of the embedded OLAP services in Oracle 9i enterprise Edition . I am specifically looking for functions such as IRR, NPV, etc. Here are some of the functions: DEPRDECL Calculates declining?balance depreciation DEPRDECLSW Calculates depreciation using a combination of the decliningbalance and straight-line methods DEPRSL Calculates straight?line depreciation DEPRSOYD Calculates sum?of?year?s?digits depreciation FINTSCHED Calculates the interest on a series of fixed?rate installment loans FPMTSCHED Calculates payments for a series of fixed?rate installment loans GROWRATE Calculates the growth rate of a time-series expression IRR Calculates the internal rate of return for a stream of cash flows NPV Calculates the net present value of a stream of cash flows VINTSCHED Calculates the interest portion of the payments on a series of variable-rate installment loans VPMTSCHED Calculates a payment schedule for a series of variable-rate installment loans Please let me know what needs to be installed, if this functionality is not part of OLAP services of Oracle enterprise edition 9.0.1.0.0. Thanks Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Instance fails to start
Could you please let me know, what is the significance of NTTACH=0 and why only this one needs to be removed. Srini -Original Message- Sent: Wednesday, April 10, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Bill, Check whether u have any hung shared memory segments by issuing the command : $ ipcs -mobs Look for an oracle:dba user having NTTACH = 0. If it exists, remove it using the command : $ ipcrm -m semaphore id Attempt to restart. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 10 April 2002 16:48 To: Multiple recipients of list ORACLE-L Hi All! I have encounterd an interesting problem after attempting to make a change in my parameter file. I made a minor change in the date format, and upon shutting down (normal) and starting up, an error in the format was reported. I changed the format back to it's original form so that there was no diff between the original pfile and the current one, and attempted to restart, and I receive the following error: SQL startup ORA-24323: value not allowed ORA-03113: end-of-file on communication channel There is nothing interesting in the alert log, and I see the same error with a startup nomount. Any ideas as to what is going on? Thanks in advance!! Bill Tantzen University of Minnesota Libraries [EMAIL PROTECTED] 612-626-9949 (office) 612-250-6125 (cell) I guess the man's a genius, but what a dirty mind he has, hasn't he? -- Nora Joyce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Tantzen 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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: 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: Long-running SQL
Could you please let me know the Title and Author's complete name. I interested in reviewing this book. Srini -Original Message- Sent: Wednesday, March 27, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Yep, Guy's book is among my fav's. I consider it an indispensable DBA book. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Wednesday, March 27, 2002 2:26 PM To: '[EMAIL PROTECTED]'; Freeman, Robert Thanks for clarifying, Mr. Cigarette Smoking Man. I loaned my book to someone (again). I find a lot of people could benefit from spending a week or so with that book. Whether or not they read it isn't my problem. Lisa -Original Message- From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Long-running SQL It is using the index. Range scans are not smart so to speak. In Harrison's sql tuning book, he states that a range scan is not intelligent. Well, depends on the type of range scan. There are two kinds, bonded and unbounded. Bounded is indeed intelligent and starts and stops at specific points. This kind of range scan you will find, for example, when the WHEN clause contains something like: where range_id 100 and range_id 300 An unbounded range scan, starts at a specific place in the index and reads basically the remainder of the index. A bounded range scan is caused by such actions like Where range_id 100 RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Freeman, Robert 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: 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: EXPORT FAST?
Also look into the option BUFFER in export. Srini -Original Message- Sent: Tuesday, March 26, 2002 10:59 AM To: Multiple recipients of list ORACLE-L I think you can use direct=y option. Are you taking this export to a file (over disk) or directly to tape? Greeting Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 3:13 PM Hi one of export for 35GB database is taking 12 hours.How to reduce this export time. Thx Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Diego Cutrone 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: 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: ORACLE TUNING
Thanks -Original Message- Sent: Wednesday, March 20, 2002 11:23 PM To: Multiple recipients of list ORACLE-L Are the sizes of the tables same on both development and production machines? In our case, we used histograms on indexed columns and that brought execution plans same on both the database. Look for analyze command syntax to build histograms. --- [EMAIL PROTECTED] wrote: Both have current statistics. Data distribution is smaller on DEV. Both are using CBO. -Original Message- Sent: Tuesday, March 19, 2002 4:53 PM To: Multiple recipients of list ORACLE-L What about current statistics on both DBs? Is the distribution of the data reasonably the same? Are they both using the same optimizer? I would state that obiviously something is different between the two instances; otherwise you'd get exactly the same results. [EMAIL PROTECTED] wrote: Hello: I have an identical query that has similar explain plan on both Prod and Dev environment, only difference being that certain indexes are performing unique scan on Prod and Range scan on Dev. Can you cast some light on how this can be matched and under what conditions this discrepancy might occur. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lead, follow, or at least have the courtesy to get out of my way! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: 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). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards(r) http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir 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: 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
RE: ORACLE TUNING
Thanks, I'll post. -Original Message- Sent: Thursday, March 21, 2002 3:58 AM To: Multiple recipients of list ORACLE-L Why not post the query and the two plans ? Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 19 March 2002 19:33 |Hello: | |I have an identical query that has similar explain plan on both Prod and Dev |environment, only difference being that certain indexes are performing |unique scan on Prod and Range scan on Dev. |Can you cast some light on how this can be matched and under what conditions |this discrepancy might occur. | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: 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: ORACLE TUNING
Yes they both are, only difference being the amount of data in Prod and DEV databases for this query. Prod has more. Srini -Original Message- Sent: Tuesday, March 19, 2002 9:43 PM To: Multiple recipients of list ORACLE-L Are the tables/indexes analyzed the same way, if you use CBO? - Kirti -Original Message- Sent: Tuesday, March 19, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Thank you for the response. The indexes on both sides are regular non-unique indexes. Any other possible reasons.. Srini -Original Message- Sent: Tuesday, March 19, 2002 1:34 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wrote: Hello: I have an identical query that has similar explain plan on both Prod and Dev environment, only difference being that certain indexes are performing unique scan on Prod and Range scan on Dev. Can you cast some light on how this can be matched and under what conditions this discrepancy might occur. Thank you, Srini The index being declared UNIQUE in one case and not in the other seems to me the most likely reason. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: 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: Deshpande, Kirti 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: 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: ORACLE TUNING
Thank you I will look into this option. Can tell me more on this if have already implemented this feature. Srini -Original Message- Sent: Wednesday, March 20, 2002 1:58 AM To: Multiple recipients of list ORACLE-L hi Srini, Why don;t you use stored outlines. -Original Message- Sent: Tuesday, March 19, 2002 20:18 To: Multiple recipients of list ORACLE-L Hello: I have an identical query that has similar explain plan on both Prod and Dev environment, only difference being that certain indexes are performing unique scan on Prod and Range scan on Dev. Can you cast some light on how this can be matched and under what conditions this discrepancy might occur. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Hatzistavrou Giannis 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: 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: ORACLE TUNING
Thank you.. Buffer cache is smaller on DEV. What specific parameters are you refering you? Indexes are in the same order. -Original Message- Sent: Tuesday, March 19, 2002 5:52 PM To: Multiple recipients of list ORACLE-L buffer cache size the same ? init.ora parameters the same ? index columns created in similar order Anjo. [EMAIL PROTECTED] wrote: Thank you for the response. The indexes on both sides are regular non-unique indexes. Any other possible reasons.. Srini -Original Message- Sent: Tuesday, March 19, 2002 1:34 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wrote: Hello: I have an identical query that has similar explain plan on both Prod and Dev environment, only difference being that certain indexes are performing unique scan on Prod and Range scan on Dev. Can you cast some light on how this can be matched and under what conditions this discrepancy might occur. Thank you, Srini The index being declared UNIQUE in one case and not in the other seems to me the most likely reason. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: 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: Anjo Kolk 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: 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: ORACLE TUNING
Both have current statistics. Data distribution is smaller on DEV. Both are using CBO. -Original Message- Sent: Tuesday, March 19, 2002 4:53 PM To: Multiple recipients of list ORACLE-L What about current statistics on both DBs? Is the distribution of the data reasonably the same? Are they both using the same optimizer? I would state that obiviously something is different between the two instances; otherwise you'd get exactly the same results. [EMAIL PROTECTED] wrote: Hello: I have an identical query that has similar explain plan on both Prod and Dev environment, only difference being that certain indexes are performing unique scan on Prod and Range scan on Dev. Can you cast some light on how this can be matched and under what conditions this discrepancy might occur. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lead, follow, or at least have the courtesy to get out of my way! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: 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).
ORACLE TUNING
Hello: I have an identical query that has similar explain plan on both Prod and Dev environment, only difference being that certain indexes are performing unique scan on Prod and Range scan on Dev. Can you cast some light on how this can be matched and under what conditions this discrepancy might occur. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: ORACLE TUNING
Thank you for the response. The indexes on both sides are regular non-unique indexes. Any other possible reasons.. Srini -Original Message- Sent: Tuesday, March 19, 2002 1:34 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wrote: Hello: I have an identical query that has similar explain plan on both Prod and Dev environment, only difference being that certain indexes are performing unique scan on Prod and Range scan on Dev. Can you cast some light on how this can be matched and under what conditions this discrepancy might occur. Thank you, Srini The index being declared UNIQUE in one case and not in the other seems to me the most likely reason. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: 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: Instance Monitoring Tools
How would you rate OEM's Instance Monitor and DBArtisan tools with BMC-Patrol. Thanks Srini -Original Message- Sent: Thursday, February 21, 2002 1:43 PM To: Multiple recipients of list ORACLE-L We use BMC-Patrol. Works great for us.. - Kirti -Original Message- Sent: Thursday, February 21, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Can anyone give me an idea of what are the best Oracle instance monitoring tools on the market? Thanks, Rick Stephenson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Deshpande, Kirti 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: 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).
Database Performance Question
Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Database Performance Question
Kirti: Thanks for the insight. Here are my Answers: 1. I feel database is the problem because when only a subset of the total data is used the performance is excellent (with one tenth of the total data). The no. of users are the same. Only amount data that is retrieved is enormous (almost 10 times) when we have the performance problem. 2. Partioning may/may not help as it still has to traverse through all of the partitions to get the data required in order to satisfy the join condition. May improve response time but not significantly. 3. I will look into this as well. 4. Connections on the database side are DEDICATED and on the web side they are shared.(Using Microsoft COM objects, have certain set of database connections as POOL that are shared by different users.) Please let me know what you think... Srini -Original Message- Sent: Tuesday, January 29, 2002 11:20 AM To: Multiple recipients of list ORACLE-L You have done very nicely so far in tuning those joins... but... More questions to you : 1. Why do you think this is still a database problem? 2. Will partitioning those larger tables help the queries? 3. What have you checked to make sure that the bottleneck is not the web-server? 4. Are these connections persistent or the app connects/disconnects when accessing the database? Looking for answers to these questions may help you locate other opportunities to improve upon.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 9:25 AM To: Multiple recipients of list ORACLE-L Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Deshpande, Kirti 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: 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: Database Performance Question
Typically i bringing back about 20,000 rows and that too after filtering first and joining with bigger tables. Srini -Original Message- Sent: Tuesday, January 29, 2002 12:41 PM To: Multiple recipients of list ORACLE-L How many rows are you bringing back from a typical query, how good is the best filter condition and are you filtering that first before joining to the other tables in the explain plan? What is the query and explain plan? Iain Nicoll -Original Message- Sent: Tuesday, January 29, 2002 4:20 PM To: Multiple recipients of list ORACLE-L You have done very nicely so far in tuning those joins... but... More questions to you : 1. Why do you think this is still a database problem? 2. Will partitioning those larger tables help the queries? 3. What have you checked to make sure that the bottleneck is not the web-server? 4. Are these connections persistent or the app connects/disconnects when accessing the database? Looking for answers to these questions may help you locate other opportunities to improve upon.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 9:25 AM To: Multiple recipients of list ORACLE-L Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Deshpande, Kirti 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: Nicoll, Iain (Calanais) 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: 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: Database Performance Question
Thanks -Original Message- Sent: Tuesday, January 29, 2002 3:05 PM To: Multiple recipients of list ORACLE-L Bringing back 20,000 rows is not good in my shop. I recently tuned a SQL (returned 14000 rows, and it is web-based appl) from running 15 minutes to less than 15 seconds. The SQL joining only two indexes. The only changed I make was the index. The index had 2 keys before and I added the third one to filter less number of rowid from index before accessing base tables. For your situation, I would go back to SQL to split the join. Joining 4 big tables is not good. I agreed with Kirti that this is not the database problem. May look into partitioning on that 18million row table. -Original Message- Sent: Tuesday, January 29, 2002 10:36 AM To: Multiple recipients of list ORACLE-L Typically i bringing back about 20,000 rows and that too after filtering first and joining with bigger tables. Srini -Original Message- Sent: Tuesday, January 29, 2002 12:41 PM To: Multiple recipients of list ORACLE-L How many rows are you bringing back from a typical query, how good is the best filter condition and are you filtering that first before joining to the other tables in the explain plan? What is the query and explain plan? Iain Nicoll -Original Message- Sent: Tuesday, January 29, 2002 4:20 PM To: Multiple recipients of list ORACLE-L You have done very nicely so far in tuning those joins... but... More questions to you : 1. Why do you think this is still a database problem? 2. Will partitioning those larger tables help the queries? 3. What have you checked to make sure that the bottleneck is not the web-server? 4. Are these connections persistent or the app connects/disconnects when accessing the database? Looking for answers to these questions may help you locate other opportunities to improve upon.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 9:25 AM To: Multiple recipients of list ORACLE-L Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Deshpande, Kirti 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: Nicoll, Iain (Calanais) 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
RE: Database Performance Question
Thank you , I will look into the suggestions. Srini -Original Message- Sent: Tuesday, January 29, 2002 3:45 PM To: Multiple recipients of list ORACLE-L Srini, 1. You don't have to feel... go after v$system_event, v$session_event and v$session_wait to find out what events and SQLs are contributing to unnecessary waits and try to find out what can be done to resolve it. If you think data retrieval is the problem, then info from these views will help tell you why. Also, check v$filestat for 'hot' files. If this is I/O related problem, then get Quest's StorageXpert to find out I/O contention by disks and by DB segments and SQLs causing it. I think you can get an eval copy from them. 2. Is appl written for Web interaction, or this a retro to get something looking nice as a front-end? May be this is something you may want to check with Developers/Users. Do they, the end users, go through thousands of rows returning through the web browsers. IMO, you have some design issues to deal with.. 3. ?? 4. How many dedicated connections to the database? How much memory is available on the box? Doing some more data collection as mentioned above (in 1) will get you on the right track Hope this helps.. some... - Kirti -Original Message- Sent: Tuesday, January 29, 2002 11:36 AM To: Multiple recipients of list ORACLE-L Kirti: Thanks for the insight. Here are my Answers: 1. I feel database is the problem because when only a subset of the total data is used the performance is excellent (with one tenth of the total data). The no. of users are the same. Only amount data that is retrieved is enormous (almost 10 times) when we have the performance problem. 2. Partioning may/may not help as it still has to traverse through all of the partitions to get the data required in order to satisfy the join condition. May improve response time but not significantly. 3. I will look into this as well. 4. Connections on the database side are DEDICATED and on the web side they are shared.(Using Microsoft COM objects, have certain set of database connections as POOL that are shared by different users.) Please let me know what you think... Srini -Original Message- Sent: Tuesday, January 29, 2002 11:20 AM To: Multiple recipients of list ORACLE-L You have done very nicely so far in tuning those joins... but... More questions to you : 1. Why do you think this is still a database problem? 2. Will partitioning those larger tables help the queries? 3. What have you checked to make sure that the bottleneck is not the web-server? 4. Are these connections persistent or the app connects/disconnects when accessing the database? Looking for answers to these questions may help you locate other opportunities to improve upon.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 9:25 AM To: Multiple recipients of list ORACLE-L Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Oracle Stand by database
Hi all: If anybody has a concise document on setting up stand by databases, please send me a copy or send me the links on the web where I can find one. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Database Views
Thank you all for your opinions. The tables that I want to consolidate are 15 Million rows each. So five tables put together will constitute 75 million rows in one table. I will have to consider partitioning after that for optimum performance. Also Materialized view would take a long time to refresh all these tables especially if it is a complete refresh. - Srini -Original Message- Sent: Thursday, January 17, 2002 10:21 AM To: Multiple recipients of list ORACLE-L This is why data marts were created. You would be much better off to create a reporting database based on the data you need to see. You won't be happy doing this with views from several databases. It won't perform well. As Rachel pointed out it will be inconsistent. At the very least you could create snapshots of these tables so that all of the data would be locally available. Just my $0.02. Jared On Wednesday 16 January 2002 12:04, [EMAIL PROTECTED] wrote: I would like get your opinion on what would be the best way provide access to data across multiple databases on just on Node (database). One way that I have tried is create a view on one database that reads tables across remaining four databases using Dblinks. Let us say there is a table called CUSTOMER that resides on five databases, in order to make it easier to generate reports, a combined view can be created with dblinks on these tables using UNION ALL on one database. Only concern I have is that when using Dblinks, Oracle might copy the entire remote table to the local database and then retrieve the data based on where clause. This might be a significant performance issue especially if the tables are very BIG. If there are better ways to accomplish this or any ideas on this one will be greatly appreciated. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: 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).
Database Views
I would like get your opinion on what would be the best way provide access to data across multiple databases on just on Node (database). One way that I have tried is create a view on one database that reads tables across remaining four databases using Dblinks. Let us say there is a table called CUSTOMER that resides on five databases, in order to make it easier to generate reports, a combined view can be created with dblinks on these tables using UNION ALL on one database. Only concern I have is that when using Dblinks, Oracle might copy the entire remote table to the local database and then retrieve the data based on where clause. This might be a significant performance issue especially if the tables are very BIG. If there are better ways to accomplish this or any ideas on this one will be greatly appreciated. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Oracle Enterprise Manager
I have tried, but they show a status of pending. I am unable to de-register from OEM against this node. Srini -Original Message- Sent: Friday, January 11, 2002 8:55 PM To: Multiple recipients of list ORACLE-L Have you cleared out all registered events, jobs, and alerts against this node? -Original Message- [EMAIL PROTECTED] Sent: Friday, January 11, 2002 1:56 PM To: Multiple recipients of list ORACLE-L Hi: I am running into this problem with OEM while trying to delete a node previously configured. OEM returns an error VNI-4040 Node agent queue file may be corrupted. I have gone through a few postings on Metalink and implemented the suggestions there such as removing .q files in agent directory on the NODE and restating agent on the node, bouncing OMS on the client side but the problem persists. I would appreciate recommendations on resolving this problem. Thanks -Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Kimberly Smith 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: 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).
Oracle Enterprise Manager
Hi: I am running into this problem with OEM while trying to delete a node previously configured. OEM returns an error VNI-4040 Node agent queue file may be corrupted. I have gone through a few postings on Metalink and implemented the suggestions there such as removing .q files in agent directory on the NODE and restating agent on the node, bouncing OMS on the client side but the problem persists. I would appreciate recommendations on resolving this problem. Thanks -Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Database Comparison
Hi: I need to compare my Production database with QA database. I would like to generate a report that shows differences in schemas across these two databases(tables, indexes, views, object definition, etc..). I would appreciate it if you could forward me a script that would accomplish this or any websites where I can find one. Thanks Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
NOLOGGING/LOGGING
Title: RE: Intermedia I am curious to know if the NOLOGGING option would work in an update or insert statement, I mean by using NOLOGGING in an update statement can writes to the redo log be turned off fora particular update or insert operation for that matter. Specially for huge updates where heavy log switches are possible filling up the archive log directory. Please let me know if this can be done. example in a situation where 10 Million rows need to updated. update temp NOLOGGING set zip=11003 where city='Boston' / Thank you
RE: NOLOGGING/LOGGING
thanks -Original Message- Sent: Monday, May 14, 2001 2:39 PM To: Multiple recipients of list ORACLE-L Thanks Rajaram ! Here's the bottom line : NOLOGGING doesn't apply to conventional DML at all ! It applies only to CREATE/ALTER objects and Direct Load Inserts such as using SqlLoader or INSERT as SELECT -Original Message- Sent: Monday, May 14, 2001 10:56 AM To: Multiple recipients of list ORACLE-L There was similar Q from Vikas@innoventry a few days back You cannot turn off logging. Reason: Search through your mails dated 3 days back. Rajaram. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:36 PM To: Multiple recipients of list ORACLE-L Subject:NOLOGGING/LOGGING I am curious to know if the NOLOGGING option would work in an update or insert statement, I mean by using NOLOGGING in an update statement can writes to the redo log be turned off for a particular update or insert operation for that matter. Specially for huge updates where heavy log switches are possible filling up the archive log directory. Please let me know if this can be done. example in a situation where 10 Million rows need to updated. update temp NOLOGGING set zip=11003 where city='Boston' / Thank you NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram 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: Vikas Kawatra 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: 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).
DATABASE COMPARE SCRIPT
Title: RE: When to go for ORACLE NAMES Server I am trying to find out the schema differences between two databases. Differences like Column size,column datatype,column data length, indexes,tables,constraints etc. If anyone has a script or know where I can get one that will accomplish this, please let me know. Thank you.
TEMP tablespace segment management
Hi: Could someone let me know if there is a way to free up temporary segments in a temporary tablespace, other than bouncing the instance. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
CUBES
Hi, Could someone please give me an example for cube. I could understand rollup using the following example. SELECT deptno, job, SUM(sal) FROM emp group by rollup(deptno, job) / Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: CUBES
thanks -Original Message- Sent: Thursday, February 01, 2001 1:37 PM To: Multiple recipients of list ORACLE-L Just try : SELECT deptno, job, SUM(sal) FROM emp group by cube(deptno, job) / and see the difference between rollup and cube! Cube basically adds one more dimension, it gives summary for each value in "job" field. For e.g. what was total salary of all clerks in all departments. Hitarth Trivedi Oracle Certified DBA (7.3) Sun Certified Java 2 Programmer MCSE, MCP+I 315-362-1162 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 1:01 PM To: Multiple recipients of list ORACLE-L Subject:CUBES Hi, Could someone please give me an example for cube. I could understand rollup using the following example. SELECT deptno, job, SUM(sal) FROM emp group by rollup(deptno, job) / Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: Trivedi, Hitarth 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: 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).
