RE: Moving projects from development/test to production
Helmut I don't think this is off-topic, but something that many of us Oracle DBAs wrestle with. If you kept John Kanagaraj's posting yesterday on the DBA Support Database topic, it contains the "big picture". If you didn't keep it, email me privately and I'll send it. I believe he is referring to the ITIL standards body. There is probably an ITIL user group near you or a company that gives talks from time to time. That is the easiest way to get an overview of ITIL. Our organization is "evolving" in that direction. Overall, this is a long-term commitment by your organization. You don't change everything overnight. One immediate change you can implement is a "staging" system. Most of us currently have a test or development system. Staging is an exact copy of production in all respects. From the database side, cloning the database or using RMAN DUPLICATE works very well. Then the development team makes a release to you. Ideally this is on a CD-ROM labeled 1.1 or whatever. You take the CD-ROM and instructions and apply the changes to the staging server. Then the staging system is tested. If it is deemed satisfactory, then you schedule a time and make the changes on production. If it fails the testing or you are unable to apply the changes, then it gets bounced back to the development group. The release may include application or web server changes that must be coordinated with database changes. This is a small change, but it has helped our releases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 31, 2003 1:59 AM To: Multiple recipients of list ORACLE-L Hi! A somewhat off-topic question this time. I am put in charge of defining the procedure of moving projects from test/development into the production environment. This is to be seen from the entire IT-perspective (i.e. not just databases, but also Unix, Oracle and SAN). I.e. we should come up with check-lists and the like; although having an eye on quality assurance... We urgently need to set procedures up for that since the last time this was a nightmare... Did anybody out there work on a similar project? What are the procedures that you are following? Any input would be appreciated. This is 9.2 on HP-UX 11. Thanks, Helmut Helmut Daiminger WWK Lebensversicherung a.G. Marsstrasse 37 80292 München Telefon: (0 89) 51 14 - 3490 Fax: (0 89) 51 14 - 27 62 mailto:[EMAIL PROTECTED] http://www.wwk.de *** select 'bye for now' from sys.dual *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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: DENNIS WILLIAMS 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: Moving projects from development/test to production
Dennis, You guessed correctly that this is ITIL based. I completed a Foundation certificate in ITIL way back in '96 when it was still UK based more than what it is now. The principles still stand, and the organization I worked for implemented some kind of CMDB. Unfortunately, they got into very low level details for the Cis and the project became too big to get off the ground One needs to find a balance. OTOH, the tools to help implement ITIL have come a long way since and I mentioned some good ones (at least ones that I have seen). Most of ITIL is just common-sense distilled into a framework for IT processes that define what an IT organization needs to get things done properly. However, in my limited understanding, the IT scene and organizations changes direction and in leadership so rapidly that one needs an evolving plan (to say the least). John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-Original Message- >From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] >Sent: Friday, October 31, 2003 8:55 AM >To: Multiple recipients of list ORACLE-L >Subject: RE: Moving projects from development/test to production > > >Helmut > I don't think this is off-topic, but something that many of >us Oracle >DBAs wrestle with. > If you kept John Kanagaraj's posting yesterday on the DBA Support >Database topic, it contains the "big picture". If you didn't >keep it, email >me privately and I'll send it. I believe he is referring to the ITIL >standards body. There is probably an ITIL user group near you >or a company >that gives talks from time to time. That is the easiest way to get an >overview of ITIL. Our organization is "evolving" in that >direction. Overall, >this is a long-term commitment by your organization. You don't change >everything overnight. > One immediate change you can implement is a "staging" >system. Most of us >currently have a test or development system. Staging is an >exact copy of >production in all respects. From the database side, cloning >the database or >using RMAN DUPLICATE works very well. Then the development team makes a >release to you. Ideally this is on a CD-ROM labeled 1.1 or >whatever. You >take the CD-ROM and instructions and apply the changes to the staging >server. Then the staging system is tested. If it is deemed >satisfactory, >then you schedule a time and make the changes on production. >If it fails the >testing or you are unable to apply the changes, then it gets >bounced back to >the development group. The release may include application or >web server >changes that must be coordinated with database changes. This is a small >change, but it has helped our releases. > >Dennis Williams >DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > >-Original Message- >Sent: Friday, October 31, 2003 1:59 AM >To: Multiple recipients of list ORACLE-L > > >Hi! > >A somewhat off-topic question this time. > >I am put in charge of defining the procedure of moving projects from >test/development into the production environment. This is to >be seen from >the entire IT-perspective (i.e. not just databases, but also >Unix, Oracle >and SAN). I.e. we should come up with check-lists and the >like; although >having an eye on quality assurance... > >We urgently need to set procedures up for that since the last >time this was >a nightmare... > >Did anybody out there work on a similar project? What are the >procedures >that you are following? > >Any input would be appreciated. > >This is 9.2 on HP-UX 11. > >Thanks, >Helmut > > >Helmut Daiminger > >WWK Lebensversicherung a.G. >Marsstrasse 37 >80292 München >Telefon: (0 89) 51 14 - 3490 >Fax: (0 89) 51 14 - 27 62 >mailto:[EMAIL PROTECTED] >http://www.wwk.de > >*** select 'bye for now' from sys.dual *** >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Daiminger, Helmut > 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 info
anyone take the 8i performance tuning ocp test?
Im reading the Sybex OCP book on tuning and it is absolutely loaded with inaccuracies. Is the test the same way? If so do they improve it in 9i? The book is loaded with all types of hit ratios, discussions about committing frequently to IMPROVE performance, and other garbage. anyone know the guys who wrote this book? I dont want to write their names. Did they just write it to the test? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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).
OT - how/where to buy oracle test voucher ?
Hi everybody, Where/how can i buy a voucher for oracle exam ? I noticed two payment methods while filling up a Prometric registration form for Exam #1Z0-031. One of them was "voucher". how and where do i get it ? how much is it ? ...anyone in this list from Japan ? Regards, 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).
test scenario # 1, dropped online redo logs - UPDATE
i am able to re-create the control file .. but on doing "recover database using backup controlfile" the database is requesting a "change#" which was in the deleted online redo log !!! now what ??? > -- > From: Rahul > Sent: Friday, August 16, 2002 1:57 PM > To: 'Oracle List I' > Subject: test scenario # 1, dropped online redo logs > > list, i will be testing various recovery scenarios on a test instance.. > > my db is in archive log.. i hv a cold backup, i created a table, inserted > some records and > switched the logfile.. (i dnt hv a hot backup) , then i deleted both the > online redo logs. > > now i;m trying to re-create the controlfile (with resetlogs) but it fails > with.. > > CREATE CONTROLFILE REUSE DATABASE "ORACLE" RESETLOGS ARCHIVELOG > * > ORA-01503: CREATE CONTROLFILE failed > ORA-01158: database already mounted > > before i issue the create controlfile command... i do a . > > svrmgr30> startup nomount > > i have the following questions.. > > 1) why i'm getting this error > 2) is re-creating the controlfile the *only* way out after the online logs > are removed ? > > TIA > rahul > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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).
OT: looking for 9i on solaris for test
Hello all, I'm looking for Oracle9i on Solaris for some tests. do you know a site offers these types of services. As I know Compaq offers, bu I need Solaris ? thanks in advance... -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal 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).
How to test for all digits in string
Hello gurus, Could someone tell me the best way to check a string to ensure that it contains all numeric digits before converting it to a number with to_number? I don't see a function like ISNUM. TIA, Woody -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Woody Mckay 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).
Test : Because I haven't got a mail since yesterday
Title: Message Are the email services down?
Snapshot too old during stress test... how to avoid
Im testing worst case scenarios right now. So Im doing batch updates,inserts,deletes and 'create table as' from a staging tablespace of approximately 5GBs to a master tablespace of approximately 11GBs. Ive got my job queue processes set to 36 and Im running 36 at a time in the background in order to gather statistics and timing under worst case scenarios. Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB for this test. I have 4 standard RBS with optimal size set to 1GB. Why would I get a snapshot too old? I would think that 11GBs of rollback would be big enough. Would increasing the number of Rollback segments avoid this even though I have the same amount of space in the tablespace? In reality Im going to seriallize the process to avoid this and to improve performance, however, I want to stress the system. any advice? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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: anyone take the 8i performance tuning ocp test?
Ryan - I took the 8i OCP for Tuning. I used Couchman to study with, and don't recall any big differences with the exam. The exam is prepared from the Oracle Education Student Guide for Oracle 8i. That would have been a couple of years ago, and if Oracle Education was teaching hit ratios back then, then you better know the answers on the exam. I thought Cary put it best in quoting his father: "There is the right answer and the answer the teacher expects, and I expect you to know them both". When I took the 9i version of the Oracle Tuning class, they were in the process of shifting away from hit ratios. I expect by the time 10g rolls around Cary's book will have had a deep impact on Oracle Education. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Im reading the Sybex OCP book on tuning and it is absolutely loaded with inaccuracies. Is the test the same way? If so do they improve it in 9i? The book is loaded with all types of hit ratios, discussions about committing frequently to IMPROVE performance, and other garbage. anyone know the guys who wrote this book? I dont want to write their names. Did they just write it to the test? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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: DENNIS WILLIAMS 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: anyone take the 8i performance tuning ocp test?
I'm studying for the 9i Performance Tuning exam, too. I'm glad to hear about the inaccuracies in this book. I have this book and the Oracle Press book by Pack. I also have Oracle Online Learning and I think I will stick more closely to that. Also, hopefully the Self Test Software gives a good indication of the type of questions on the exam, or the focus of them. Mike -Original Message- Sent: Wednesday, November 12, 2003 7:09 AM To: Multiple recipients of list ORACLE-L Im reading the Sybex OCP book on tuning and it is absolutely loaded with inaccuracies. Is the test the same way? If so do they improve it in 9i? The book is loaded with all types of hit ratios, discussions about committing frequently to IMPROVE performance, and other garbage. anyone know the guys who wrote this book? I dont want to write their names. Did they just write it to the test? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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). This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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: OT - how/where to buy oracle test voucher ?
www.oracle.com do a search for certification. select a track. you can get to a prometric site throught there. put down OTN20 in the voucher to save $25. the forms 9i one is in beta and is only $40 now. however, its a pain. 165 questions... and boring. > > From: Prem Khanna J <[EMAIL PROTECTED]> > Date: 2003/09/10 Wed AM 06:34:24 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: OT - how/where to buy oracle test voucher ? > > Hi everybody, > > Where/how can i buy a voucher for oracle exam ? > > I noticed two payment methods while filling up a Prometric registration > form for Exam #1Z0-031. > > One of them was "voucher". > how and where do i get it ? how much is it ? > > ...anyone in this list from Japan ? > > Regards, > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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: test scenario # 1, dropped online redo logs - UPDATE
try open resetlogs. you won't be able to fully recover but you might get the database open --- Rahul <[EMAIL PROTECTED]> wrote: > i am able to re-create the control file .. > but on doing "recover database using backup controlfile" the > database is > requesting a "change#" which was in the deleted online redo log !!! > now what ??? > > > > -- > > From: Rahul > > Sent: Friday, August 16, 2002 1:57 PM > > To: 'Oracle List I' > > Subject:test scenario # 1, dropped online redo logs > > > > list, i will be testing various recovery scenarios on a test > instance.. > > > > my db is in archive log.. i hv a cold backup, i created a table, > inserted > > some records and > > switched the logfile.. (i dnt hv a hot backup) , then i deleted > both the > > online redo logs. > > > > now i;m trying to re-create the controlfile (with resetlogs) but > it fails > > with.. > > > > CREATE CONTROLFILE REUSE DATABASE "ORACLE" RESETLOGS ARCHIVELOG > > * > > ORA-01503: CREATE CONTROLFILE failed > > ORA-01158: database already mounted > > > > before i issue the create controlfile command... i do a . > > > > svrmgr30> startup nomount > > > > i have the following questions.. > > > > 1) why i'm getting this error > > 2) is re-creating the controlfile the *only* way out after the > online logs > > are removed ? > > > > TIA > > rahul > > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rahul > 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). __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
OEM: Is there a test to find broken dblinks?
Title: OEM: Is there a test to find broken dblinks? Hi All, I'm looking for an event test in OEM to find broken dblinks. Anyone know such? Thanks.
RE: Is there a test to find broken dblinks?
Title: OEM: Is there a test to find broken dblinks? That would be useful, as import drops package bodies when there are invalid db links in packages. Short of testing them manually one by one, I don't know of one. Import must be doing it though, when it tries to compile packages. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message-From: Sivan Rabinovitz [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002 6:33 AMTo: Multiple recipients of list ORACLE-LSubject: OEM: Is there a test to find broken dblinks? Hi All, I'm looking for an event test in OEM to find broken dblinks. Anyone know such? Thanks.
Bitmap vs btree - how to tell? how to test?
Listers, We are creating indexes on a 300m row fact table today. I am researching bitmap versus btree (again) to see where the latest info points. Anyone care to comment on the way to determine whether an index should be a btree or a bitmap? Anyone even know a good way to test this? thx, /jack __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey 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: Explain Plan different on TEST and PRODUCTION instance
Just for your reading... MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 03 Aug 2001 15:36:05 -0800 Brijesh, Even though OPTIMIZER_MODE=RULE, the CBO will be used in the presence of other features (e.g. partitioning, degree of parallelism, etc...). In this case TEST is getting a better plan because the CBO is being used. You can tell this from several features in the explain plan: 1. Cost = 169 Only the CBO calculates costs. 2. Only the CBO uses hash joins. The first thing I'd check is the degree of parallelism on the tables AND indexes. In 8.0.5 and 8.1.5 the CBO is used when the indexes have a degree of parallelism > 1 even if the tables don't (see note: 70008.1). If you follow the flow chart in Note: 66484.1 "Which Optimizer is Used ?" (looks best if you click on the "fixed font" above the heading for the note) you should find what's causing the CBO to be used on Test. HTH, -- Anita --- "Gupta, Brijesh" <[EMAIL PROTECTED]> wrote: > Hi ALL > > I have a query with was running fast during the > test in the test instance > and > now when moved to production is running very slow. > On checking I found that same query is using > different explain plan on test > and production. > > Test is exact copy of production database only > little older data. > > Both database running Oracle Application with > optimizer mode = RULE . > Oracle 8.0.5 > Platform AIX > > Can somebody give me a pointer why this is > happening. > > Thanks > > Here is explain plan from both instance and query > > ON PROD : > > Query Plan > > SELECT STATEMENT Cost = > SORT GROUP BY > NESTED LOOPS > NESTED LOOPS > TABLE ACCESS FULL DI_PRATN_CHARGE_ITEMS > TABLE ACCESS BY INDEX ROWID > CP_INVOICE_HEADERS_ALL > INDEX RANGE SCAN CP_INVOICE_HEADERS_N2 > TABLE ACCESS BY INDEX ROWID > CP_INVOICE_ITEMS_ALL > INDEX RANGE SCAN CP_INVOICE_ITEMS_N25 > > > ON TEST : > > Query Plan > - > SELECT STATEMENT Cost = 169 > SORT GROUP BY > HASH JOIN > NESTED LOOPS > TABLE ACCESS BY INDEX ROWID > CP_INVOICE_HEADERS_ALL > INDEX RANGE SCAN CP_INVOICE_HEADERS_N2 > TABLE ACCESS BY INDEX ROWID > CP_INVOICE_ITEMS_ALL > INDEX RANGE SCAN CP_INVOICE_ITEMS_PK > TABLE ACCESS FULL DI_PRATN_CHARGE_ITEMS > > > > and Query is > > Select > Nvl(ih.sub_customer_number, ih.customer_number) > customer_number > ,ih.sub_account_number > ,ii.inventory_item_id > ,ii.organization_id > ,Sum(ii.total_line_amount) total_line_amount > From apps.CP_INVOICE_ITEMS ii, > apps.CP_INVOICE_HEADERS ih, > apps.DI_PRATN_CHARGE_ITEMS ci > where ih.billing_period_end_date = '31-jan-2000' > andii.invoice_id = ih.invoice_id > andii.inventory_item_id=ci.inventory_item_id+0 > andii.organization_id=ci.organization_id+0 > andnvl(ii.total_line_amount, 0) != 0 > group by > Nvl(ih.sub_customer_number, > ih.customer_number), > ih.sub_account_number, > ii.inventory_item_id, > ii.organization_id > / > > > > > > > > Brijesh Gupta > Oracle Production DBA > __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 S
Re: Explain Plan different on TEST and PRODUCTION instance
--- "A. Bardeen" <[EMAIL PROTECTED]> wrote: > Brijesh, > > Even though OPTIMIZER_MODE=RULE, the CBO will be > used > in the presence of other features (e.g. > partitioning, > degree of parallelism, etc...). > > In this case TEST is getting a better plan because > the > CBO is being used. You can tell this from several > features in the explain plan: > 1. Cost = 169 > Only the CBO calculates costs. > 2. Only the CBO uses hash joins. > > The first thing I'd check is the degree of > parallelism > on the tables AND indexes. In 8.0.5 and 8.1.5 the > CBO > is used when the indexes have a degree of > parallelism > > 1 even if the tables don't (see note: 70008.1). > > If you follow the flow chart in Note: 66484.1 "Which > Optimizer is Used ?" (looks best if you click on > the > "fixed font" above the heading for the note) you > should find what's causing the CBO to be used on > Test. > > HTH, > > -- Anita > > --- "Gupta, Brijesh" <[EMAIL PROTECTED]> > wrote: > > Hi ALL > > > > I have a query with was running fast during the > > test in the test instance > > and > > now when moved to production is running very > slow. > > On checking I found that same query is using > > different explain plan on test > > and production. > > > > Test is exact copy of production database only > > little older data. > > > > Both database running Oracle Application with > > optimizer mode = RULE . > > Oracle 8.0.5 > > Platform AIX > > > > Can somebody give me a pointer why this is > > happening. > > > > Thanks > > > > Here is explain plan from both instance and query > > > > ON PROD : > > > > Query Plan > > > > > SELECT STATEMENT Cost = > > SORT GROUP BY > > NESTED LOOPS > > NESTED LOOPS > > TABLE ACCESS FULL DI_PRATN_CHARGE_ITEMS > > TABLE ACCESS BY INDEX ROWID > > CP_INVOICE_HEADERS_ALL > > INDEX RANGE SCAN CP_INVOICE_HEADERS_N2 > > TABLE ACCESS BY INDEX ROWID > > CP_INVOICE_ITEMS_ALL > > INDEX RANGE SCAN CP_INVOICE_ITEMS_N25 > > > > > > ON TEST : > > > > Query Plan > > > - > > SELECT STATEMENT Cost = 169 > > SORT GROUP BY > > HASH JOIN > > NESTED LOOPS > > TABLE ACCESS BY INDEX ROWID > > CP_INVOICE_HEADERS_ALL > > INDEX RANGE SCAN CP_INVOICE_HEADERS_N2 > > TABLE ACCESS BY INDEX ROWID > > CP_INVOICE_ITEMS_ALL > > INDEX RANGE SCAN CP_INVOICE_ITEMS_PK > > TABLE ACCESS FULL DI_PRATN_CHARGE_ITEMS > > > > > > > > and Query is > > > > Select > > Nvl(ih.sub_customer_number, > ih.customer_number) > > customer_number > > ,ih.sub_account_number > > ,ii.inventory_item_id > > ,ii.organization_id > > ,Sum(ii.total_line_amount) total_line_amount > > From apps.CP_INVOICE_ITEMS ii, > > apps.CP_INVOICE_HEADERS ih, > > apps.DI_PRATN_CHARGE_ITEMS ci > > where ih.billing_period_end_date = > '31-jan-2000' > > andii.invoice_id = ih.invoice_id > > and > ii.inventory_item_id=ci.inventory_item_id+0 > > andii.organization_id=ci.organization_id+0 > > andnvl(ii.total_line_amount, 0) != 0 > > group by > > Nvl(ih.sub_customer_number, > > ih.customer_number), > > ih.sub_account_number, > > ii.inventory_item_id, > > ii.organization_id > > / > > > > > > > > > > > > > > > > Brijesh Gupta > > Oracle Production DBA > > > > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute > with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: A. Bardeen > 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 >
Re: Explain Plan different on TEST and PRODUCTION instance
Brijesh, Another thing to check is if the tables involved have been analyzed on prod database. Sukumar Kurup __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sukumar Kurup 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: Explain Plan different on TEST and PRODUCTION instance
Title: RE: Explain Plan different on TEST and PRODUCTION instance Thanks Anita, It was the degree of parallelism that was creating the problem. I was just checking the degree column of the dba_indexes to set the parallelism , which was 1 but the INSTANCES column was set to DEFAULT. Brijesh -Original Message- From: A. Bardeen [mailto:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 5:33 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Explain Plan different on TEST and PRODUCTION instance Brijesh, Even though OPTIMIZER_MODE=RULE, the CBO will be used in the presence of other features (e.g. partitioning, degree of parallelism, etc...). In this case TEST is getting a better plan because the CBO is being used. You can tell this from several features in the explain plan: 1. Cost = 169 Only the CBO calculates costs. 2. Only the CBO uses hash joins. The first thing I'd check is the degree of parallelism on the tables AND indexes. In 8.0.5 and 8.1.5 the CBO is used when the indexes have a degree of parallelism > 1 even if the tables don't (see note: 70008.1). If you follow the flow chart in Note: 66484.1 "Which Optimizer is Used ?" (looks best if you click on the "fixed font" above the heading for the note) you should find what's causing the CBO to be used on Test. HTH, -- Anita --- "Gupta, Brijesh" <[EMAIL PROTECTED]> wrote: > Hi ALL > > I have a query with was running fast during the > test in the test instance > and > now when moved to production is running very slow. > On checking I found that same query is using > different explain plan on test > and production. > > Test is exact copy of production database only > little older data. > > Both database running Oracle Application with > optimizer mode = RULE . > Oracle 8.0.5 > Platform AIX > > Can somebody give me a pointer why this is > happening. > > Thanks > > Here is explain plan from both instance and query > > ON PROD : > > Query Plan > > SELECT STATEMENT Cost = > SORT GROUP BY > NESTED LOOPS > NESTED LOOPS > TABLE ACCESS FULL DI_PRATN_CHARGE_ITEMS > TABLE ACCESS BY INDEX ROWID > CP_INVOICE_HEADERS_ALL > INDEX RANGE SCAN CP_INVOICE_HEADERS_N2 > TABLE ACCESS BY INDEX ROWID > CP_INVOICE_ITEMS_ALL > INDEX RANGE SCAN CP_INVOICE_ITEMS_N25 > > > ON TEST : > > Query Plan > - > SELECT STATEMENT Cost = 169 > SORT GROUP BY > HASH JOIN > NESTED LOOPS > TABLE ACCESS BY INDEX ROWID > CP_INVOICE_HEADERS_ALL > INDEX RANGE SCAN CP_INVOICE_HEADERS_N2 > TABLE ACCESS BY INDEX ROWID > CP_INVOICE_ITEMS_ALL > INDEX RANGE SCAN CP_INVOICE_ITEMS_PK > TABLE ACCESS FULL DI_PRATN_CHARGE_ITEMS > > > > and Query is > > Select > Nvl(ih.sub_customer_number, ih.customer_number) > customer_number > ,ih.sub_account_number > ,ii.inventory_item_id > ,ii.organization_id > ,Sum(ii.total_line_amount) total_line_amount > From apps.CP_INVOICE_ITEMS ii, > apps.CP_INVOICE_HEADERS ih, > apps.DI_PRATN_CHARGE_ITEMS ci > where ih.billing_period_end_date = '31-jan-2000' > and ii.invoice_id = ih.invoice_id > and ii.inventory_item_id=ci.inventory_item_id+0 > and ii.organization_id=ci.organization_id+0 > and nvl(ii.total_line_amount, 0) != 0 > group by > Nvl(ih.sub_customer_number, > ih.customer_number), > ih.sub_account_number, > ii.inventory_item_id, > ii.organization_id > / > > > > > > > > Brijesh Gupta > Oracle Production DBA > __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/
Re: How to test for all digits in string
Here are three slightly different versions of what you might be looking for. CREATE OR REPLACE FUNCTION isnum (thestring IN VARCHAR2) RETURN BOOLEAN IS holder NUMBER; BEGIN holder := TO_NUMBER(thestring); RETURN TRUE; EXCEPTION WHEN OTHERS THEN RETURN FALSE; END; / That is callable from PL/SQL, not SQL. For SQL use, you would return a number or a string indicating whether it is successful. CREATE OR REPLACE FUNCTION isnum (thestring IN VARCHAR2) RETURN NUMBER IS holder NUMBER; BEGIN holder := TO_NUMBER(thestring); RETURN 1; -- pseudo-true EXCEPTION WHEN OTHERS THEN RETURN 0; -- pseudo false END; / However, the following might be slightly better, depending on the application. CREATE OR REPLACE FUNCTION toNumIfPossible (thestring IN VARCHAR2) RETURN NUMBER IS BEGIN RETURN TO_NUMBER(thestring); EXCEPTION WHEN OTHERS THEN RETURN NULL; END; / Cheers Bill Woody Mckay wrote: > Hello gurus, > > Could someone tell me the best way to check a string to ensure that it > contains all numeric digits before converting it to a number with to_number? > I don't see a function like ISNUM. > > TIA, > > Woody > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Woody Mckay > 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). -- __ http://www.datacraft.com/http://plnet.org/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pribyl 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: Test : Because I haven't got a mail since yesterday
On 2003.10.30 21:59, Satya Prakash Viswanath wrote: Are the email services down? Nope, they're up in smoke. -- 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: Test : Because I haven't got a mail since yesterday
solar flares? http://www.theregister.co.uk/content/archive/21961.html where is that excuse calendar, when I need it? Pd Mladen Gogala <[EMAIL PROTECTED]> wrote: On 2003.10.30 21:59, Satya Prakash Viswanath wrote:> Are the email services down?>Nope, they're up in smoke.-- Mladen GogalaOracle DBA-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mladen GogalaINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? Exclusive Video Premiere - Britney Spears
Re: Snapshot too old during stress test... how to avoid
Are you hitting ORA-1555 because of a fetch across commit? [EMAIL PROTECTED] wrote: why would removing optimal setting help with snapshot too old? what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some brief queries. From: Tim Gorman <[EMAIL PROTECTED]> Date: 2003/06/05 Thu AM 03:25:36 EDT To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Speaking of this trick with a txn in each RBS, I've got a shell script on my website (http://www.evdbt.com/tools.htm) that does just that. It is named "prevent1555.sh" which uses a stored procedure created by a SQL script named "prevent1555_ddl.sql"... As Jared mentioned, it is kind of a last resort, but it works... on 6/4/03 4:05 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: .. and if it still doesn't work, use the trick of putting a transaction in each of the rollback segments while the system is otherwise quiesced, and *do not* commit or rollback the transactions. This forces the rollbacks to extend if necessary, they will never wrap back to the first extent ( actually the second) as long as those transactions are not committed. It just uses a lot of disk space. Disk is cheap, right? :) Consider offlining all your production RBS and creating temporary ones that you can easily drop later. I've used it with SAP client copies, which will not run to completion without doing this, at least on our system. Jared Kirtikumar Deshpande <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/04/2003 09:45 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Snapshot too old during stress test... how to avoid Try removing optimal setting, and shrinking RBS to the min extents (or even below) before running your tests. - Kirti --- Garry Gillies <[EMAIL PROTECTED]> wrote: From memory (of a course attended looong ago), Oracle recommends one rollback segment for every three to four users. Four rollback segments between thirty six processes does seem a little mean. Garry <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/06/03 13:59 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Snapshot too old during stress test... how to avoid Im testing worst case scenarios right now. So Im doing batch updates,inserts,deletes and 'create table as' from a staging tablespace of approximately 5GBs to a master tablespace of approximately 11GBs. Ive got my job queue processes set to 36 and Im running 36 at a time in the background in order to gather statistics and timing under worst case scenarios. Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB for this test. I have 4 standard RBS with optimal size set to 1GB. Why would I get a snapshot too old? I would think that 11GBs of rollback would be big enough. Would increasing the number of Rollback segments avoid this even though I have the same amount of space in the tablespace? In reality Im going to seriallize the process to avoid this and to improve performance, however, I want to stress the system. any advice? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] __ 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: Tim Gorman 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). -- Daniel W. Fink http://www.optimaldba.com
Re: Snapshot too old during stress test... how to avoid
The rbs does not shrink to optimal when the transaction commits. The 2nd transaction to 'find' that the rbs has extended beyond optimal will cause the rbs to shrink. -- Daniel W. Fink http://www.optimaldba.com Thomas Day wrote: With optimal, the rollback segment shrinks back to its optimal size as soon as the update, insert, or delete transaction is committed. However, there may be a long running query that is using that rollback segment for a consistent view of the database. If the rollback segment shrinks, the query cannot find the data that it needs. This results in a snapshot too old error. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink 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: Snapshot too old during stress test... how to avoid
Is the error only occurring when you do the create table as select? Are any other processes modifying data in the source table? What is the db_block_size? [EMAIL PROTECTED] wrote: nope. My process is rather simple. A flag comes in... either we do a create table as, drop the old table, and create the indexes based on the data in the stage tablespace or, we do insert select Commit; update commit; delete commit; The snapshot too old is occurring during the process of create table as, all the data is getting created in the new table, then Im getting a snapshot too old. I didnt have error handling there to know EXACTLY when its happening, but right after I do the create table as, I have a query of the data dictionary, then I drop the old table. The old table is not being dropped and the new table is being created. Im at a loss. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink 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: Snapshot too old during stress test... how to avoid
>From memory (of a course attended looong ago), Oracle recommends one rollback segment for every three to four users. Four rollback segments between thirty six processes does seem a little mean. Garry <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/06/03 13:59 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Snapshot too old during stress test... how to avoid Im testing worst case scenarios right now. So Im doing batch updates,inserts,deletes and 'create table as' from a staging tablespace of approximately 5GBs to a master tablespace of approximately 11GBs. Ive got my job queue processes set to 36 and Im running 36 at a time in the background in order to gather statistics and timing under worst case scenarios. Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB for this test. I have 4 standard RBS with optimal size set to 1GB. Why would I get a snapshot too old? I would think that 11GBs of rollback would be big enough. Would increasing the number of Rollback segments avoid this even though I have the same amount of space in the tablespace? In reality Im going to seriallize the process to avoid this and to improve performance, however, I want to stress the system. any advice? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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: Garry Gillies 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: Snapshot too old during stress test... how to avoid
Try removing optimal setting, and shrinking RBS to the min extents (or even below) before running your tests. - Kirti --- Garry Gillies <[EMAIL PROTECTED]> wrote: > From memory (of a course attended looong ago), > Oracle recommends one rollback segment for every > three to four users. > Four rollback segments between thirty six processes > does seem a little mean. > > Garry > > > > > > <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 04/06/03 13:59 > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Snapshot too old during stress test... how to avoid > > > Im testing worst case scenarios right now. So Im doing batch > updates,inserts,deletes and 'create table as' from a staging tablespace of > approximately 5GBs to a master tablespace of approximately 11GBs. > > Ive got my job queue processes set to 36 and Im running 36 at a time in > the background in order to gather statistics and timing under worst case > scenarios. > > Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB > for this test. I have 4 standard RBS with optimal size set to 1GB. Why > would I get a snapshot too old? I would think that 11GBs of rollback would > be big enough. Would increasing the number of Rollback segments avoid this > even though I have the same amount of space in the tablespace? > > In reality Im going to seriallize the process to avoid this and to improve > performance, however, I want to stress the system. > > any advice? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > __ 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: Kirtikumar Deshpande 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: Snapshot too old during stress test... how to avoid
... and if it still doesn't work, use the trick of putting a transaction in each of the rollback segments while the system is otherwise quiesced, and *do not* commit or rollback the transactions. This forces the rollbacks to extend if necessary, they will never wrap back to the first extent ( actually the second) as long as those transactions are not committed. It just uses a lot of disk space. Disk is cheap, right? :) Consider offlining all your production RBS and creating temporary ones that you can easily drop later. I've used it with SAP client copies, which will not run to completion without doing this, at least on our system. Jared Kirtikumar Deshpande <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/04/2003 09:45 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Snapshot too old during stress test... how to avoid Try removing optimal setting, and shrinking RBS to the min extents (or even below) before running your tests. - Kirti --- Garry Gillies <[EMAIL PROTECTED]> wrote: > From memory (of a course attended looong ago), > Oracle recommends one rollback segment for every > three to four users. > Four rollback segments between thirty six processes > does seem a little mean. > > Garry > > > > > > <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 04/06/03 13:59 > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Snapshot too old during stress test... how to avoid > > > Im testing worst case scenarios right now. So Im doing batch > updates,inserts,deletes and 'create table as' from a staging tablespace of > approximately 5GBs to a master tablespace of approximately 11GBs. > > Ive got my job queue processes set to 36 and Im running 36 at a time in > the background in order to gather statistics and timing under worst case > scenarios. > > Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB > for this test. I have 4 standard RBS with optimal size set to 1GB. Why > would I get a snapshot too old? I would think that 11GBs of rollback would > be big enough. Would increasing the number of Rollback segments avoid this > even though I have the same amount of space in the tablespace? > > In reality Im going to seriallize the process to avoid this and to improve > performance, however, I want to stress the system. > > any advice? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > __ 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: Kirtikumar Deshpande 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).
Re: Snapshot too old during stress test... how to avoid
Speaking of this trick with a txn in each RBS, I've got a shell script on my website (http://www.evdbt.com/tools.htm) that does just that. It is named "prevent1555.sh" which uses a stored procedure created by a SQL script named "prevent1555_ddl.sql"... As Jared mentioned, it is kind of a last resort, but it works... on 6/4/03 4:05 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: > .. and if it still doesn't work, use the trick of putting a transaction > in > each of the rollback segments while the system is otherwise quiesced, > and *do not* commit or rollback the transactions. > > This forces the rollbacks to extend if necessary, they will never wrap > back to the first extent ( actually the second) as long as those > transactions > are not committed. > > It just uses a lot of disk space. Disk is cheap, right? :) > > Consider offlining all your production RBS and creating temporary ones > that you can easily drop later. > > I've used it with SAP client copies, which will not run to completion > without > doing this, at least on our system. > > Jared > > > > > > Kirtikumar Deshpande <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 06/04/2003 09:45 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: Snapshot too old during stress test... how to avoid > > > Try removing optimal setting, and shrinking RBS to the min extents (or > even below) before running > your tests. > > - Kirti > > > --- Garry Gillies <[EMAIL PROTECTED]> wrote: >> From memory (of a course attended looong ago), >> Oracle recommends one rollback segment for every >> three to four users. >> Four rollback segments between thirty six processes >> does seem a little mean. >> >> Garry >> >> >> >> >> >> <[EMAIL PROTECTED]> >> Sent by: [EMAIL PROTECTED] >> 04/06/03 13:59 >> Please respond to ORACLE-L >> >> >> To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> >> cc: >> Subject:Snapshot too old during stress test... how to > avoid >> >> >> Im testing worst case scenarios right now. So Im doing batch >> updates,inserts,deletes and 'create table as' from a staging tablespace > of >> approximately 5GBs to a master tablespace of approximately 11GBs. >> >> Ive got my job queue processes set to 36 and Im running 36 at a time in >> the background in order to gather statistics and timing under worst case > >> scenarios. >> >> Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB > >> for this test. I have 4 standard RBS with optimal size set to 1GB. Why >> would I get a snapshot too old? I would think that 11GBs of rollback > would >> be big enough. Would increasing the number of Rollback segments avoid > this >> even though I have the same amount of space in the tablespace? >> >> In reality Im going to seriallize the process to avoid this and to > improve >> performance, however, I want to stress the system. >> >> any advice? >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: <[EMAIL PROTECTED] >> INET: [EMAIL PROTECTED] >> > > > > __ > 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: Tim Gorman 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 do I test a restore of a raw device?
Hi all: I'm testing a restore of a database file (tools TS). The datafile is a raw device and I have link to that raw evice in my links directory. I"m running Oracle 9203 and UNIX 5l. And the problem I ran into is as follows. If I drop the logical link , the rman restores the data as a datafile. If I remove the link and recreate it pointing to another raw device, the restore fails bacause the file exist. How do I force rman to restore the data in the raw device form? IS there a way to do it? thanks gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei 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: test this email ad (OT -- helpful tip for list)
BTW, for those of you stuck with MS Lookout as your e-mail reader, you can prevent the senseless download of images when viewing/previewing these HTML messages, whose links often contain encoded IDs so the authors get better ways to track you down and sell your e-mail addresses. 1. In IE, under "File", check "Work Offline". 2. Use a real browser. 3. See also http://www.grotto11.com/blog/?+1039831658 for an article on MS's lack of RFC compliance. 4. Tell Oracle Corp not to use MS-specific code in their web pages! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, January 08, 2003 3:07 PM To: Multiple recipients of list ORACLE-L Guys and Gays I just started working for this company and they have a really cool DBA appliance. It for up my time to do other DBA stuff. Paul OCP Monitors database health, performance, host, space, audit, response, stand-by and security events including BSTAT/ESTAT and STATSPACK.For a FREE TRIAL: Contact's Name Email Address This information will only be used for contacting you about this product by Pinnacle Data. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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).
my messages are not getting to list. trying to test
Re: Bitmap vs btree - how to tell? how to test?
I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash 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: Bitmap vs btree - how to tell? how to test?
I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash 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: Bitmap vs btree - how to tell? how to test?
LOL Autoreply. I hope that they can block this guy PDQ or we'll be swamped. Anand Prakash com> cc: Sent by: rootSubject: Re: Bitmap vs btree - how to tell? how to test? 05/24/2002 02:00 PM Please respond to ORACLE-L I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash 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: Thomas Day 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: Bitmap vs btree - how to tell? how to test?
Either that, or we can contact Jaspreet. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, May 24, 2002 2:29 PM To: Multiple recipients of list ORACLE-L LOL Autoreply. I hope that they can block this guy PDQ or we'll be swamped. Anand Prakash com> cc: Sent by: rootSubject: Re: Bitmap vs btree - how to tell? how to test? 05/24/2002 02:00 PM Please respond to ORACLE-L I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash 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: Thomas Day 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: Mercadante, Thomas F 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: Bitmap vs btree - how to tell? how to test?
I am on leave from May 27 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash 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: Bitmap vs btree - how to tell? how to test?
He's just been put in digest mode. It's good to be king. ;) Jared On Friday 24 May 2002 11:28, Thomas Day wrote: > LOL > > Autoreply. > > I hope that they can block this guy PDQ or we'll be swamped. > > > > > > Anand Prakash > list ORACLE-L @firsthealth.<[EMAIL PROTECTED]> > com> cc: > Sent by: root Subject: Re: Bitmap vs btree - > how to tell? how to test? > > 05/24/2002 > 02:00 PM > Please > respond to > ORACLE-L > > > > > > > I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at > x4338 for any query. Thanks. > > Anand Prakash > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Anand Prakash > 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: 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).
Re: Bitmap vs btree - how to tell? how to test?
low cardinality -- good candidate for bitmap. little or no updates to the column being indexed -- good candidate for bitmap "low" cardinality is relative -- 10,000 distinct values in a 300m row table is low, 100 distinct values in a 10K row table might be high but the main criteria I have found is whether or not the column is updated because when you update the values in a bitmap index, it's not just the one row in the index that is updated but the entire segment of the bitmap. And THAT can lock the index on you. Rachel --- Jack Silvey <[EMAIL PROTECTED]> wrote: > Listers, > > We are creating indexes on a 300m row fact table > today. I am researching bitmap versus btree (again) to > see where the latest info points. > > Anyone care to comment on the way to determine whether > an index should be a btree or a bitmap? Anyone even > know a good way to test this? > > thx, > > /jack > > > __ > Do You Yahoo!? > LAUNCH - Your Yahoo! Music Experience > http://launch.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jack Silvey > 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Bitmap vs btree - how to tell? how to test?
On 2002.05.25 17:38 Rachel Carmichael wrote: > low cardinality -- good candidate for bitmap. little or no updates to > the column being indexed -- good candidate for bitmap > > "low" cardinality is relative -- 10,000 distinct values in a 300m row > table is low, 100 distinct values in a 10K row table might be high > > but the main criteria I have found is whether or not the column is > updated because when you update the values in a bitmap index, it's not > just the one row in the index that is updated but the entire segment > of > the bitmap. And THAT can lock the index on you. > > Rachel > Well, it doesn't exactly lock the whole index, it locks only the rows that have the same bitmap value as the row that is being updated. For a low cardinality column, that may mean locking down a significant portion of the index (and the underlying table, of course). That makes bitmap indexes (and indices) completely unsuitable for the OLTP environment. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala 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).
[Q] install ORACLE ODBC patch 8.1.7.5 and "ODBC test" gone?
I installed ORACLE client 8.1.7 on NT. after finished, I can configure ODBC through "MS ODBC Administrator" and test it from "ODBC test". I installed ODBC patch 8.1.7.5 and "ODBC test" is gone from "Network Admin" entry. How can I recall it back? Thnaks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash 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: OCP Test on Oracle 8i New features Upgrade : study
Robert, Shame on you for the "plug". Did you ask Ashoke to post the message so there could be some saving grace distributed for the 9i upgrade shortcomings?. Yes, I have the book and find it very informative. It is nice to know that there is an 8i to 9i upgrade book available. I have not see it in my local bookstore yet, of course my locat bookstore has not replace the copy of Oracle Perfomace Tuning 101 yet either. I don't think I will need it for a while because we are not scheduled to upgrade until late 2003. Ashoke, the information needed to assist in upgrading your OCP from 8 to 8i is in the book and on other documentation. Read and understand the source information and practice on a database. When you are confident with your knowledge review the information and schedule the exam. Remember, the exam is not A, or B, or C, or D the answers will test your conceptual knowledge and the answers will most likely be A,B, and D. ROR mª¿ªm >>> [EMAIL PROTECTED] 03/12/02 01:00PM >>> I just happen to have a book published by Coriolis called the Oracle 8 to 8i Exam Cram Guide... You can find it on Amazon, bookpool, etc... 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: Tuesday, March 12, 2002 10:59 AM To: Multiple recipients of list ORACLE-L URLs, Sample questions Greetings All, Could you please send me the name & author of the books, or any sample questions for Oracle 8i new features upgrade test. For 7.3 and 8 upgrade tests, I used DBA Certification Exam guide by Couchman and it was helpful. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: Ron Rogers 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: OCP Test on Oracle 8i New features Upgrade : study
Ron, I have one DBA lined up to ask that same question for the next 6 months for that very purpose. I have an opening on September 27th, would you like to take it?? My personal rule is that I don't just fashion a message that will shamelessly plug my book, in and of itself. For example I would never post a message here that says: Hey buy my Oracle9i New Features book by Oracle Press and my Mastering Oracle8i book by Sybex and also buy my Oracle 8 to 8i Upgrade Exam Cram book by Coriolis and finally you can also get my Oracle 7.3 to 8 Upgrade Exam Cram book by Coriolis as well I'd never do a shameless plug like that, ever. But to help someone, well then I will gladly offer the services of my hard work. And I've said it before and I'll say it again, to anyone, if you don't like the book after you buy it, please return it and get your money back. If you like it, please do let me know... (and a nice word on Amazon or bookpool is always appreciated!) 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: Tuesday, March 12, 2002 2:12 PM To: Multiple recipients of list ORACLE-L Robert, Shame on you for the "plug". Did you ask Ashoke to post the message so there could be some saving grace distributed for the 9i upgrade shortcomings?. Yes, I have the book and find it very informative. It is nice to know that there is an 8i to 9i upgrade book available. I have not see it in my local bookstore yet, of course my locat bookstore has not replace the copy of Oracle Perfomace Tuning 101 yet either. I don't think I will need it for a while because we are not scheduled to upgrade until late 2003. Ashoke, the information needed to assist in upgrading your OCP from 8 to 8i is in the book and on other documentation. Read and understand the source information and practice on a database. When you are confident with your knowledge review the information and schedule the exam. Remember, the exam is not A, or B, or C, or D the answers will test your conceptual knowledge and the answers will most likely be A,B, and D. ROR mª¿ªm >>> [EMAIL PROTECTED] 03/12/02 01:00PM >>> I just happen to have a book published by Coriolis called the Oracle 8 to 8i Exam Cram Guide... You can find it on Amazon, bookpool, etc... 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: Tuesday, March 12, 2002 10:59 AM To: Multiple recipients of list ORACLE-L URLs, Sample questions Greetings All, Could you please send me the name & author of the books, or any sample questions for Oracle 8i new features upgrade test. For 7.3 and 8 upgrade tests, I used DBA Certification Exam guide by Couchman and it was helpful. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: Ron Rogers 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
RE: OCP Test on Oracle 8i New features Upgrade : study
Robert, Very good response. I guess that is why some people write books and others read books. I normally don't have time for either but I have learned lately that you have to make time to keep up with the changes. I have used you book to pass the Oracle 7 to 8 upgrade. The content was complete and the knowledge learned , along with the Oracle OCP 7 exam book OCP 8 upgrade section, help tremendiously. Using both sources and an Oracle 8i database,(besides 7.3.4 that's all I have available) I learned and understood the concepts presented. I was able to acheive a little over 84 on the score. All of the knowledge needed was presented some more detailed than others. Now that I look back on the experience and start moving forward towards my 8i OCP and eventually 9i OCP, I will study and practice more with the concepts that Oracle uses. Initially for the OCP 7 exam the answers were testing your knowledge needed for each test and the tests were "comfortable" and pleasent to take. With the 8 OCP upgrade I found myself having to dig into the deep trenches of my mind to understand what they wanted and pick the multiple answers needed. A real test of your understanding of Oracle concepts. I know the test has to be short. They can't ask 240 questions and allow 6 hours to take the test. The test has to do a complimentary job of asking complex questions about a vast subject. I don't know how you find time to write with a full time job. I know Mike Ault and with his work and seminal schedule I never could figure out how he wrote his books. Thanks again for taking the time to share your knowledge and help the other DBA's of the world. Ron Rogers DBA OCP ROR mª¿ªm >>> [EMAIL PROTECTED] 03/12/02 02:33PM >>> Ron, I have one DBA lined up to ask that same question for the next 6 months for that very purpose. I have an opening on September 27th, would you like to take it?? My personal rule is that I don't just fashion a message that will shamelessly plug my book, in and of itself. For example I would never post a message here that says: Hey buy my Oracle9i New Features book by Oracle Press and my Mastering Oracle8i book by Sybex and also buy my Oracle 8 to 8i Upgrade Exam Cram book by Coriolis and finally you can also get my Oracle 7.3 to 8 Upgrade Exam Cram book by Coriolis as well I'd never do a shameless plug like that, ever. But to help someone, well then I will gladly offer the services of my hard work. And I've said it before and I'll say it again, to anyone, if you don't like the book after you buy it, please return it and get your money back. If you like it, please do let me know... (and a nice word on Amazon or bookpool is always appreciated!) 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: Ron Rogers 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: OCP Test on Oracle 8i New features Upgrade : study
Ron (and several people who have sent me personal emails as well), Thanks so much. I love what I do. I'm actually taking a break from writing right now, been at it almost 3 years non-stop, but I have a couple of ideas that I'm brewing with Oracle Press and one with Sybex. The economic times have hit the publishers hard though, and my wife wants to see more of me. I've been considering picking up my education again, my Masters is calling me and my kids tell me I need to become Dr. Rob... so we shall see. Truth is that I've never felt all that worthy of writing an Oracle book. Sitting in the shadows of grates like Mike, Jonathan, Marlene, Rachel, Steve, Kevin, etc...etc... well, it's a great ride, that's all I can say. BUT Oracle9i New Features is the Number One Oracle book on Bookpool right now!! :-)) My 5 minutes of fame... woo hoo!!! 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: Tuesday, March 12, 2002 3:33 PM To: Multiple recipients of list ORACLE-L Robert, Very good response. I guess that is why some people write books and others read books. I normally don't have time for either but I have learned lately that you have to make time to keep up with the changes. I have used you book to pass the Oracle 7 to 8 upgrade. The content was complete and the knowledge learned , along with the Oracle OCP 7 exam book OCP 8 upgrade section, help tremendiously. Using both sources and an Oracle 8i database,(besides 7.3.4 that's all I have available) I learned and understood the concepts presented. I was able to acheive a little over 84 on the score. All of the knowledge needed was presented some more detailed than others. Now that I look back on the experience and start moving forward towards my 8i OCP and eventually 9i OCP, I will study and practice more with the concepts that Oracle uses. Initially for the OCP 7 exam the answers were testing your knowledge needed for each test and the tests were "comfortable" and pleasent to take. With the 8 OCP upgrade I found myself having to dig into the deep trenches of my mind to understand what they wanted and pick the multiple answers needed. A real test of your understanding of Oracle concepts. I know the test has to be short. They can't ask 240 questions and allow 6 hours to take the test. The test has to do a complimentary job of asking complex questions about a vast subject. I don't know how you find time to write with a full time job. I know Mike Ault and with his work and seminal schedule I never could figure out how he wrote his books. Thanks again for taking the time to share your knowledge and help the other DBA's of the world. Ron Rogers DBA OCP ROR mª¿ªm >>> [EMAIL PROTECTED] 03/12/02 02:33PM >>> Ron, I have one DBA lined up to ask that same question for the next 6 months for that very purpose. I have an opening on September 27th, would you like to take it?? My personal rule is that I don't just fashion a message that will shamelessly plug my book, in and of itself. For example I would never post a message here that says: Hey buy my Oracle9i New Features book by Oracle Press and my Mastering Oracle8i book by Sybex and also buy my Oracle 8 to 8i Upgrade Exam Cram book by Coriolis and finally you can also get my Oracle 7.3 to 8 Upgrade Exam Cram book by Coriolis as well I'd never do a shameless plug like that, ever. But to help someone, well then I will gladly offer the services of my hard work. And I've said it before and I'll say it again, to anyone, if you don't like the book after you buy it, please return it and get your money back. If you like it, please do let me know... (and a nice word on Amazon or bookpool is always appreciated!) 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: Ron Rogers 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 N
RE: OCP Test on Oracle 8i New features Upgrade : study
oh man, what makes you think *I* feel all that worthy of writing books? I am constantly aware of just how little I really know about Oracle. My only consolation seems to be that there are lots of people out there who don't know all that much either. And some who know less than me, and THOSE are the ones I try to help --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > Ron (and several people who have sent me personal emails as well), > > Thanks so much. I love what I do. I'm actually taking a break from > writing > right now, been at it almost 3 years non-stop, but I have a couple of > ideas that I'm brewing with Oracle Press and one with Sybex. The > economic times have hit the publishers hard though, and my wife wants > to see more of me. I've been considering picking up my education > again, > my Masters is calling me and my kids tell me I need to become Dr. > Rob... > so we shall see. > > Truth is that I've never felt all that worthy of writing an Oracle > book. > Sitting in the shadows of grates like Mike, Jonathan, Marlene, > Rachel, > Steve, Kevin, etc...etc... well, it's a great ride, that's all I can > say. > > BUT Oracle9i New Features is the Number One Oracle book on > Bookpool > right now!! :-)) > > My 5 minutes of fame... woo hoo!!! > > 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: Tuesday, March 12, 2002 3:33 PM > To: Multiple recipients of list ORACLE-L > > > Robert, > Very good response. I guess that is why some people write books and > others read books. I normally don't have time for either but I have > learned lately that you have to make time to keep up with the > changes. > I have used you book to pass the Oracle 7 to 8 upgrade. The content > was complete and the knowledge learned , along with the Oracle OCP 7 > exam book OCP 8 upgrade section, help tremendiously. Using both > sources > and an Oracle 8i database,(besides 7.3.4 that's all I have available) > I > learned and understood the concepts presented. I was able to acheive > a > little over 84 on the score. All of the knowledge needed was > presented > some more detailed than others. Now that I look back on the > experience > and start moving forward towards my 8i OCP and eventually 9i OCP, I > will > study and practice more with the concepts that Oracle uses. Initially > for the OCP 7 exam the answers were testing your knowledge needed for > each test and the tests were "comfortable" and pleasent to take. With > the 8 OCP upgrade I found myself having to dig into the deep trenches > of > my mind to understand what they wanted and pick the multiple answers > needed. A real test of your understanding of Oracle concepts. I know > the > test has to be short. They can't ask 240 questions and allow 6 hours > to > take the test. The test has to do a complimentary job of asking > complex > questions about a vast subject. > I don't know how you find time to write with a full time job. I > know > Mike Ault and with his work and seminal schedule I never could figure > out how he wrote his books. > Thanks again for taking the time to share your knowledge and help > the > other DBA's of the world. > Ron Rogers > DBA OCP > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 03/12/02 02:33PM >>> > Ron, > > I have one DBA lined up to ask that same question for the next 6 > months > for > that > very purpose. I have an opening on September 27th, would you like to > take > it?? > > My personal rule is that I don't just fashion a message that will > shamelessly plug > my book, in and of itself. For example I would never post a message > here > that says: > > Hey buy my Oracle9i New Features book by Oracle Press and my > Mastering > Oracle8i book > by Sybex and also buy my Oracle 8 to 8i Upgrade Exam Cram book by > Coriolis > and finally > you can also get my Oracle 7.3 to 8 Upgrade Exam Cram book by > Coriolis > as > well > > I'd never do a shameless plug like that, ever. > > But to help someone, well then I will gladly offer the services of my > hard > work. > > And I've said it before and I'll say it again, to anyone, if you > don't > like > the book > after you buy it, please return it and get your money back. If you > like > it, > please do > let me know... (and a nice word on Amaz
RE: OCP Test on Oracle 8i New features Upgrade : study
and we are all grateful to all of you for your time and efforts and obvious sacrifices in giving that help. Regards Lee -Original Message- Sent: Wednesday, March 13, 2002 4:28 AM To: Multiple recipients of list ORACLE-L oh man, what makes you think *I* feel all that worthy of writing books? I am constantly aware of just how little I really know about Oracle. My only consolation seems to be that there are lots of people out there who don't know all that much either. And some who know less than me, and THOSE are the ones I try to help --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > Ron (and several people who have sent me personal emails as well), > > Thanks so much. I love what I do. I'm actually taking a break from > writing > right now, been at it almost 3 years non-stop, but I have a couple of > ideas that I'm brewing with Oracle Press and one with Sybex. The > economic times have hit the publishers hard though, and my wife wants > to see more of me. I've been considering picking up my education > again, > my Masters is calling me and my kids tell me I need to become Dr. > Rob... > so we shall see. > > Truth is that I've never felt all that worthy of writing an Oracle > book. > Sitting in the shadows of grates like Mike, Jonathan, Marlene, > Rachel, > Steve, Kevin, etc...etc... well, it's a great ride, that's all I can > say. > > BUT Oracle9i New Features is the Number One Oracle book on > Bookpool > right now!! :-)) > > My 5 minutes of fame... woo hoo!!! > > 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: Tuesday, March 12, 2002 3:33 PM > To: Multiple recipients of list ORACLE-L > > > Robert, > Very good response. I guess that is why some people write books and > others read books. I normally don't have time for either but I have > learned lately that you have to make time to keep up with the > changes. > I have used you book to pass the Oracle 7 to 8 upgrade. The content > was complete and the knowledge learned , along with the Oracle OCP 7 > exam book OCP 8 upgrade section, help tremendiously. Using both > sources > and an Oracle 8i database,(besides 7.3.4 that's all I have available) > I > learned and understood the concepts presented. I was able to acheive > a > little over 84 on the score. All of the knowledge needed was > presented > some more detailed than others. Now that I look back on the > experience > and start moving forward towards my 8i OCP and eventually 9i OCP, I > will > study and practice more with the concepts that Oracle uses. Initially > for the OCP 7 exam the answers were testing your knowledge needed for > each test and the tests were "comfortable" and pleasent to take. With > the 8 OCP upgrade I found myself having to dig into the deep trenches > of > my mind to understand what they wanted and pick the multiple answers > needed. A real test of your understanding of Oracle concepts. I know > the > test has to be short. They can't ask 240 questions and allow 6 hours > to > take the test. The test has to do a complimentary job of asking > complex > questions about a vast subject. > I don't know how you find time to write with a full time job. I > know > Mike Ault and with his work and seminal schedule I never could figure > out how he wrote his books. > Thanks again for taking the time to share your knowledge and help > the > other DBA's of the world. > Ron Rogers > DBA OCP > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 03/12/02 02:33PM >>> > Ron, > > I have one DBA lined up to ask that same question for the next 6 > months > for > that > very purpose. I have an opening on September 27th, would you like to > take > it?? > > My personal rule is that I don't just fashion a message that will > shamelessly plug > my book, in and of itself. For example I would never post a message > here > that says: > > Hey buy my Oracle9i New Features book by Oracle Press and my > Mastering > Oracle8i book > by Sybex and also buy my Oracle 8 to 8i Upgrade Exam Cram book by > Coriolis > and finally > you can also get my Oracle 7.3 to 8 Upgrade Exam Cram book by > Coriolis > as > well > > I'd never do a shameless plug like that, ever. > > But to help someone, well then I will gladly offer the services of my > hard > work. > > And I've said it before and I
OEM 2.2: Test email message works but real email doesn't
Hi there, when I do test mails ... working fine. But When I schedule jobs does not seems to be working ... there are no email blockouts. Any hints or ideas? Best regards Henrik Henrik Bachmannmailto:[EMAIL PROTECTED] B.I.M.-Consulting Magdeburghttp://www.bim-consulting.de/ D-39108 Magdeburg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bachmann, Henrik 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: Re: Snapshot too old during stress test... how to avoid
why would removing optimal setting help with snapshot too old? what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some brief queries. > > From: Tim Gorman <[EMAIL PROTECTED]> > Date: 2003/06/05 Thu AM 03:25:36 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Snapshot too old during stress test... how to avoid > > Speaking of this trick with a txn in each RBS, I've got a shell script on my > website (http://www.evdbt.com/tools.htm) that does just that. It is named > "prevent1555.sh" which uses a stored procedure created by a SQL script named > "prevent1555_ddl.sql"... > > As Jared mentioned, it is kind of a last resort, but it works... > > > > > on 6/4/03 4:05 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: > > > .. and if it still doesn't work, use the trick of putting a transaction > > in > > each of the rollback segments while the system is otherwise quiesced, > > and *do not* commit or rollback the transactions. > > > > This forces the rollbacks to extend if necessary, they will never wrap > > back to the first extent ( actually the second) as long as those > > transactions > > are not committed. > > > > It just uses a lot of disk space. Disk is cheap, right? :) > > > > Consider offlining all your production RBS and creating temporary ones > > that you can easily drop later. > > > > I've used it with SAP client copies, which will not run to completion > > without > > doing this, at least on our system. > > > > Jared > > > > > > > > > > > > Kirtikumar Deshpande <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 06/04/2003 09:45 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > cc: > > Subject:Re: Snapshot too old during stress test... how to avoid > > > > > > Try removing optimal setting, and shrinking RBS to the min extents (or > > even below) before running > > your tests. > > > > - Kirti > > > > > > --- Garry Gillies <[EMAIL PROTECTED]> wrote: > >> From memory (of a course attended looong ago), > >> Oracle recommends one rollback segment for every > >> three to four users. > >> Four rollback segments between thirty six processes > >> does seem a little mean. > >> > >> Garry > >> > >> > >> > >> > >> > >> <[EMAIL PROTECTED]> > >> Sent by: [EMAIL PROTECTED] > >> 04/06/03 13:59 > >> Please respond to ORACLE-L > >> > >> > >> To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > >> cc: > >> Subject:Snapshot too old during stress test... how to > > avoid > >> > >> > >> Im testing worst case scenarios right now. So Im doing batch > >> updates,inserts,deletes and 'create table as' from a staging tablespace > > of > >> approximately 5GBs to a master tablespace of approximately 11GBs. > >> > >> Ive got my job queue processes set to 36 and Im running 36 at a time in > >> the background in order to gather statistics and timing under worst case > > > >> scenarios. > >> > >> Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB > > > >> for this test. I have 4 standard RBS with optimal size set to 1GB. Why > >> would I get a snapshot too old? I would think that 11GBs of rollback > > would > >> be big enough. Would increasing the number of Rollback segments avoid > > this > >> even though I have the same amount of space in the tablespace? > >> > >> In reality Im going to seriallize the process to avoid this and to > > improve > >> performance, however, I want to stress the system. > >> > >> any advice? > >> > >> -- > >> Please see the official ORACLE-L FAQ: http://www.orafaq.net > >> -- > >> Author: <[EMAIL PROTECTED] > >> INET: [EMAIL PROTECTED] > >> > > > > > > > > __ > > Do you Yahoo!? > > Yahoo! Calendar - Free online calendar with sync
Re: Re: Snapshot too old during stress test... how to avoid
With optimal, the rollback segment shrinks back to its optimal size as soon as the update, insert, or delete transaction is committed. However, there may be a long running query that is using that rollback segment for a consistent view of the database. If the rollback segment shrinks, the query cannot find the data that it needs. This results in a snapshot too old error. To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: rootcc: Subject: Re: Re: Snapshot too old during stress test... how to avoid 06/05/2003 08:31 AM Please respond to ORACLE-L why would removing optimal setting help with snapshot too old? what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some brief queries. > > From: Tim Gorman <[EMAIL PROTECTED]> > Date: 2003/06/05 Thu AM 03:25:36 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Snapshot too old during stress test... how to avoid > > Speaking of this trick with a txn in each RBS, I've got a shell script on my > website (http://www.evdbt.com/tools.htm) that does just that. It is named > "prevent1555.sh" which uses a stored procedure created by a SQL script named > "prevent1555_ddl.sql"... > > As Jared mentioned, it is kind of a last resort, but it works... > > > > > on 6/4/03 4:05 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: > > > .. and if it still doesn't work, use the trick of putting a transaction > > in > > each of the rollback segments while the system is otherwise quiesced, > > and *do not* commit or rollback the transactions. > > > > This forces the rollbacks to extend if necessary, they will never wrap > > back to the first extent ( actually the second) as long as those > > transactions > > are not committed. > > > > It just uses a lot of disk space. Disk is cheap, right? :) > > > > Consider offlining all your production RBS and creating temporary ones > > that you can easily drop later. > > > > I've used it with SAP client copies, which will not run to completion > > without > > doing this, at least on our system. > > > > Jared > > > > > > > > > > > > Kirtikumar Deshpande <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 06/04/2003 09:45 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > cc: > > Subject:Re: Snapshot too old during stress test... how to avoid > > > > > > Try removing optimal setting, and shrinking RBS to the min extents (or > > even below) before running > > your tests. > > > > - Kirti > > > > > > --- Garry Gillies <[EMAIL PROTECTED]> wrote: > >> From memory (of a course attended looong ago), > >> Oracle recommends one rollback segment for every > >> three to four users. > >> Four rollback segments between thirty six processes > >> does seem a little mean. > >> > >> Garry > >> > >> > >> > >> > >> > >> <[EMAIL PROTECTED]> > >> Sent by: [EMAIL PROTECTED] > >> 04/06/03 13:59 > >> Please respond to ORACLE-L > >> >
RE: Re: Snapshot too old during stress test... how to avoid
the thing is Im not doing any of that. Here is waht Im doing. update,inserts and deletes on tables select on data dictionary. Im also doing 'create table as' Transactions do NOT overlap. for example update,insert,and delete will not use the same tables in different transactions. and Im not updating the data dictionary. > > From: "Ganesh Raja" <[EMAIL PROTECTED]> > Date: 2003/06/05 Thu AM 10:09:52 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Re: Snapshot too old during stress test... how to avoid > > Snapshot Too Old Maybe caused bcos of Delayed Block Cleanout Problems. > Now this Bock was updated an Hour ago and u are now selecting it.. It > finds that there are ITL Entries in there and oracle wants to see if the > Transaction has been commited. > > He Goes back to the Transaction Table of the RBS Pointed by this ITL and > he finds that there is No Rollback entry available.. Why is this ??? The > Optimal Parameter Shrunk the RBS Down and with it all the Undo > Information needed to do a Block Clean out. > > HTH > > Best Regards, > Ganesh R > DID : +65-6215-8413 > HP : +65-9067-8474 > === > Live to learn... forget... and learn again. > === > > > -Original Message- > [EMAIL PROTECTED] > Sent: Thursday, June 05, 2003 8:32 PM > To: Multiple recipients of list ORACLE-L > > > why would removing optimal setting help with snapshot too old? > > what I dont understand is that each of my DML transactions are > independent of each other. They query and perform DML on different > tables. None of them overlap. The only time they overlap is when they > hit the data dictionary for some brief queries. > > > > From: Tim Gorman <[EMAIL PROTECTED]> > > Date: 2003/06/05 Thu AM 03:25:36 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: Re: Snapshot too old during stress test... how to avoid > > > > Speaking of this trick with a txn in each RBS, I've got a shell script > > > on my website (http://www.evdbt.com/tools.htm) that does just that. > > It is named "prevent1555.sh" which uses a stored procedure created by > > a SQL script named "prevent1555_ddl.sql"... > > > > As Jared mentioned, it is kind of a last resort, but it works... > > > > > > > > > > on 6/4/03 4:05 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] > > wrote: > > > > > .. and if it still doesn't work, use the trick of putting a > > > transaction in each of the rollback segments while the system is > > > otherwise quiesced, and *do not* commit or rollback the > > > transactions. > > > > > > This forces the rollbacks to extend if necessary, they will never > > > wrap back to the first extent ( actually the second) as long as > > > those transactions are not committed. > > > > > > It just uses a lot of disk space. Disk is cheap, right? :) > > > > > > Consider offlining all your production RBS and creating temporary > > > ones that you can easily drop later. > > > > > > I've used it with SAP client copies, which will not run to > > > completion without doing this, at least on our system. > > > > > > Jared > > > > > > > > > > > > > > > > > > Kirtikumar Deshpande <[EMAIL PROTECTED]> > > > Sent by: [EMAIL PROTECTED] > > > 06/04/2003 09:45 AM > > > Please respond to ORACLE-L > > > > > > > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > > cc: > > > Subject:Re: Snapshot too old during stress test... how > to avoid > > > > > > > > > Try removing optimal setting, and shrinking RBS to the min extents > > > (or even below) before running your tests. > > > > > > - Kirti > > > > > > > > > --- Garry Gillies <[EMAIL PROTECTED]> wrote: > > >> From memory (of a course attended looong ago), > > >> Oracle recommends one rollback segment for every > > >> three to four users. > > >> Four rollback segments between thirty six processes > > >> does seem a little mean. > > >> > > >> Garry > > >> > > >> > > >> > > >> > > >> > > >> <[EMAIL PROTECTED]> > > >>
RE: Re: Snapshot too old during stress test... how to avoid
Snapshot Too Old Maybe caused bcos of Delayed Block Cleanout Problems. Now this Bock was updated an Hour ago and u are now selecting it.. It finds that there are ITL Entries in there and oracle wants to see if the Transaction has been commited. He Goes back to the Transaction Table of the RBS Pointed by this ITL and he finds that there is No Rollback entry available.. Why is this ??? The Optimal Parameter Shrunk the RBS Down and with it all the Undo Information needed to do a Block Clean out. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 8:32 PM To: Multiple recipients of list ORACLE-L why would removing optimal setting help with snapshot too old? what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some brief queries. > > From: Tim Gorman <[EMAIL PROTECTED]> > Date: 2003/06/05 Thu AM 03:25:36 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Snapshot too old during stress test... how to avoid > > Speaking of this trick with a txn in each RBS, I've got a shell script > on my website (http://www.evdbt.com/tools.htm) that does just that. > It is named "prevent1555.sh" which uses a stored procedure created by > a SQL script named "prevent1555_ddl.sql"... > > As Jared mentioned, it is kind of a last resort, but it works... > > > > > on 6/4/03 4:05 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] > wrote: > > > .. and if it still doesn't work, use the trick of putting a > > transaction in each of the rollback segments while the system is > > otherwise quiesced, and *do not* commit or rollback the > > transactions. > > > > This forces the rollbacks to extend if necessary, they will never > > wrap back to the first extent ( actually the second) as long as > > those transactions are not committed. > > > > It just uses a lot of disk space. Disk is cheap, right? :) > > > > Consider offlining all your production RBS and creating temporary > > ones that you can easily drop later. > > > > I've used it with SAP client copies, which will not run to > > completion without doing this, at least on our system. > > > > Jared > > > > > > > > > > > > Kirtikumar Deshpande <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 06/04/2003 09:45 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > cc: > > Subject:Re: Snapshot too old during stress test... how to avoid > > > > > > Try removing optimal setting, and shrinking RBS to the min extents > > (or even below) before running your tests. > > > > - Kirti > > > > > > --- Garry Gillies <[EMAIL PROTECTED]> wrote: > >> From memory (of a course attended looong ago), > >> Oracle recommends one rollback segment for every > >> three to four users. > >> Four rollback segments between thirty six processes > >> does seem a little mean. > >> > >> Garry > >> > >> > >> > >> > >> > >> <[EMAIL PROTECTED]> > >> Sent by: [EMAIL PROTECTED] > >> 04/06/03 13:59 > >> Please respond to ORACLE-L > >> > >> > >> To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > >> cc: > >> Subject:Snapshot too old during stress test... how to > > avoid > >> > >> > >> Im testing worst case scenarios right now. So Im doing batch > >> updates,inserts,deletes and 'create table as' from a staging > >> tablespace > > of > >> approximately 5GBs to a master tablespace of approximately 11GBs. > >> > >> Ive got my job queue processes set to 36 and Im running 36 at a > >> time in the background in order to gather statistics and timing > >> under worst case > > > >> scenarios. > >> > >> Im in 8.1.7.3 and I have increased the size of my RBS tablespace to > >> 11GB > > > >> for this test. I have 4 standard RBS with optimal size set to 1GB. > >> Why would I get a
RE: Re: Snapshot too old during stress test... how to avoid
Actually when are u getting this error.. There are a Lot Of reasons for ORA-01555 and primary one is DB Block Cleanout or Long Running quries... Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 11:10 PM To: Multiple recipients of list ORACLE-L the thing is Im not doing any of that. Here is waht Im doing. update,inserts and deletes on tables select on data dictionary. Im also doing 'create table as' Transactions do NOT overlap. for example update,insert,and delete will not use the same tables in different transactions. and Im not updating the data dictionary. > > From: "Ganesh Raja" <[EMAIL PROTECTED]> > Date: 2003/06/05 Thu AM 10:09:52 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Re: Snapshot too old during stress test... how to avoid > > Snapshot Too Old Maybe caused bcos of Delayed Block Cleanout Problems. > Now this Bock was updated an Hour ago and u are now selecting it.. It > finds that there are ITL Entries in there and oracle wants to see if > the Transaction has been commited. > > He Goes back to the Transaction Table of the RBS Pointed by this ITL > and he finds that there is No Rollback entry available.. Why is this > ??? The Optimal Parameter Shrunk the RBS Down and with it all the Undo > Information needed to do a Block Clean out. > > HTH > > Best Regards, > Ganesh R > DID : +65-6215-8413 > HP : +65-9067-8474 === > Live to learn... forget... and learn again. > === > > > -Original Message- > [EMAIL PROTECTED] > Sent: Thursday, June 05, 2003 8:32 PM > To: Multiple recipients of list ORACLE-L > > > why would removing optimal setting help with snapshot too old? > > what I dont understand is that each of my DML transactions are > independent of each other. They query and perform DML on different > tables. None of them overlap. The only time they overlap is when they > hit the data dictionary for some brief queries. > > > > From: Tim Gorman <[EMAIL PROTECTED]> > > Date: 2003/06/05 Thu AM 03:25:36 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: Re: Snapshot too old during stress test... how to avoid > > > > Speaking of this trick with a txn in each RBS, I've got a shell > > script > > > on my website (http://www.evdbt.com/tools.htm) that does just that. > > It is named "prevent1555.sh" which uses a stored procedure created by > > a SQL script named "prevent1555_ddl.sql"... > > > > As Jared mentioned, it is kind of a last resort, but it works... > > > > > > > > > > on 6/4/03 4:05 PM, [EMAIL PROTECTED] at > > [EMAIL PROTECTED] > > wrote: > > > > > .. and if it still doesn't work, use the trick of putting a > > > transaction in each of the rollback segments while the system is > > > otherwise quiesced, and *do not* commit or rollback the > > > transactions. > > > > > > This forces the rollbacks to extend if necessary, they will never > > > wrap back to the first extent ( actually the second) as long as > > > those transactions are not committed. > > > > > > It just uses a lot of disk space. Disk is cheap, right? :) > > > > > > Consider offlining all your production RBS and creating temporary > > > ones that you can easily drop later. > > > > > > I've used it with SAP client copies, which will not run to > > > completion without doing this, at least on our system. > > > > > > Jared > > > > > > > > > > > > > > > > > > Kirtikumar Deshpande <[EMAIL PROTECTED]> Sent by: > > > [EMAIL PROTECTED] 06/04/2003 09:45 AM > > > Please respond to ORACLE-L > > > > > > > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > > cc: > > > Subject:Re: Snapshot too old during stress test... how > to avoid > > > > > > > > > Try removing optimal setting, and shrinking RBS to the min extents > > > (or even below) before running your tests. > > > > > > - Kirti > > > > > > > > > --- Garry Gillies <[EMAIL PROTECTED]> wrote: > > >> F
RE: Re: Snapshot too old during stress test... how to avoid
Not as soon as the Update is Over.. Only after a Certain period of Time. This operation is done By SMON. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- Sent: Thursday, June 05, 2003 10:05 PM To: Multiple recipients of list ORACLE-L With optimal, the rollback segment shrinks back to its optimal size as soon as the update, insert, or delete transaction is committed. However, there may be a long running query that is using that rollback segment for a consistent view of the database. If the rollback segment shrinks, the query cannot find the data that it needs. This results in a snapshot too old error. To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: rootcc: Subject: Re: Re: Snapshot too old during stress test... how to avoid 06/05/2003 08:31 AM Please respond to ORACLE-L why would removing optimal setting help with snapshot too old? what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some brief queries. > > From: Tim Gorman <[EMAIL PROTECTED]> > Date: 2003/06/05 Thu AM 03:25:36 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Snapshot too old during stress test... how to avoid > > Speaking of this trick with a txn in each RBS, I've got a shell script > on my > website (http://www.evdbt.com/tools.htm) that does just that. It is named > "prevent1555.sh" which uses a stored procedure created by a SQL script named > "prevent1555_ddl.sql"... > > As Jared mentioned, it is kind of a last resort, but it works... > > > > > on 6/4/03 4:05 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: > > > .. and if it still doesn't work, use the trick of putting a > > transaction in each of the rollback segments while the system is > > otherwise quiesced, and *do not* commit or rollback the > > transactions. > > > > This forces the rollbacks to extend if necessary, they will never > > wrap back to the first extent ( actually the second) as long as > > those transactions are not committed. > > > > It just uses a lot of disk space. Disk is cheap, right? :) > > > > Consider offlining all your production RBS and creating temporary > > ones that you can easily drop later. > > > > I've used it with SAP client copies, which will not run to > > completion without doing this, at least on our system. > > > > Jared > > > > > > > > > > > > Kirtikumar Deshpande <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 06/04/2003 09:45 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > cc: > > Subject:Re: Snapshot too old during stress test... how to avoid > > > > > > Try removing optimal setting, and shrinking RBS to the min extents > > (or even below) before running your tests. > > > > - Kirti > > > > > > --- Garry Gillies <[EMAIL PROTECTED]> wrote: > >> From memory (of a course attended looong ago), > >> Oracle recommends one rollback segment for every > >> three to four users. > >> Four rollback segments between thirty six processes > >> does seem a little mean. > >> > >> Garry > >> > >> > >> > >> > >> > >> <[EMAIL PROTECTED]> > >> Sent by: [EMAIL PROTECTED] > >> 04/06/03 13:59 > >> Please respond to ORACLE-L > >> > >> > >> To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > >> cc: > >> Subject: Snapshot too old during stress test... how to > > avoid > >> > >> > >> Im testing worst case scenarios right now. So Im doing batch > >> updates,inserts,deletes and 'create table as' from a staging tablespace > > of > >> approximately 5GBs to a master tablespace of approximately 11GBs. > >> > >> Ive got my job queue processes set to 36 and Im running 36 at a
Re: Re: Snapshot too old during stress test... how to avoid
nope. My process is rather simple. A flag comes in... either we do a create table as, drop the old table, and create the indexes based on the data in the stage tablespace or, we do insert select Commit; update commit; delete commit; The snapshot too old is occuring during the process of create table as, all the data is getting created in the new table, then Im getting a snapshot too old. I didnt have error handling there to know EXACTLY when its happening, but right after I do the create table as, I have a query of the data dictionary, then I drop the old table. The old table is not being dropped and the new table is being created. Im at a loss. > > From: "Daniel W. Fink" <[EMAIL PROTECTED]> > Date: 2003/06/05 Thu AM 10:55:05 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Snapshot too old during stress test... how to avoid > > Are you hitting ORA-1555 because of a fetch across commit? > > [EMAIL PROTECTED] wrote: > > >why would removing optimal setting help with snapshot too old? > > > >what I dont understand is that each of my DML transactions are independent of each > >other. They query and perform DML on different tables. None of them overlap. The > >only time they overlap is when they hit the data dictionary for some brief queries. > > > > > >>From: Tim Gorman <[EMAIL PROTECTED]> > >>Date: 2003/06/05 Thu AM 03:25:36 EDT > >>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >>Subject: Re: Snapshot too old during stress test... how to avoid > >> > >>Speaking of this trick with a txn in each RBS, I've got a shell script on my > >>website (http://www.evdbt.com/tools.htm) that does just that. It is named > >>"prevent1555.sh" which uses a stored procedure created by a SQL script named > >>"prevent1555_ddl.sql"... > >> > >>As Jared mentioned, it is kind of a last resort, but it works... > >> > >> > >> > >> > >>on 6/4/03 4:05 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: > >> > >> > >> > >>>.. and if it still doesn't work, use the trick of putting a transaction > >>>in > >>>each of the rollback segments while the system is otherwise quiesced, > >>>and *do not* commit or rollback the transactions. > >>> > >>>This forces the rollbacks to extend if necessary, they will never wrap > >>>back to the first extent ( actually the second) as long as those > >>>transactions > >>>are not committed. > >>> > >>>It just uses a lot of disk space. Disk is cheap, right? :) > >>> > >>>Consider offlining all your production RBS and creating temporary ones > >>>that you can easily drop later. > >>> > >>>I've used it with SAP client copies, which will not run to completion > >>>without > >>>doing this, at least on our system. > >>> > >>>Jared > >>> > >>> > >>> > >>> > >>> > >>>Kirtikumar Deshpande <[EMAIL PROTECTED]> > >>>Sent by: [EMAIL PROTECTED] > >>>06/04/2003 09:45 AM > >>>Please respond to ORACLE-L > >>> > >>> > >>> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >>> cc: > >>> Subject:Re: Snapshot too old during stress test... how to avoid > >>> > >>> > >>>Try removing optimal setting, and shrinking RBS to the min extents (or > >>>even below) before running > >>>your tests. > >>> > >>>- Kirti > >>> > >>> > >>>--- Garry Gillies <[EMAIL PROTECTED]> wrote: > >>> > >>> > >>>>From memory (of a course attended looong ago), > >>>>Oracle recommends one rollback segment for every > >>>>three to four users. > >>>>Four rollback segments between thirty six processes > >>>>does seem a little mean. > >>>> > >>>>Garry > >>>> > >>>> > >>>> > >>>> > >>>> > >>>><[EMAIL PROTECTED]> > >>>>Sent by: [EMAIL PROTECTED] > >>>>04/06/03 13:59 > >>>>Please respond to ORACLE-L > >>>> > >>>> > >>>>To: Multiple recipients of list ORACLE-L > >>&
RE: Re: Snapshot too old during stress test... how to avoid
It could be that your own process is causing the error by committing between DML operations. Take a look at metalink note 40689.1. My hazy understanding of which is as follows: - When you change a block in the buffer cache, a pointer to the rollback entry is placed in the block header. When the transaction is committed, the rollback entry is freed, but the buffer is not updated to reflect this. When the block is revisited, the process must find the rollback entry to determine whether the transaction has been committed or not. If the entry has been overwritten, then you get snapshot too old. The answer is not to commit between the insert select, update and delete, or alternatively, to force the block cleanout by doing a full scan of the table (for instance by doing a select count(*) from my_table) after each commit. Regards David Lord > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 05 June 2003 18:40 > To: Multiple recipients of list ORACLE-L > Subject: Re: Re: Snapshot too old during stress test... how to avoid > > > nope. My process is rather simple. > > A flag comes in... either we do a create table as, drop the > old table, and create the indexes based on the data in the > stage tablespace > > or, we do > insert select > Commit; > update > commit; > delete > commit; > > The snapshot too old is occuring during the process of create > table as, all the data is getting created in the new table, > then Im getting a snapshot too old. I didnt have error > handling there to know EXACTLY when its happening, but right > after I do the create table as, I have a query of the data > dictionary, then I drop the old table. The old table is not > being dropped and the new table is being created. > > Im at a loss. > > > > From: "Daniel W. Fink" <[EMAIL PROTECTED]> > > Date: 2003/06/05 Thu AM 10:55:05 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: Re: Snapshot too old during stress test... how to avoid > > > > Are you hitting ORA-1555 because of a fetch across commit? > > > > [EMAIL PROTECTED] wrote: > > > > >why would removing optimal setting help with snapshot too old? > > > > > >what I dont understand is that each of my DML transactions > are independent of each other. They query and perform DML on > different tables. None of them overlap. The only time they > overlap is when they hit the data dictionary for some brief queries. > > > > > > > > >>From: Tim Gorman <[EMAIL PROTECTED]> > > >>Date: 2003/06/05 Thu AM 03:25:36 EDT > > >>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >>Subject: Re: Snapshot too old during stress test... how to avoid > > >> > > >>Speaking of this trick with a txn in each RBS, I've got a > shell script on my > > >>website (http://www.evdbt.com/tools.htm) that does just > that. It is named > > >>"prevent1555.sh" which uses a stored procedure created by > a SQL script named > > >>"prevent1555_ddl.sql"... > > >> > > >>As Jared mentioned, it is kind of a last resort, but it works... > > >> > > >> > > >> > > >> > > >>on 6/4/03 4:05 PM, [EMAIL PROTECTED] at > [EMAIL PROTECTED] wrote: > > >> > > >> > > >> > > >>>.. and if it still doesn't work, use the trick of > putting a transaction > > >>>in > > >>>each of the rollback segments while the system is > otherwise quiesced, > > >>>and *do not* commit or rollback the transactions. > > >>> > > >>>This forces the rollbacks to extend if necessary, they > will never wrap > > >>>back to the first extent ( actually the second) as long as those > > >>>transactions > > >>>are not committed. > > >>> > > >>>It just uses a lot of disk space. Disk is cheap, right? :) > > >>> > > >>>Consider offlining all your production RBS and creating > temporary ones > > >>>that you can easily drop later. > > >>> > > >>>I've used it with SAP client copies, which will not run > to completion > > >>>without > > >>>doing this, at least on our system. > > >>> > > >>>Jared > > >>> > > >>> > > >>> > > >>> > > >>> > > >>>Kirtikumar Des
Where are the scripts located to create the SCOTT test objects?
I have a user that is using the SCOTT test tables on one of our dev databases. He is apparently missing the DEPT table. Where are the scripts that create the SCOTT tables? I tried looking through the on-line documentation and Metalink to no avail. Can anyone point me in the right direction? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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).
Re: my messages are not getting to list. trying to test
Your message was received by the list. At 10:41 AM 11/25/02 -0800, you wrote: ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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).
Exporting stats for a production server to a dev/test server
Hi Can anyone give feedback good or bad on the dbms_stats feature of exporting statistics. Is there any gotcha's or does it work well Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom "The People, The Experience, The Vision" = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- 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: OCP Test on Oracle 8i New features Upgrade : study Materials,
I just happen to have a book published by Coriolis called the Oracle 8 to 8i Exam Cram Guide... You can find it on Amazon, bookpool, etc... 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: Tuesday, March 12, 2002 10:59 AM To: Multiple recipients of list ORACLE-L URLs, Sample questions Greetings All, Could you please send me the name & author of the books, or any sample questions for Oracle 8i new features upgrade test. For 7.3 and 8 upgrade tests, I used DBA Certification Exam guide by Couchman and it was helpful. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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).
RE: Where are the scripts located to create the SCOTT test objects?
Cherie: Check $ORACLE_HOME/sqlplus/demo/demobld.sql --Kevin -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 8:25 AM To: Multiple recipients of list ORACLE-L I have a user that is using the SCOTT test tables on one of our dev databases. He is apparently missing the DEPT table. Where are the scripts that create the SCOTT tables? I tried looking through the on-line documentation and Metalink to no avail. Can anyone point me in the right direction? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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: Kevin Tsay 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: Where are the scripts located to create the SCOTT test objects?
Kevin, Thanks. Just what the Dr. ordered. Cherie "Kevin Tsay" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 2.mfn.com> cc: Sent by: Subject: RE: Where are the scripts located to create the SCOTT [EMAIL PROTECTED] test objects? 01/21/03 01:31 PM Please respond to ORACLE-L Cherie: Check $ORACLE_HOME/sqlplus/demo/demobld.sql --Kevin -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 8:25 AM To: Multiple recipients of list ORACLE-L I have a user that is using the SCOTT test tables on one of our dev databases. He is apparently missing the DEPT table. Where are the scripts that create the SCOTT tables? I tried looking through the on-line documentation and Metalink to no avail. Can anyone point me in the right direction? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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: Kevin Tsay 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).
Re: Where are the scripts located to create the SCOTT test objects?
In rdbms/admin there's a file called scott.sql, there's also a utlsampl.sql in the same place. [EMAIL PROTECTED]@fatcity.com on 01/21/2003 11:24:32 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: I have a user that is using the SCOTT test tables on one of our dev databases. He is apparently missing the DEPT table. Where are the scripts that create the SCOTT tables? I tried looking through the on-line documentation and Metalink to no avail. Can anyone point me in the right direction? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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: 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: Where are the scripts located to create the SCOTT test object
Hi Cherie, May be this is what you mean. Create table Dept (DEPTNO NOT NULL NUMBER(2), DNAME VARCHAR2(14), LOC VARCHAR2(13)) Rgrds, Sony > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, January 21, 2003 11:25 PM > To: Multiple recipients of list ORACLE-L > Subject: Where are the scripts located to create the SCOTT test > objects? > > > I have a user that is using the SCOTT test tables on one of our dev > databases. He is apparently missing the DEPT table. > > Where are the scripts that create the SCOTT tables? I tried looking > through the on-line documentation and Metalink to no avail. Can anyone > point me in the right direction? > > Thanks, > > Cherie Machler > Oracle DBA > Gelco Information Network > > -- > 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: Sony kristanto 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: Where are the scripts located to create the SCOTT test object
You can re-create all the tables using the script SCOTT.SQL in \rdbms\admin Sony kristanto <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/22/03 07:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Where are the scripts located to create the SCOTT test object Hi Cherie, May be this is what you mean. Create table Dept (DEPTNO NOT NULL NUMBER(2), DNAME VARCHAR2(14), LOC VARCHAR2(13)) Rgrds, Sony > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, January 21, 2003 11:25 PM > To: Multiple recipients of list ORACLE-L > Subject: Where are the scripts located to create the SCOTT test > objects? > > > I have a user that is using the SCOTT test tables on one of our dev > databases. He is apparently missing the DEPT table. > > Where are the scripts that create the SCOTT tables? I tried looking > through the on-line documentation and Metalink to no avail. Can anyone > point me in the right direction? > > Thanks, > > Cherie Machler > Oracle DBA > Gelco Information Network > > -- > 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: Sony kristanto 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: Where are the scripts located to create the SCOTT test object
%Oralce_home%\sqlplus\demo\demobld.sql HTH nirmal. -Original Message- Sent: Wednesday, January 22, 2003 5:29 AM To: Multiple recipients of list ORACLE-L Hi Cherie, May be this is what you mean. Create table Dept (DEPTNO NOT NULL NUMBER(2), DNAME VARCHAR2(14), LOC VARCHAR2(13)) Rgrds, Sony > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, January 21, 2003 11:25 PM > To: Multiple recipients of list ORACLE-L > Subject: Where are the scripts located to create the SCOTT test > objects? > > > I have a user that is using the SCOTT test tables on one of our dev > databases. He is apparently missing the DEPT table. > > Where are the scripts that create the SCOTT tables? I tried looking > through the on-line documentation and Metalink to no avail. Can anyone > point me in the right direction? > > Thanks, > > Cherie Machler > Oracle DBA > Gelco Information Network > > -- > 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: Sony kristanto 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: Nirmal Kumar Muthu Kumaran 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: Exporting stats for a production server to a dev/test server
We just used it with great success to test our new analyze strategy. You can label each set of stats, and quickly switch between different analyze levels. Store your old stats first and you can always fall back if necessary. Jack --- [EMAIL PROTECTED] wrote: > Hi > > Can anyone give feedback good or bad on the > dbms_stats feature of > exporting statistics. Is there any gotcha's or does > it work well > > Cheers > > > -- > = > Peter McLarty E-mail: > [EMAIL PROTECTED] > Technical ConsultantWWW: > http://www.mincom.com > APAC Technical Services Phone: +61 (0)7 3303 > 3461 > Brisbane, AustraliaMobile: +61 (0)402 094 > 238 > Facsimile: +61 (0)7 3303 > 3048 > = > A great pleasure in life is doing what people say > you cannot do. > > - Walter Bagehot (1826-1877 British Economist) > = > Mincom "The People, The Experience, The Vision" > > = > > This transmission is for the intended addressee only > and is confidential > information. If you have received this transmission > in error, please > delete it and notify the sender. The contents of > this e-mail are the > opinion of the writer only and are not endorsed by > the Mincom Group of > companies unless expressly stated otherwise. > > > -- > 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). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey 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: Exporting stats for a production server to a dev/test server
I've used 1 month ago on Oracle817 without any problem. --- [EMAIL PROTECTED] a écrit : > Hi > > Can anyone give feedback good or bad on the > dbms_stats feature of > exporting statistics. Is there any gotcha's or does > it work well > > Cheers > > > -- > = > Peter McLarty E-mail: > [EMAIL PROTECTED] > Technical ConsultantWWW: > http://www.mincom.com > APAC Technical Services Phone: +61 (0)7 3303 > 3461 > Brisbane, AustraliaMobile: +61 (0)402 094 > 238 > Facsimile: +61 (0)7 3303 > 3048 > = > A great pleasure in life is doing what people say > you cannot do. > > - Walter Bagehot (1826-1877 British Economist) > = > Mincom "The People, The Experience, The Vision" > > = > > This transmission is for the intended addressee only > and is confidential > information. If you have received this transmission > in error, please > delete it and notify the sender. The contents of > this e-mail are the > opinion of the writer only and are not endorsed by > the Mincom Group of > companies unless expressly stated otherwise. > > > -- > 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Exporting stats for a production server to a dev/test server
Jack, Were your old statistics generated with the ANALYZE command? If yes, were you able to export ALL of the old statistics with the export option of DBMS_STATS before you actually analyzed with DBMS_STATS for the first time? If yes, after exporting them, did you delete the old statistics using the delete option of ANALYZE command before gathering new statistics using DBMS_STATS? Thanks, Cherie Machler Oracle DBA Gelco Information Network Jack Silvey ahoo.com>cc: Sent by: Subject: Re: Exporting stats for a production server to a dev/test [EMAIL PROTECTED]server om 07/07/02 08:58 PM Please respond to ORACLE-L We just used it with great success to test our new analyze strategy. You can label each set of stats, and quickly switch between different analyze levels. Store your old stats first and you can always fall back if necessary. Jack --- [EMAIL PROTECTED] wrote: > Hi > > Can anyone give feedback good or bad on the > dbms_stats feature of > exporting statistics. Is there any gotcha's or does > it work well > > Cheers > > > -- > = > Peter McLarty E-mail: > [EMAIL PROTECTED] > Technical ConsultantWWW: > http://www.mincom.com > APAC Technical Services Phone: +61 (0)7 3303 > 3461 > Brisbane, AustraliaMobile: +61 (0)402 094 > 238 > Facsimile: +61 (0)7 3303 > 3048 > = > A great pleasure in life is doing what people say > you cannot do. > > - Walter Bagehot (1826-1877 British Economist) > = > Mincom "The People, The Experience, The Vision" > > = > > This transmission is for the intended addressee only > and is confidential > information. If you have received this transmission > in error, please > delete it and notify the sender. The contents of > this e-mail are the > opinion of the writer only and are not endorsed by > the Mincom Group of > companies unless expressly stated otherwise. > > > -- > 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). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey 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: [E
Re: Exporting stats for a production server to a dev/test server
Cherie, Great name. Our initial stats were generated with the ANALYZE command. We did export all the stats with the dbms_stats - one parameter of the GATHER_TABLE_STATS procedure is CASCADE, which picks up the index and column stats too. Please test first on your own system to make sure this is true for your version and setup. We did not delete the stats before doing the new, what we did was this: 1) export the old stats 2) analyze using a new sample, cascade, with histos 3) export the new stats (with a new label) 4) test, reimport the old and new stats as necessary Do this quick test to show yourself what it can do: a) create table tester.statstest as select * from dba_tables; b) create index tester.statstestidx on statstest(table_name); c) analyze table tester.statstest estimate statistics sample 1 percent for table for all indexes for all columns size 254; d) create the stats holding table in the tester schema using DBMS_STATS.CREATE_STAT_TABLE('tester','stats','tsuser01') e) export the stats using DBMS_STATS.EXPORT_TABLE_STATS('tester','statstest',null,'stats','1pcttest',true,null); f) select * from tester.stats to see what is stored g) analyze table tester.statstest delete statistics; h) import the stats using DBMS_STATS.IMPORT_TABLE_STATS('tester','statstest',null,'stats','1pcttest',true,null); i) select * from dba_tables, dba_indexes, dba_tab_histograms to see what was imported You can store multiple versions of stats for the same table with different lables ('1pctest' in the example) but if you try to store stats with the same label it will overwrite. We did have some data dictionary locking issues trying to import multiple partitions of the same table at the same time, but our db has suspect dd issues anyway, so this might just be a feature of our system. hth, Jack --- [EMAIL PROTECTED] wrote: > > Jack, > > Were your old statistics generated with the ANALYZE > command? If yes, were > you able to export ALL of the old statistics with > the export option of > DBMS_STATS before you actually analyzed with > DBMS_STATS for the first time? > If yes, after exporting them, did you delete the old > statistics using the > delete option of ANALYZE command before gathering > new statistics using > DBMS_STATS? > > Thanks, > > Cherie Machler > Oracle DBA > Gelco Information Network > > > > > > Jack Silvey > > > Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > ahoo.com>cc: > > > Sent by: Subject: > Re: Exporting stats for a production server to a > dev/test > [EMAIL PROTECTED]server > > > om > > > > > > > > > 07/07/02 08:58 > > > PM > > > Please respond > > > to ORACLE-L > > > > > > > > > > > > > We just used it with great success to test our new > analyze strategy. You can label each set of stats, > and > quickly switch between different analyze levels. > Store > your old stats first and you can always fall back if > necessary. > > > Jack > > > --- [EMAIL PROTECTED] wrote: > > Hi > > > > Can anyone give feedback good or bad on the > > dbms_stats feature of > > exporting statistics. Is there any gotcha's or > does &g
test - text file attachment / Re: ORACLE-L Digest -- Volume 2002, Number 123
what is factotum? ORACLE-L Digest -- Volume 2002, Number 123 > -- > > From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> > Date: Thu, 2 May 2002 08:09:14 -0400 > Subject: RE: ITS THE PHB, STPID (was: anti-virus spam) > > what - you changing careers - trying out for Denis Miller's show? > TEST TEXT FILE ATTACHMENT FOR ORACLE-L ANTI-VIRUS SPAMMERS
QDBA has been banished from my test server (was RE: 8.1.6 upgrade )
Well, that was gruesome. I couldn't log in as QDBA, so forget about using dbms_job. I ended up revoking CONNECT, RESOURCE, and every other role it had. Then I did a shutdown abort, startup restrict. QDBA's job was still listed. I took the risk of issuing a DELETE statement against dba_jobs, and against the job$ view. I don't know if that did anything useful but at least there were no rows returned. I granted connect, resource back to qdba. I bounced the database again. Then I managed to log in as QDBA, and as that user I manually (well, using SQL scripts) dropped all of this user's objects. Then I logged in as SYSTEM and I quite enjoyed deleting this beast from my test machine. Obviously when you issue a DROP USER command, Oracle doesn't do anything to clean up that user's jobs - it just hangs. Live and learn, now I know what to do if this happens again - use a liberal does of REVOKE statements, GRANT again, then log on as that user. Drop everything that user owns manually, because DROP USER is too lazy to do it. Once you have done DROP USER's job for it, you can issue the DROP USER command. Strangely it still took 8i at least ten seconds to drop the user, even though it didn't own anything. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to test whether a text file exists in Dev6i on client machine
Hi Gurus I need to test whether a text file 'a.txt' exists in the default oracle reports directory on client machine and print at the end of the report? I can use text_io but I don't seem to see a test for file existence. Appreciate any help. Have a great weekend. Regards Shiva Baswannappa Life Sciences Business UnitDigital Consulting & Software Services, Inc._↗ Phone: 281.243.2658Fax: 281.243.2504Web: http://www.dcss.com If the reader of this e-mail is not an intended recipient, you have received this e-mail in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and permanently delete the copy you received. Thank you.
Study Materials, URLs, Sample questions for Oracle 8i New features Upgrade OCP Test
Greetings All, Could you please send me the name & author of the books, or any sample questions for Oracle 8i new features upgrade test. For 7.3 and 8 upgrade tests, I used DBA Certification Exam guide by Couchman and it was helpful. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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).
OCP Test on Oracle 8i New features Upgrade : study Materials, URLs, Sample questions
Greetings All, Could you please send me the name & author of the books, or any sample questions for Oracle 8i new features upgrade test. For 7.3 and 8 upgrade tests, I used DBA Certification Exam guide by Couchman and it was helpful. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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).
/TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based ODTUG archives now available
/TEST/IDIOT/ On 15 May 2001, at 11:16, Bruce Bergman wrote: Date sent: Tue, 15 May 2001 11:16:15 -0800 To: Multiple recipients of list ODTUG-DEV2K-L <[EMAIL PROTECTED]> > I have just finished making some changes to the ListGuru web-based archive > facility (http://www.fatcity.com/ListGuru), if anyone would like to try it > out. There are about 180 people who have signed up for the first beta, so I > know some of you should be able to give it a whirl. Much of what has been > fixed or changed is in response to the comments from the first beta testers. > > If you'd like to join this beta test, please go to > http://www.fatcity.com/ListGuru/SignUp.php and fill out the form. ... > What still is broken: > > - browsing digests based on year > - reading today's digest when it contains HTML > - viewing table of contents is improperly formatted > > Please understand that not all of the site is currently working. I'd > recommend you stick to the "Search" capability and try to exercise that > aspect. Feedback would be appreciated on what could be better, nicer, more > useful, etc. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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).
OT RE: /TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based ODTUG archive
How about SAVANT? or moron imbecile vegetable || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 15, 2001 6:25 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: /TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based || ODTUG archives || now available || || || a search on "IDIOT" turned up nothing. || || || Date sent: Tue, 15 May 2001 12:10:53 -0800 || To: Multiple recipients of list ORACLE-L || <[EMAIL PROTECTED]> || || > /TEST/IDIOT/ || || ... || || > > ... (http://www.fatcity.com/ListGuru) || || > > Please understand that not all of the site is currently || working. I'd || > > recommend you stick to the "Search" capability and try || to exercise that || > > aspect. Feedback would be appreciated on what could be || better, nicer, more || > > useful, etc. || > || > ... || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Eric D. Pierce || 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: Mohan, Ross 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: OCP Test on Oracle 8i New features Upgrade : study Materials, URLs, Sample questions
Try Amazon Oracle 8 to 8i Upgrade Exam Cram (Exam: 1Z0-020) http://www.amazon.com/exec/obidos/ASIN/157610737X/qid=1015956097/sr=8-1/ref=sr_8_7_1/104-0428629-4654355 Also http://studyguides.cramsession.com/cramsession/oracle/Oracle8iupgrade/default.asp -Joe --- "Mandal, Ashoke" <[EMAIL PROTECTED]> wrote: > Greetings All, > > Could you please send me the name & author of the books, or any > sample questions for Oracle 8i new features upgrade test. > > For 7.3 and 8 upgrade tests, I used DBA Certification Exam guide > by Couchman and it was helpful. > > Thanks, > Ashoke > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mandal, Ashoke > 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). __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: /TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based ODTUG archives now available
a search on "IDIOT" turned up nothing. Date sent: Tue, 15 May 2001 12:10:53 -0800 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > /TEST/IDIOT/ ... > > ... (http://www.fatcity.com/ListGuru) > > Please understand that not all of the site is currently working. I'd > > recommend you stick to the "Search" capability and try to exercise that > > aspect. Feedback would be appreciated on what could be better, nicer, more > > useful, etc. > > ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: OT RE: /TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based ODTUG arc
Could you please be more PRECISE? -Original Message- Sent: Tuesday, May 15, 2001 7:12 PM To: Multiple recipients of list ORACLE-L archive How about SAVANT? or moron imbecile vegetable || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 15, 2001 6:25 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: /TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based || ODTUG archives || now available || || || a search on "IDIOT" turned up nothing. || || || Date sent: Tue, 15 May 2001 12:10:53 -0800 || To: Multiple recipients of list ORACLE-L || <[EMAIL PROTECTED]> || || > /TEST/IDIOT/ || || ... || || > > ... (http://www.fatcity.com/ListGuru) || || > > Please understand that not all of the site is currently || working. I'd || > > recommend you stick to the "Search" capability and try || to exercise that || > > aspect. Feedback would be appreciated on what could be || better, nicer, more || > > useful, etc. || > || > ... || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Eric D. Pierce || 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: Mohan, Ross 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: Henry Poras 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).
/test - dumb & dumber/ Re: error when creating a BIG FREAKING ATTACHMENT TO THE LIST
trying again, missing attachment 1st time??? word2000 doc renmaed w/ ".sql" extension > /TEST/ > > BINARY ATTACHMENTS NOT TESTED IF NAMED WITH ".sql" FILE EXTENSION? > > Date sent:Tue, 10 Apr 2001 06:27:28 -0800 > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > From: [EMAIL PROTECTED] > Subject: error when creating a base > > > > > --0__=K4vD0otYX31qTIYWTP8zXD3R4VI6AyprM56NaK0KG46TUJy3pzPGxQBf > > Content-type: text/plain; charset=us-ascii > > Content-Disposition: inline > > > > > > > > while running the script cr0_base_ADX.sql, we get the error : > > cre_base_ADX.log... > > Any idea ??? > > > > AIX Version : 4.3.2.0 > > Oracle version : 7.2.3 > > > > > > Thanks !! > > > > L.A. > > > > (See attached file: cr0_base_ADX.sql)(See attached file: cre_base_ADX.log) > > > > > > > > --0__=K4vD0otYX31qTIYWTP8zXD3R4VI6AyprM56NaK0KG46TUJy3pzPGxQBf > > Content-type: application/octet-stream; > > name="cr0_base_ADX.sql" > > Content-Disposition: attachment; filename="cr0_base_ADX.sql" > > Content-Transfer-Encoding: base64 > > > > Y29ubmVjdCBpbnRlcm5hbApzZXQgZWNobyBvbgpzdGFydHVwIG5vbW91bnQgcGZpbGU9L2hvbWUv > > b3JhZG9uaXgvZGJzL2luaXRBRFhfMC5vcmEKY3JlYXRlIGRhdGFiYXNlIEFEWCAKICAgIG1heGlu > > c3RhbmNlcyAxCiAgICBtYXhsb2dmaWxlcyAgMTYKICAgIG1heGRhdGFmaWxlcyA1MAogICAgY2hh > > ... > > > UkEtMDc0Mjk6IHNtc2dzZzogc2htZ2V0KCkgZmFpbGVkIHRvIGdldCBzZWdtZW50LgpJQk0gQUlY > > IFJJU0MgU3lzdGVtLzYwMDAgRXJyb3I6IDI6IE5vIHN1Y2ggZmlsZSBvciBkaXJlY3RvcnkKU1FM > > REJBPiBTUUxEQkE+IFNRTCpEQkEgY29tcGxldGUuCg== > > > > --0__=K4vD0otYX31qTIYWTP8zXD3R4VI6AyprM56NaK0KG46TUJy3pzPGxQBf-- > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > ... > renamed-word2000.sql
Re [30k]: /test - dumb & dumber/ Re: error when creating a BIG FREAKING ATTACHMENT TO THE LIST
Jared, Has Bruce seen this issue? Looks like attached binary files that have their file extension changed to ".sql" will not be caught by the list's filters. regards, ep > Received: from SpoolDir by DSS_486 (Mercury 1.46); 11 Apr 01 12:08:01 -0700 > Return-path: <[EMAIL PROTECTED]> > Received: from cliff.csus.edu (130.86.82.251) by sswdserver.sswd.csus.edu (Mercury >1.46) with ESMTP; > 11 Apr 01 12:07:58 -0700 > Received: from cliff.csus.edu (localhost [127.0.0.1]) > by cliff.csus.edu with ESMTP id f3BJ7wC05609; > Wed, 11 Apr 2001 12:07:58 -0700 (PDT) > Received: from csus.edu (csus.edu [130.86.90.1]) > by cliff.csus.edu with ESMTP id f3BJ7v105605; > Wed, 11 Apr 2001 12:07:57 -0700 (PDT) > Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199]) > by csus.edu with ESMTP id MAA24894; > Wed, 11 Apr 2001 12:07:57 -0700 (PDT) > Received: from fatcity.UUCP (uucp@localhost) > by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id MAA07761; > Wed, 11 Apr 2001 12:05:12 -0700 (PDT) > Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002E7446; Wed, 11 >Apr 2001 11:11:19 -0800 > Message-ID: <[EMAIL PROTECTED]> > Date: Wed, 11 Apr 2001 11:11:19 -0800 > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > X-Comment: Oracle RDBMS Community Forum > X-Sender: "Eric D. Pierce" <[EMAIL PROTECTED]> > Sender: [EMAIL PROTECTED] > Reply-To: [EMAIL PROTECTED] > Errors-To: [EMAIL PROTECTED] > From: "Eric D. Pierce" <[EMAIL PROTECTED]> > Subject: /test - dumb & dumber/ Re: error when creating a BIG FREAKING ATTACHMENT TO >THE LIST > Organization: Fat City Network Services, San Diego, California > X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman > Precedence: bulk > Mime-Version: 1.0 > Content-type: Multipart/Mixed; boundary=Message-Boundary-5637 > X-PMFLAGS: 571998336 0 1 Y0B633.CNM > > > > --Message-Boundary-5637 > Content-type: text/plain; charset=US-ASCII > Content-description: Mail message body > Content-Transfer-Encoding: 7BIT > > trying again, missing attachment 1st time??? > > word2000 doc renmaed w/ ".sql" extension > > > > /TEST/ > > > > BINARY ATTACHMENTS NOT TESTED IF NAMED WITH ".sql" FILE EXTENSION? > > > > Date sent: Tue, 10 Apr 2001 06:27:28 -0800 > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> From:[EMAIL PROTECTED] > > Subject:error when creating a base > > > > > > > > --0__=K4vD0otYX31qTIYWTP8zXD3R4VI6AyprM56NaK0KG46TUJy3pzPGxQBf > > > Content-type: text/plain; charset=us-ascii > > > Content-Disposition: inline > > > > > > > > > > > > while running the script cr0_base_ADX.sql, we get the error : > > > cre_base_ADX.log... > > > Any idea ??? > > > > > > AIX Version : 4.3.2.0 > > > Oracle version : 7.2.3 > > > > > > > > > Thanks !! > > > > > > L.A. > > > > > > (See attached file: cr0_base_ADX.sql)(See attached file: > > > cre_base_ADX.log) > > > > > > > > > > > > --0__=K4vD0otYX31qTIYWTP8zXD3R4VI6AyprM56NaK0KG46TUJy3pzPGxQBf > > > Content-type: application/octet-stream; > > > name="cr0_base_ADX.sql" > > > Content-Disposition: attachment; filename="cr0_base_ADX.sql" > > > Content-Transfer-Encoding: base64 > > > > > > Y29ubmVjdCBpbnRlcm5hbApzZXQgZWNobyBvbgpzdGFydHVwIG5vbW91bnQgcGZpbGU9L2 > > > hvbWUv > > > b3JhZG9uaXgvZGJzL2luaXRBRFhfMC5vcmEKY3JlYXRlIGRhdGFiYXNlIEFEWCAKICAgIG > > > 1heGlu > > > c3RhbmNlcyAxCiAgICBtYXhsb2dmaWxlcyAgMTYKICAgIG1heGRhdGFmaWxlcyA1MAogIC > > > AgY2hh > > > > ... > > > > > UkEtMDc0Mjk6IHNtc2dzZzogc2htZ2V0KCkgZmFpbGVkIHRvIGdldCBzZWdtZW50LgpJQk > > > 0gQUlY > > > IFJJU0MgU3lzdGVtLzYwMDAgRXJyb3I6IDI6IE5vIHN1Y2ggZmlsZSBvciBkaXJlY3Rvcn > > > kKU1FM REJBPiBTUUxEQkE+IFNRTCpEQkEgY29tcGxldGUuCg== > > > > > > --0__=K4vD0otYX31qTIYWTP8zXD3R4VI6AyprM56NaK0KG46TUJy3pzPGxQBf-- > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: > > > INET: [EMAIL PROTECTED] > > > > ... > > > > > > --Message-Boundary-5637 > Content-type: Application/Octet-stream; name="renamed-word2000.sql"; > type=Unknown Content-disposition: attachment; > fi