Re: performance
> I didn't mean to be so stiff on the reply -- sorry for that... You are excused... Just kidding. :-) I didn't mean that either - my apologies. And you may be very right on the political perspective. What's done is done. It could be not the right time for late general setups, but analysis is always a good choice. > The most common issues in the redo stream are certainly sizing and I/O. > Yes, it can be quite cut-and-dried. But Ravi merely mentioned that > "performance was slower" after enabling ARCHIVELOG mode and for all we know, > it truly may have nothing to do with the redo logging stream whatsoever. It > could be something else (i.e. bad SQL that someone recently slammed in at > the same time) that neither Ravi (nor we) are aware of. It could be > anything at all... > > So, making changes in the complete absence of information can easily end up > with the following scenario: Ravi makes the recommended changes (i.e. add > redo log groups, change group sizes, pester SysAdmins to create new > file-systems to separate online from archived destinations, etc), all with > no impact on performance. Thus, his credibility is harmed, if not totally > destroyed. Happens all the time...(8 million stories in the naked city)... > > Better to look first, understand exactly what is happening, and act on real > information. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, July 01, 2002 7:53 AM > > > > I've assumed, that nothing changed beside ARCHIVE LOG mode. "when Our DB > is > > non-archive mode that was ok,when we moved to Archive, it is dead slow" > > This directs to the question of I/O with archiving redo logs in first > turn. > > Doesn't it? What may be other direct performance issues of ARCHIVE LOG > mode? > > I admit that there is not enough information, which may easily make me > > mistaken. However, there should be some general setup for archive log > mode, > > and that's what I gave. General setup should be made before moving to > > archivelog mode and taken as basis for further tuning. > > > > Alexandre > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Monday, July 01, 2002 2:43 PM > > > > > > > Alexandre, > > > > > > I beg to differ. > > > > > > You have assumed, in the complete absence of any information, that he > has > > an > > > I/O problem. He might. He also might not. He should look first, > before > > > leaping. > > > > > > -Tim > > > > > > - Original Message - > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > Sent: Monday, July 01, 2002 1:53 AM > > > > > > > > > > Ravi, > > > > > > > > Make sure you have at least 5-10 redo log groups. That's depends on > your > > > > workload. You also may need to increase their size. Think how much log > > > info > > > > your database can generate and size your logs that it would be enough > > for > > > 10 > > > > mins at least. (Of course that would be pretty rough estimation) > > > > Also make sure you put redo logs and arcived redo logs on differend > > disks! > > > > So that's for start. After, you may follow advice given in Tim's > reply. > > > > > > > > hth > > > > Alexandre > > > > - Original Message - > > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > > Sent: Saturday, June 29, 2002 9:13 PM > > > > > > > > > > > > > Dear All, > > > > > > > > > > Can any one please give me some hints or tips when we > > > > > move to archive mode? when Our DB is non-archive mode > > > > > that was ok,when we moved to Archive, it is dead slow. > > > > > > > > > > Obviosuly archive mode performance is slow, is there > > > > > any other precations to be taken care? > > > > > > > > > > Thanks for your help. > > > > > Cheers, > > > > > Ravi > > > > > > > > > > __ > > > > > Do You Yahoo!? > > > > > Everything you'll ever need on one web page > > > > > from News and Sport to Email and Music Charts > > > > > http://uk.my.yahoo.com > > > > > -- > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > > -- > > > > > Author: =?iso-8859-1?q?Nalla=20Ravi?= > > > > > 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 > > > > --
Re: Oracle client won't install on Windows 2000
Check if the processor is P4. If so , you must replace the symcjit.dll and jvm.dll with the ones in 9i CD. Bunyamin - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 12:03 AM > One of our developers is having a problem installing Oracle Client > (8.1.7). When he inserts the CD the initial screen comes up with the > options to Install/Deinstall products, Explore CD, Browse Documentation. > When he clicks on Install/Deinstall, however the Oracle Installer never > comes > up. > > Any ideas what might be wrong? > > Thanks > Peter Schauss > Northrop Grumman Corporation > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Schauss, Peter > 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: Bunyamin Karadeniz 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: system event waits
It was talked on the list and had been said that 1% of performance it affects nearly as I remember. Bunyamin - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 4:23 AM > Do you guys think making times statistic =true has any performance impact . > Are there any other considerations ? > > -Bp > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, July 01, 2002 12:53 PM > > > > > Depending on the version of the database, timed_statistics > > > may be dynamic > > > and > > > not require a database bounce. > > > > True - but the timing values are meaningless unless the counters > > (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets the > > counters and switches on timing at the same time I wouldn't recommend > > using the time values otherwise. > > > > John Kanagaraj > > Oracle Applications DBA > > DBSoft Inc > > (W): 408-970-7002 > > > > Want to know about a carpenter who built a bridge with two sticks and > three > > nails? Write me for details! > > > > ** The opinions and statements above are entirely my own and not those of > my > > employer or clients ** > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: John Kanagaraj > > 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: BigP > 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: Bunyamin Karadeniz 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: the ora certified masters cert, yet again
Personal attacks certainly don't belong here. Best not do it at all. Jared On Wednesday 26 June 2002 19:28, Rachel Carmichael wrote: > YO! JARED! has this gotten off-topic yet? since when is "picking on > Rachel" part of the on topic list??? > > --- Joe Testa <[EMAIL PROTECTED]> wrote: > > Chris, feel blessed, she stays during all of mine and asks bizarre > > questions :), > > > > like: If 2 control files are being updated at the same time and one > > is > > on raid-5 and the other on raid 0+1, which one will be finished > > updating > > first. > > > > joe > > > > Grabowy, Chris wrote: > > >Matt, she walked out in the middle of your presentation?? > > > > > >Your lucky. She walked out of mine at the beginning, shaking her > > > > head. Oh > > > > >well... > > > > > >-Original Message- > > >Sent: Wednesday, June 26, 2002 5:40 PM > > >To: Multiple recipients of list ORACLE-L > > > > > > > > >well, if so, I'll finally get to see you present and won't have to > > > > walk > > > > >out in the middle > > > > > > > > >--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]> > > > > > >wrote: > > >>Right now, I think Susan has me from 1-2, right after > > >>lunch, but I'm not sure. The OOUG web site is a > > >>little sparse on details. > > >> > > >> > > >> > > >> > > >>Matt Adams - GE Appliances - [EMAIL PROTECTED] > > >>We have enough youth. > > >>How about a fountain of intelligence? > > >> > > >>-Original Message- > > >>Sent: Wednesday, June 26, 2002 4:50 PM > > >>To: Multiple recipients of list ORACLE-L > > >> > > >> > > >>But Mtt... you were always scheduled at either the > > >>same > > >>time *I* was presenting (trust me, I'd rather have gone to yours, I > > >>get > > >>stage fright) or when at LEAST 2 other presentations I wanted to > > > > see > > > > >>equally as much were there. > > >> > > >>Um, what time are you presenting at OOUG? My flight home is at 5, I > > >>have to leave around 2:30 or so > > >> > > >> > > >> > > >>--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]> > > >> > > >>wrote: > > >>>But Rachel, you never came to any of my > > >>>presentations! (in my best whiney voice) > > >>> > > >>>At least you'll get to see me present in July at OOUG. > > >>> > > >>> > > >>>Matt Adams - GE Appliances - [EMAIL PROTECTED] > > >>>We have enough youth. > > >>>How about a fountain of intelligence? > > >>> > > >>>-Original Message- > > >>>Sent: Wednesday, June 26, 2002 3:56 PM > > >>>To: Multiple recipients of list ORACLE-L > > >>> > > >>> > > >>>that's 'cause you present well and have knowledge > > >>> > > >>>or.. to quote one of my favorite shows: > > >>> > > >>>"he has much knowledge. we must build an altar and worship him" > > >>> > > >>>:) > > >>> > > >>>--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]> > > >>> > > >>>wrote: > > Actually, I had to miss this years (even though I was orginally > > schedule > > to give two presentations) due to a medical situation. I gave > > >>> > > >>>four > > >>> > > the > > year > > before that. > > > > > > > > Matt Adams - GE Appliances - [EMAIL PROTECTED] > > We have enough youth. > > How about a fountain of intelligence? > > > > > > -Original Message- > > Sent: Wednesday, June 26, 2002 1:09 PM > > To: Multiple recipients of list ORACLE-L > > > > > > > > OK. As the DBA Focus Area Manager for the IOUG, we do our best > > >> > > >>to > > >> > > weed out > > the fluff. If you were at IOUG this year, you should have > > >> > > >>noticed > > >> > > >>>a > > >>> > > significant reduction in the marketing fluff and more technical > > content. > > Yes, some showmanship is necessary when giving a presentation, > > >> > > >>but > > >> > > the > > content has to be there. > > > > > > > > Many people on this forum have submitted presentations to my > > >> > > >>track > > >> > > and then > > complained that they were not accepted. Let me give you some > > concrete > > numbers. This year, we received over 400 abstracts for the DBA > > >>> > > >>>track > > >>> > > alone > > and accepted only 80. If one slips through the cracks, it won't > > >> > > >>a > > >> > > second > > time. Believe me when I say that 2002 was the best > > >>> > > >>>content-organized > > >>> > > IOUG. > > > > > > > > > > Further comments? Submit an abstract for 2003 and find out!!! > > > > > > > > Thank You > > > > > > > > Stephen P. Karniotis > > > > Product Architect > > > > Compuware Corporation > > > > Direct: (248) 865-4350 > > > > Mobile: (248) 408-2918 > > === message truncated === > > > __ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FI
Re: Remove numbers from string
Yes, but not nearly as flexible as owa_pattern, and infinitely
more difficult to read.
Jared
On Monday 01 July 2002 14:33, Kirsch, Walter J (Northrop Grumman) wrote:
> Actually, it's simpler to use the trick
>
> select translate('abc123def432', '~1234567890','~') from dual;
>
> -Original Message-
> Sent: Monday, July 01, 2002 4:23 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Yes, use regular expressions via the owa_pattern package.
>
> Here's an example:
>
> declare
>tstr varchar2(100) := 'this c34ontains s0239everal 2340 numeric 882
> dig2its';
> begin
>dbms_output.put_line( tstr);
>-- remove the digits
>owa_pattern.change( tstr, '\d', '', 'g');
>dbms_output.put_line( tstr);
>-- remove the extra spaces
>owa_pattern.change( tstr, '\s+', ' ', 'g');
>dbms_output.put_line( tstr);
> end;
> /
>
> Jared
>
>
>
>
>
> Nils Höglund <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/01/2002 04:18 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
> Subject:Remove numbers from string
>
>
>
> Is there any way to remove all numbers from a string?
>
> The string might look like this: 'abc123def432'
> and I wan't it to look like this: 'abcdef'.
>
> I'm using Oracle 8.
>
>
> Thanks in advance!
--
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: Remove numbers from string
No, I checked on my 8.1.7.3 database first, and it's there. I don't have app server installed. I have the source to the package anyway. Don't know if it's wrapped now or not, but I don't think so... Nope, not wrapped: $ORACLE_HOME/rdbms/admin/pubpat.sql $ORACLE_HOME/rdbms/admin/privpat.sql Jared On Monday 01 July 2002 13:48, Grabowy, Chris wrote: > JS, > > Doesn't that owa_pattern package come from the PL/SQL Web Toolkit, which > requires that you have the Oracle App Server licensed?? > > -Original Message- > Sent: Monday, July 01, 2002 4:23 PM > To: Multiple recipients of list ORACLE-L > > > Yes, use regular expressions via the owa_pattern package. > > Here's an example: > > declare >tstr varchar2(100) := 'this c34ontains s0239everal 2340 numeric 882 > dig2its'; > begin >dbms_output.put_line( tstr); >-- remove the digits >owa_pattern.change( tstr, '\d', '', 'g'); >dbms_output.put_line( tstr); >-- remove the extra spaces >owa_pattern.change( tstr, '\s+', ' ', 'g'); >dbms_output.put_line( tstr); > end; > / > > Jared > > > > > > Nils Höglund <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/01/2002 04:18 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Remove numbers from string > > > > Is there any way to remove all numbers from a string? > > The string might look like this: 'abc123def432' > and I wan't it to look like this: 'abcdef'. > > I'm using Oracle 8. > > > Thanks in advance! -- 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: Perl for Oracle DBAs....wow.
Here's the TOC. Not too sure about an abstract, or what I can post here without upsetting O'Reilly's apple cart. I'll find out. I've put a few comments in the toolkit part of the TOC. Jared These chapter numbers are not correct. I couldn't find a corrected TOC in Word, so this is somewhat different than reality. Close enough for now though. Table of Contents Part I: Introducing Perl for Oracle 1.Perl Meets Oracle 2. Installing Perl Part II:Extending Perl 3.Perl GUI Extensions 4.Perl Web Extensions 5. Embedding Perl into Apache with mod_perl 6. Embedded Perl Web Scripting 7. Invoking the Oracle Call Interface with Oracle::OCI 8. Embedding Perl into PL/SQL Part III: The Perl Database Administration Toolkit 9. Installing the PDBA Toolkit How to install the modules and scripts, and a number of required supporting modules, for Win32 and Unix. How to setup the password server. Configurable for database, server and account names. Allows restricting some passwords to certain users. Only authenticated password server users allowed access. Passwords sent over the network via RC4 encryption. 10. Monitoring the Database with the PDBA Toolkit Monitor alert.logs from a Unix Daemon or Service, use a regular expression to catch errors of interest and mail to DBA. Monitor database connectivity. Somewhat flexibile. Configure the times for required uptime during which the DBA should be paged on a per database basis. Rotating 'on call' DBA email addresses. Optional paging of OPS, DBA Supervison, etc. Log all connectivity checks. Some other stuff. 11. Building a Database Repository with the PDBA Toolkit Store schemas in a repository. Several canned reports to report on changes that may have occurred. Store SQL and Execution Plans. Find execution paths that have changed over time. Plan on using a lot of disk space for this stuff. :) 12. Performing Routine DBA Tasks with the PDBA Toolkit Scripts for: Killing Sniped Sessions ( flame on if you must, but I kill 'em, and make it easier for others to do so as well ;) creating and dropping user accounts, including a script to create many at one time. Extract DDL sqlunldr.pl - dump a whole schema or selected tables to CSV format, generating SQL*Loader files for each. Handles BLOB's and LONG's upto 32k. One of my favorites. :) 13. Extending the PDBA Toolkit We walk through a script using most of the included modules and give detailed explanations of the code. Probably necessary for writing your own unless you have a lot of Perl experience. Worth the read just to understand how to use the Password Server modules in your Perl scripts. The command line stuff is easy, but the modules require a bit of explanation, it's kind of tricky. Part IV:Appendixes A.The Essential Guide to Perl B.The Essential Guide to Perl DBI C.The Essential Guide to Perl Regular Expressions D.The Essential Guide to Perl Data Munging Index Colophon On Monday 01 July 2002 09:20, Rodd Holman wrote: > Jared, > > What's the possibility of seeing the Table of Contents, or an abstract > of this? The title seems to have grabbed a lot of interest among us > all. > > Rodd -- 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: Perl for Oracle DBAs....wow.
Top 10? cool! On Friday 28 June 2002 13:23, Grabowy, Chris wrote: > Oh really? Everyone order their copies from bookpool.com!!! > > Let's see if we can get it to the top ten list > > -Original Message- > Sent: Friday, June 28, 2002 4:04 PM > To: Multiple recipients of list ORACLE-L > > > yeah but then Jared loses even more money on it :) > > > --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]> > > wrote: > > It's even cheaper at bookpool. > > > > http://www.bookpool.com/.x/7yyzb675nm/ss/1?qs=perl+oracle > > > > > > Matt Adams - GE Appliances - [EMAIL PROTECTED] > > We have enough youth. > > How about a fountain of intelligence? > > > > -Original Message- > > Sent: Friday, June 28, 2002 3:13 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Well I'll be dang...check out what book is now listed on Amazon... > > http://www.amazon.com/exec/obidos/ASIN/0596002106/qid=1025287397/sr=1-20/re >f > > > =sr_1_20/102-7873510-7493740 > > > > > > I wonder how much an autographed copy is... > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Grabowy, Chris > > 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: 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: Asynchronous Procedure Calls
Doesn't sound too scalable, and you had to write your own queue. :) Jared On Monday 01 July 2002 14:38, Scott Canaan wrote: > That is true, I have figured it out. dbms_job will allow the asynchronous > execution of procedures and dbms_pipe allows the communication between the > processes to occur. It works. I'm doing it now. The jobs are being > kicked off in groups of 10 and they are sending a message back to the > calling program via pipes. Each job has it's own pipe, so the main program > can keep track of who is done. Currently, I am waiting for all 10 to > complete before starting the next 10, but I may work on a way to start the > eleventh job when the first one finishes. I'm just glad that I got > something to work. > > Thank you for your help. > > [EMAIL PROTECTED] wrote: > > DBMS_JOB will not solve the problem of > > async communications. > > > > Jared > > > > "Khedr, Waleed" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 07/01/2002 12:23 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> cc: > > Subject:RE: Asynchronous Procedure Calls > > > > You need dbms_job(s) > > Also make sure you have enough background job processes to handle the > > expected maximum number of concurrent procedure calls. > > > > Regards, > > > > Waleed > > > > -Original Message- > > Sent: Monday, July 01, 2002 2:20 PM > > To: Multiple recipients of list ORACLE-L > > > > Advanced Queuing will do what you need. > > > > There are examples at otn.oracle.com > > > > Jared > > > > Scott Canaan <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 06/28/2002 01:23 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:Asynchronous Procedure Calls > > > > I have a need to call a procedure repeatedly and asynchronously. I > > am using dbms_pipe for the communication between the calling procedure > > and the called procedure and that seems to be working. What I want to > > do is call the procedure multiple times, asynchronously, from the main > > procedure. The problem is that Oracle waits for each call to complete > > before continuing processing. Is there any way to do this in PL/SQL? > > My environment is: Oracle 8.1.7.0.0, Sun Solaris 2.8. I need to do > > this in PL/SQL because it has to run through Oracle Warehouse Builder. > > > > Thank you. > > > > -- > > Scott Canaan ([EMAIL PROTECTED]) > > (585) 475-7886 > > "Life is like a sewer, what you get out of it depends on what you put > > into it" - Tom Lehrer > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Scott Canaan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Khedr, Waleed > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, Ca
Re: Questionable V$SQLAREA Statistics
Steve, Query V$SESSION_EVENT for the SID of that session. If you see the wait-event "db file scattered read" change during the query, then it truly is doing I/O, like it or not. It is more likely that the CACHE attribute is not working as you've apparently assumed it does, rather than there being a bug... --- The attribute CACHE is poorly named. It ought to properly have been called TREAT_FULL_TABLE_SCANS_LIKE_INDEXED_SCANSPERHAPS, but nobody asked... ...guess you wouldn't want to hear what I named my kids... :-) Anyway, the CACHE option only instructs Oracle not to place database blocks read during FULL table scan at the LRU (i.e. least-recently used) end of the LRU chain (causing them to fall off the chain almost immediately), but instead place them at the MRU (i.e. most-recently used) end of the LRU chain (just as with blocks read via indexed scans). So, as you can imagine, this is a long way from what I imagine you think it means: "pinning" the blocks for the table into the Buffer Cache. Rather, it only improves the chances for the table's blocks to remain in the Buffer Cache a little while longer. There is rather sparse documentation on this feature, but what there is can be found in the "SQL Reference" manual for CREATE/ALTER TABLE and in the "Tuning" guide for the CACHE and NOCACHE hints. >From Oracle8i onward, the operation of the "LRU Chain" in the Buffer Cache has changed dramatically; Craig Shallahamer has an excellent paper on the "touch-count" algorithm on his website at http://www.orapub.com. With these changes to the venerable LRU algorithm, I wouldn't be surprised if the CACHE attribute has become a complete "no-op", but I haven't tested if that has happened or not yet. I don't really care, to be honest, because it's never been a very useful feature... --- If you are trying to achieve that "pinned" effect in the Buffer Cache, the best you can do is enable the KEEP buffer pool and direct your table to that pool using CREATE/ALTER TABLE. If you size the KEEP buffer pool at 10,000 blocks and direct fewer than 10,000 blocks into it, then you can be pretty sure that you'll "cache" those objects, effectively "pinning" them into the SGA. If you oversubscribe to the KEEP buffer pool (i.e. assign more objects and blocks to the pool than buffers available), then you'll start aging things out and I/O will occur. A query like "SELECT SUM(BLOCKS) FROM DBA_TABLES WHERE BUFFER_POOL = 'KEEP'" would give you an idea, if you've analyzed the tables recently... Hope this helps -Tim - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 7:27 PM > The degree is 4 and it is cached via alter table, not the KEEP buffer. On > Oracle 8.1.7.2 on Linux RedHat 7.2 > > Thanks for clues... > > > -Original Message- > Sent: Monday, July 01, 2002 3:08 PM > To: Multiple recipients of list ORACLE-L > > > What is the degree of parallelism on this table? > > Waleed > > > -Original Message- > Sent: Monday, July 01, 2002 3:33 PM > To: Multiple recipients of list ORACLE-L > > > What version of Oracle? > > > 1) I have a 400,000 row table table which is cached. > > How has the table been cached? Alter table XXX cache? Or with a KEEP > buffer? > > -Original Message- > Sent: Monday, July 01, 2002 4:39 PM > To: Multiple recipients of list ORACLE-L > > > Here's the scene: > > 1) I have a 400,000 row table table which is cached. > > 2) I have a query against that table and no other with one column referenced > in the WHERE clause. (This column is indexed and of course I don't really > need the index since the table is cached but it's there so ho hum...) > > 3) When I run tkprof on the query it shows a full table scan ignoring the > index... that's what I want 'cause it's cached. > > 4) But when I look at V$SQLAREA the DISK_READS column is incremented. > > 5) This query is executed very often so my StatsPack report lists it as one > of the most expensive queries in terms of physical reads. > > > It appears that Oracle is counting full table scans of cached tables as > DISK_READS in V$SQLAREA. Seems like this is a bug to me 'cause it's not > really a physical disk read but is getting data from the buffers. > > Don't you think this is a bug? Has anyone seen this before? > > > Steve Orr > Looking for cache in Bozeman, Montana > -- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Orr, Steve > 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
Re: system event waits
setting it to true might have a very small performance impact. the impact of not having it set is that many of the statistics you gather for performance tuning are meaningless. If you need to get every possible millisecond of performance, turn timed_statistics on when you have problems and wait for the problem to recur or turn it on for a limited time, which will with luck encompass a relative sample of the transactions you run across --- BigP <[EMAIL PROTECTED]> wrote: > Do you guys think making times statistic =true has any performance > impact . > Are there any other considerations ? > > -Bp > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, July 01, 2002 12:53 PM > > > > > Depending on the version of the database, timed_statistics > > > may be dynamic > > > and > > > not require a database bounce. > > > > True - but the timing values are meaningless unless the counters > > (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets > the > > counters and switches on timing at the same time I wouldn't > recommend > > using the time values otherwise. > > > > John Kanagaraj > > Oracle Applications DBA > > DBSoft Inc > > (W): 408-970-7002 > > > > Want to know about a carpenter who built a bridge with two sticks > and > three > > nails? Write me for details! > > > > ** The opinions and statements above are entirely my own and not > those of > my > > employer or clients ** > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: John Kanagaraj > > 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: BigP > 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: 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: Remove numbers from string
Nils I wrote this function some time ago, when our CTI application was crashing because it found telephone numbers to dial like 1-800-Dial-a-prayer or '(800)-555 1234', so I wrote this function to replace any non-alphanumeric characters with nulls and any letters on the dial pad with the corresponding numbers. You can adapt it for yourself to suit. It runs pretty fast on even millions of rows. Cheers : Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Monday, 1 July 2002 4:18 AM To: Multiple recipients of list ORACLE-L Is there any way to remove all numbers from a string? The string might look like this: 'abc123def432' and I wan't it to look like this: 'abcdef'. I'm using Oracle 8. Thanks in advance! -- /Nils Höglund, Naqua KB E-mail: [EMAIL PROTECTED] Web:http://www.naqua.se/ Home Phone: +46 (0)18 30 09 19 Cellular Phone: +46 (0)709 91 97 65 Address:Nya Valsätrav. 26 B SE-756 46 Uppsala, Sweden -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Nils_H=F6glund?= 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). strip_phone.sql Description: Binary data
RE: Hints being ignored
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Connor > McDonald > Sent: Monday, July 01, 2002 12:29 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Hints being ignored > > > Are you sure? I've seen two very common examples in > the past which lead people to think that hints are > ignored when in fact they have not been: > > > Example 1: > > In SQL, select /*+HINT*/ will work, but in PL/SQL, > select /*+HINT*/ fails since the space trailing the + > is missing. > > Example 2: > > select /*+ USE_MERGE(e) */ ... > from DEPT d, EMP e > > can come back with a hash join - but the hint has NOT > been ignored, it has been 'avoided'. USE_MERGE simply > says if EMP is the *target* in the join, then make > sure its a sort-merge. That of course does not stop > EMP being the *driver* table in a hash join. And one of the reasons it is recommended to use the ORDERED hint when specifying join methods. There is nothing to prevent the CBO, as Connor pointed out, from calculating costs using other join orders, as is its normal behavior. The hint didn't *exclude* the evaluation of the various combinations of driving orders of tables. I think this is the most common example I see -- ignoring join methods when the person failed to specify the ORDERED hint. And another more subtle one is even if E, in the above example, is *not* the driving table in the plan and yet a HASH JOIN instead of a MERGE JOIN is used. What happens there is that the CBO evaluates driving by E, deciding on an HJ and throwing a "swap sides" at you. Larry G. Elkins -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle client won't install on Windows 2000
If this is a P4 machine, check metalink, et al, for the installer workaround. There are a known issues with symcjit.dll Doc ID: Note:131299.1 Subject: ALERT: Oracle Installer 8.1.X Hangs on Machines with Pentium 4 Processors Type: ALERT Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 02-JAN-2001 Last Revision Date: 26-JUN-2001 This alert was modified 14-May-2001 by modifying the vesions affected section to a generic RDBMS version and adding a simplified workaround. This alert was modified 16-January-2001 by specifying specific Oracle Universal Installer Versions in the the Versions Affected section. Oracle Universal Installer (OUI) for RDBMS 8.1.x Hangs on Machines with Pentium 4 Processors ~~ Versions Affected ~ Oracle Universal Installer for RDBMS 8.1.x Platforms Affected ~~
Re: Oracle client won't install on Windows 2000
Sometmes this is an issue that I have run into. Easy to fix, on the cd navigate out to the install folder, then the win32 folder and double click on the setup.exe there. Just Microsoft having issues with Java. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 5:03 PM > One of our developers is having a problem installing Oracle Client > (8.1.7). When he inserts the CD the initial screen comes up with the > options to Install/Deinstall products, Explore CD, Browse Documentation. > When he clicks on Install/Deinstall, however the Oracle Installer never > comes > up. > > Any ideas what might be wrong? > > Thanks > Peter Schauss > Northrop Grumman Corporation > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Schauss, Peter > 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: Jay 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: exp73 dumpparam for unlimited extents?
Thanks everyone for your advice. If I want to retrofit to 7.3.4 I have to create the tables sans storage clause then import import the data . Otherwise wait until the database upgrade. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical 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).
Rule Based Hint
My queries are running exceptionally good with a rule based optimizer and the cost based is doing a full table scan for the same. Is it good idea to put the RULE hint..? or is there anything I am missing. All my tables are properly analyzed. I thought I should avoid RULE hint as much as possible. any suggestions/comments on this pls.. Thanks in Advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle client won't install on Windows 2000
Hi I am guessing that he has a P4 cpu in the system and you need to do the following. There is also a new installer to overcome this as well but don't have the info at hand there is more on Metalink ORACLE ON PENTIUM 4 CONFLICT | by Liviu Obreja Here's a quick tip: The installation of Oracle8i on a Pentium 4 computer will exit without any notice. The reason for this is that the Pentium 4 architecture has problems with the Just In Time installer. To fix this problem, just find all copies of the file symcjit.dll and rename them to symcjit.org. Then the installer will work. Copy the installation CD to the HDD and make the changes, then install from the HDD. Voila! >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci784876,00.html 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. "Schauss, Peter" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02-07-2002 07:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject:Oracle client won't install on Windows 2000 One of our developers is having a problem installing Oracle Client (8.1.7). When he inserts the CD the initial screen comes up with the options to Install/Deinstall products, Explore CD, Browse Documentation. When he clicks on Install/Deinstall, however the Oracle Installer never comes up. Any ideas what might be wrong? Thanks Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter 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). STG31844 Description: Binary data
RE: Questionable V$SQLAREA Statistics
The degree is 4 and it is cached via alter table, not the KEEP buffer. On Oracle 8.1.7.2 on Linux RedHat 7.2 Thanks for clues... -Original Message- Sent: Monday, July 01, 2002 3:08 PM To: Multiple recipients of list ORACLE-L What is the degree of parallelism on this table? Waleed -Original Message- Sent: Monday, July 01, 2002 3:33 PM To: Multiple recipients of list ORACLE-L What version of Oracle? > 1) I have a 400,000 row table table which is cached. How has the table been cached? Alter table XXX cache? Or with a KEEP buffer? -Original Message- Sent: Monday, July 01, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Here's the scene: 1) I have a 400,000 row table table which is cached. 2) I have a query against that table and no other with one column referenced in the WHERE clause. (This column is indexed and of course I don't really need the index since the table is cached but it's there so ho hum...) 3) When I run tkprof on the query it shows a full table scan ignoring the index... that's what I want 'cause it's cached. 4) But when I look at V$SQLAREA the DISK_READS column is incremented. 5) This query is executed very often so my StatsPack report lists it as one of the most expensive queries in terms of physical reads. It appears that Oracle is counting full table scans of cached tables as DISK_READS in V$SQLAREA. Seems like this is a bug to me 'cause it's not really a physical disk read but is getting data from the buffers. Don't you think this is a bug? Has anyone seen this before? Steve Orr Looking for cache in Bozeman, Montana -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: Remove numbers from string
This is clever!
Waleed
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 5:33 PM
To: Multiple recipients of list ORACLE-L
Actually, it's simpler to use the trick
select translate('abc123def432', '~1234567890','~') from dual;
-Original Message-
Sent: Monday, July 01, 2002 4:23 PM
To: Multiple recipients of list ORACLE-L
Yes, use regular expressions via the owa_pattern package.
Here's an example:
declare
tstr varchar2(100) := 'this c34ontains s0239everal 2340 numeric 882
dig2its';
begin
dbms_output.put_line( tstr);
-- remove the digits
owa_pattern.change( tstr, '\d', '', 'g');
dbms_output.put_line( tstr);
-- remove the extra spaces
owa_pattern.change( tstr, '\s+', ' ', 'g');
dbms_output.put_line( tstr);
end;
/
Jared
Nils Höglund <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/01/2002 04:18 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Remove numbers from string
Is there any way to remove all numbers from a string?
The string might look like this: 'abc123def432'
and I wan't it to look like this: 'abcdef'.
I'm using Oracle 8.
Thanks in advance!
--
/Nils Höglund, Naqua KB
E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kirsch, Walter J (Northrop Grumman)
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: Khedr, Waleed
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: some questions regarding jobs in EU/US
Hello, I'm new to this topic. I don't know any procedures in detail. As I know, to work in EU/US, I need to get work permission. What is the procedure of getting work permission ? How long does it take to get work permission ? You can email me directly not to bother others... regards... -- Danisment Gazi Unal Adana, Turkey -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle client won't install on Windows 2000
When I have seen this, the application attempted to start and a window opens, but goes no further. If you open up your processes there is a jrew active. If it is not there, then we are seeing a different problem. Not repeatable: when I reboot, the next time I attempt the action it works. This also happens for DBA Studio every now and again. I assume that there are some Java incompatibilities with Oracle 8 jrew and Windows. I have not seen yet it with oracle 9 uses, but have less attempts trying things. At 01:03 PM 7/1/2002 -0800, Schauss, Peter wrote: One of our developers is having a problem installing Oracle Client (8.1.7). When he inserts the CD the initial screen comes up with the options to Install/Deinstall products, Explore CD, Browse Documentation. When he clicks on Install/Deinstall, however the Oracle Installer never comes up. Any ideas what might be wrong? Thanks Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical 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).
Lead Oracle Architect-DBA Needed in Rhode Island...
Position: Lead Oracle Architect-DBA Location: Northern part of Rhode Island (near Mass. border) Salary Range: 85-95K-depends on experience Please Do Not send your resume for this position Unless you and have the skills outlined below for this position. The company is looking for a solid Oracle DBA who has moved into architecture. This company does not like to relocate, but may consider qualified candidates willing to pay their own relocation expenses. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B Candidates please. *Responsibilities: This position requires in-depth database management, monitoring, tuning, security and troubleshooting skills using Oracle on large Unix systems. Good planning, organization and communication skills are needed to interact with application development teams and the operations center. Additional responsibilities include: Database sizing, disk layout, setup, applying patches, monitoring, tuning, etc. Conducting JAD sessions and data modeling. Utilizing 3rd Party tools for modeling, backup/recovery, reorgs, promotion, etc. Application design review, SQL code review, setting/enforcing standards. *Requirements: -Bachelor's Degree in Computer Science or proven work experience. -5+ years experience with Oracle running on Unix. -Experience with transactional or data warehouse VLDB's. -Knowledge of transaction systems, data warehouse and ERP systems. -Some programming using KSH, PLSQL or C. -Knowledge of ETL tools, Business Intelligence or Application suites. -U.S. citizenship or permanent residency. * Note: All interested candidates will be required to complete a DBA skills inventory questionnaire. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Rhode Island/Architect-DBA/Erik ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: system event waits
Do you guys think making times statistic =true has any performance impact . Are there any other considerations ? -Bp - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 12:53 PM > > Depending on the version of the database, timed_statistics > > may be dynamic > > and > > not require a database bounce. > > True - but the timing values are meaningless unless the counters > (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets the > counters and switches on timing at the same time I wouldn't recommend > using the time values otherwise. > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > Want to know about a carpenter who built a bridge with two sticks and three > nails? Write me for details! > > ** The opinions and statements above are entirely my own and not those of my > employer or clients ** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > 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: BigP 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: Asynchronous Procedure Calls
What if the caller wants to be notified, when the job is completed? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 4:33 PM > Hi Jared, > > Why? The caller will resume operation once it submits the job for immediate > execution. > > Am I missing something? > > Waleed > > -Original Message- > Sent: Monday, July 01, 2002 3:16 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > > > DBMS_JOB will not solve the problem of > async communications. > > Jared > > > > > > > "Khedr, Waleed" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/01/2002 12:23 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: Asynchronous Procedure Calls > > > You need dbms_job(s) > Also make sure you have enough background job processes to handle the > expected maximum number of concurrent procedure calls. > > Regards, > > Waleed > > -Original Message- > Sent: Monday, July 01, 2002 2:20 PM > To: Multiple recipients of list ORACLE-L > > > Advanced Queuing will do what you need. > > There are examples at otn.oracle.com > > Jared > > > > > > > Scott Canaan <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 06/28/2002 01:23 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Asynchronous Procedure Calls > > > I have a need to call a procedure repeatedly and asynchronously. I > am using dbms_pipe for the communication between the calling procedure > and the called procedure and that seems to be working. What I want to > do is call the procedure multiple times, asynchronously, from the main > procedure. The problem is that Oracle waits for each call to complete > before continuing processing. Is there any way to do this in PL/SQL? > My environment is: Oracle 8.1.7.0.0, Sun Solaris 2.8. I need to do > this in PL/SQL because it has to run through Oracle Warehouse Builder. > > Thank you. > > -- > Scott Canaan ([EMAIL PROTECTED]) > (585) 475-7886 > "Life is like a sewer, what you get out of it depends on what you put > into it" - Tom Lehrer > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Scott Canaan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Khedr, Waleed > 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: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).
Re: Oracle client won't install on Windows 2000
Hi Peter, I think you are using Intel Pentium IV processor for Win2K. If this is the case, you may try Oracle 9i DB, or go to metalink to see the tech note. Regs, Ferry Situmorang IT-Staff PTP Nusantara XIII (Persero) Pontianak-Indonesia - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 4:03 AM > One of our developers is having a problem installing Oracle Client > (8.1.7). When he inserts the CD the initial screen comes up with the > options to Install/Deinstall products, Explore CD, Browse Documentation. > When he clicks on Install/Deinstall, however the Oracle Installer never > comes > up. > > Any ideas what might be wrong? > > Thanks > Peter Schauss > Northrop Grumman Corporation > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Schauss, Peter > 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: Ferry Situmorang 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).
advance queue
Is it possible to user nested table as part of payload in advance queue . If yes then how to give storage clause for nested table while creating queue table . Does some body out there have experience on using nested table or varray as part of payload . Which one is better from performance point . -Bp
Re: system event waits
Thanks John and every body else . You guys rock . -Bp - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 12:53 PM > > Depending on the version of the database, timed_statistics > > may be dynamic > > and > > not require a database bounce. > > True - but the timing values are meaningless unless the counters > (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets the > counters and switches on timing at the same time I wouldn't recommend > using the time values otherwise. > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > Want to know about a carpenter who built a bridge with two sticks and three > nails? Write me for details! > > ** The opinions and statements above are entirely my own and not those of my > employer or clients ** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > 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: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle client won't install on Windows 2000
I have had the problem with installing the Oracle Client on a Pentium IV machine. If the developer is installing on a Pentium IV machine, please check out the note 149297.1 on Metalink. Regards, Bonnie Finke -Original Message- Sent: Monday, July 01, 2002 4:03 PM To: Multiple recipients of list ORACLE-L One of our developers is having a problem installing Oracle Client (8.1.7). When he inserts the CD the initial screen comes up with the options to Install/Deinstall products, Explore CD, Browse Documentation. When he clicks on Install/Deinstall, however the Oracle Installer never comes up. Any ideas what might be wrong? Thanks Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter 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: Bonnie Finke 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: Questionable V$SQLAREA Statistics
"Orr, Steve" wrote: > > Here's the scene: > > 1) I have a 400,000 row table table which is cached. > > 2) I have a query against that table and no other with one column referenced > in the WHERE clause. (This column is indexed and of course I don't really > need the index since the table is cached but it's there so ho hum...) > > 3) When I run tkprof on the query it shows a full table scan ignoring the > index... that's what I want 'cause it's cached. > > 4) But when I look at V$SQLAREA the DISK_READS column is incremented. > > 5) This query is executed very often so my StatsPack report lists it as one > of the most expensive queries in terms of physical reads. > > It appears that Oracle is counting full table scans of cached tables as > DISK_READS in V$SQLAREA. Seems like this is a bug to me 'cause it's not > really a physical disk read but is getting data from the buffers. > > Don't you think this is a bug? Has anyone seen this before? > > Steve Orr > Looking for cache in Bozeman, Montana Steve, First, as far as I understand it, to 'cache' a table is just to specify that after a table scan the table blocks in memory will not be prime candidate for recycling. It doesn't imply to me that the table is pinned up there in physical memory. Do you know how many blocks your table is made of? What percentage of db_block_buffers does it represent? I see nothing shocking in having I/Os. Moreover do not forget consistent reads (i.e. rollback segments). How can you be sure that your rollback segment blocks stay in memory? Not to mention temporary segments and the like. Second, it's not because a table is in memory that you should scorn indexes. The index tells you, basically,that this row is at this position in this block. Unless your table as been defined as a single, char(1) (most of them null) table, 400,000 rows probably represent a fair number of blocks and converting block number to memory address is certainly far more efficient than scanning all the blocks in memory. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: performance
Nalla, Is your database currently using a single RAID 5 device only? Or what? How many separate disk devices does your database use? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: Remove numbers from string
Actually, it's simpler to use the trick
select translate('abc123def432', '~1234567890','~') from dual;
-Original Message-
Sent: Monday, July 01, 2002 4:23 PM
To: Multiple recipients of list ORACLE-L
Yes, use regular expressions via the owa_pattern package.
Here's an example:
declare
tstr varchar2(100) := 'this c34ontains s0239everal 2340 numeric 882
dig2its';
begin
dbms_output.put_line( tstr);
-- remove the digits
owa_pattern.change( tstr, '\d', '', 'g');
dbms_output.put_line( tstr);
-- remove the extra spaces
owa_pattern.change( tstr, '\s+', ' ', 'g');
dbms_output.put_line( tstr);
end;
/
Jared
Nils Höglund <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/01/2002 04:18 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Remove numbers from string
Is there any way to remove all numbers from a string?
The string might look like this: 'abc123def432'
and I wan't it to look like this: 'abcdef'.
I'm using Oracle 8.
Thanks in advance!
--
/Nils Höglund, Naqua KB
E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kirsch, Walter J (Northrop Grumman)
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: Asynchronous Procedure Calls
That is true, I have figured it out. dbms_job will allow the asynchronous execution of procedures and dbms_pipe allows the communication between the processes to occur. It works. I'm doing it now. The jobs are being kicked off in groups of 10 and they are sending a message back to the calling program via pipes. Each job has it's own pipe, so the main program can keep track of who is done. Currently, I am waiting for all 10 to complete before starting the next 10, but I may work on a way to start the eleventh job when the first one finishes. I'm just glad that I got something to work. Thank you for your help. [EMAIL PROTECTED] wrote: > DBMS_JOB will not solve the problem of > async communications. > > Jared > > "Khedr, Waleed" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/01/2002 12:23 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: Asynchronous Procedure Calls > > You need dbms_job(s) > Also make sure you have enough background job processes to handle the > expected maximum number of concurrent procedure calls. > > Regards, > > Waleed > > -Original Message- > Sent: Monday, July 01, 2002 2:20 PM > To: Multiple recipients of list ORACLE-L > > Advanced Queuing will do what you need. > > There are examples at otn.oracle.com > > Jared > > Scott Canaan <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 06/28/2002 01:23 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Asynchronous Procedure Calls > > I have a need to call a procedure repeatedly and asynchronously. I > am using dbms_pipe for the communication between the calling procedure > and the called procedure and that seems to be working. What I want to > do is call the procedure multiple times, asynchronously, from the main > procedure. The problem is that Oracle waits for each call to complete > before continuing processing. Is there any way to do this in PL/SQL? > My environment is: Oracle 8.1.7.0.0, Sun Solaris 2.8. I need to do > this in PL/SQL because it has to run through Oracle Warehouse Builder. > > Thank you. > > -- > Scott Canaan ([EMAIL PROTECTED]) > (585) 475-7886 > "Life is like a sewer, what you get out of it depends on what you put > into it" - Tom Lehrer > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Scott Canaan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to
Oracle client won't install on Windows 2000
One of our developers is having a problem installing Oracle Client (8.1.7). When he inserts the CD the initial screen comes up with the options to Install/Deinstall products, Explore CD, Browse Documentation. When he clicks on Install/Deinstall, however the Oracle Installer never comes up. Any ideas what might be wrong? Thanks Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter 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: Questionable V$SQLAREA Statistics
What version of Oracle? > 1) I have a 400,000 row table table which is cached. How has the table been cached? Alter table XXX cache? Or with a KEEP buffer? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: How to read REDO log
You can use logminer against an 8.0 database: See metalink note 62508.1 in the "features" section: It is possible to generate a Dictionary file from an 8.0.database and use it to Analyze Oracle 8.0 redo logs. In order to do this run "dbmslogmnrd.sql" against the 8.0 database, then follow the procedure as below. All analysis of the logfiles will have to take place while connected to an 8.1 database since dbms_logmnr cannot operate against Oracle 8.0 because it uses trusted callouts. Regards, Michael P. Sale --- "Nguyen, David M" <[EMAIL PROTECTED]> wrote: > Can I setup LogMiner to read REDO log of > Oracle8.0.5? Someone tells me > LogMiner only works for Oracle8.1 or above, is it > correct? Is there another > tool to read REDO log besides LogMiner? > > Thanks, > David > = Michael P. Sale Author: Oracle9i on Windows 2000 Tips and Techniques __ 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: Michael Sale 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: Questionable V$SQLAREA Statistics
What is the degree of parallelism on this table? Waleed -Original Message- Sent: Monday, July 01, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Here's the scene: 1) I have a 400,000 row table table which is cached. 2) I have a query against that table and no other with one column referenced in the WHERE clause. (This column is indexed and of course I don't really need the index since the table is cached but it's there so ho hum...) 3) When I run tkprof on the query it shows a full table scan ignoring the index... that's what I want 'cause it's cached. 4) But when I look at V$SQLAREA the DISK_READS column is incremented. 5) This query is executed very often so my StatsPack report lists it as one of the most expensive queries in terms of physical reads. It appears that Oracle is counting full table scans of cached tables as DISK_READS in V$SQLAREA. Seems like this is a bug to me 'cause it's not really a physical disk read but is getting data from the buffers. Don't you think this is a bug? Has anyone seen this before? Steve Orr Looking for cache in Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: Khedr, Waleed 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: Asynchronous Procedure Calls
Hi Jared, Why? The caller will resume operation once it submits the job for immediate execution. Am I missing something? Waleed -Original Message- Sent: Monday, July 01, 2002 3:16 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] DBMS_JOB will not solve the problem of async communications. Jared "Khedr, Waleed" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/01/2002 12:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Asynchronous Procedure Calls You need dbms_job(s) Also make sure you have enough background job processes to handle the expected maximum number of concurrent procedure calls. Regards, Waleed -Original Message- Sent: Monday, July 01, 2002 2:20 PM To: Multiple recipients of list ORACLE-L Advanced Queuing will do what you need. There are examples at otn.oracle.com Jared Scott Canaan <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/28/2002 01:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Asynchronous Procedure Calls I have a need to call a procedure repeatedly and asynchronously. I am using dbms_pipe for the communication between the calling procedure and the called procedure and that seems to be working. What I want to do is call the procedure multiple times, asynchronously, from the main procedure. The problem is that Oracle waits for each call to complete before continuing processing. Is there any way to do this in PL/SQL? My environment is: Oracle 8.1.7.0.0, Sun Solaris 2.8. I need to do this in PL/SQL because it has to run through Oracle Warehouse Builder. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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: Khedr, Waleed 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: system event waits
John: There is an undocumented package thru which you can reset few of the timings. (It resets the timing info in X$KCFIO and the MAX_WAIT_TIME (!) in the V$SESSION/SYSTEM event views. --- John Kanagaraj <[EMAIL PROTECTED]> wrote: > > Depending on the version of the database, timed_statistics > > may be dynamic > > and > > not require a database bounce. > > True - but the timing values are meaningless unless the counters > (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets the > counters and switches on timing at the same time I wouldn't > recommend > using the time values otherwise. > = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ 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: K Gopalakrishnan 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: Asynchronous Procedure Calls
DBMS_JOB will not solve the problem of async communications. Jared "Khedr, Waleed" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/01/2002 12:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Asynchronous Procedure Calls You need dbms_job(s) Also make sure you have enough background job processes to handle the expected maximum number of concurrent procedure calls. Regards, Waleed -Original Message- Sent: Monday, July 01, 2002 2:20 PM To: Multiple recipients of list ORACLE-L Advanced Queuing will do what you need. There are examples at otn.oracle.com Jared Scott Canaan <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/28/2002 01:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Asynchronous Procedure Calls I have a need to call a procedure repeatedly and asynchronously. I am using dbms_pipe for the communication between the calling procedure and the called procedure and that seems to be working. What I want to do is call the procedure multiple times, asynchronously, from the main procedure. The problem is that Oracle waits for each call to complete before continuing processing. Is there any way to do this in PL/SQL? My environment is: Oracle 8.1.7.0.0, Sun Solaris 2.8. I need to do this in PL/SQL because it has to run through Oracle Warehouse Builder. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Questionable V$SQLAREA Statistics
Here's the scene: 1) I have a 400,000 row table table which is cached. 2) I have a query against that table and no other with one column referenced in the WHERE clause. (This column is indexed and of course I don't really need the index since the table is cached but it's there so ho hum...) 3) When I run tkprof on the query it shows a full table scan ignoring the index... that's what I want 'cause it's cached. 4) But when I look at V$SQLAREA the DISK_READS column is incremented. 5) This query is executed very often so my StatsPack report lists it as one of the most expensive queries in terms of physical reads. It appears that Oracle is counting full table scans of cached tables as DISK_READS in V$SQLAREA. Seems like this is a bug to me 'cause it's not really a physical disk read but is getting data from the buffers. Don't you think this is a bug? Has anyone seen this before? Steve Orr Looking for cache in Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: Remove numbers from string
JS, Doesn't that owa_pattern package come from the PL/SQL Web Toolkit, which requires that you have the Oracle App Server licensed?? -Original Message- Sent: Monday, July 01, 2002 4:23 PM To: Multiple recipients of list ORACLE-L Yes, use regular expressions via the owa_pattern package. Here's an example: declare tstr varchar2(100) := 'this c34ontains s0239everal 2340 numeric 882 dig2its'; begin dbms_output.put_line( tstr); -- remove the digits owa_pattern.change( tstr, '\d', '', 'g'); dbms_output.put_line( tstr); -- remove the extra spaces owa_pattern.change( tstr, '\s+', ' ', 'g'); dbms_output.put_line( tstr); end; / Jared Nils Höglund <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/01/2002 04:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Remove numbers from string Is there any way to remove all numbers from a string? The string might look like this: 'abc123def432' and I wan't it to look like this: 'abcdef'. I'm using Oracle 8. Thanks in advance! -- /Nils Höglund, Naqua KB E-mail: [EMAIL PROTECTED] Web:http://www.naqua.se/ Home Phone: +46 (0)18 30 09 19 Cellular Phone: +46 (0)709 91 97 65 Address:Nya Valsätrav. 26 B SE-756 46 Uppsala, Sweden -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Nils_H=F6glund?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..
Seems relevant to me. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/28/2002 07:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio.. Actually, getting a certain type of Oracle job is not OT. Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Johnson, Michael [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 5:33 PM > To:Multiple recipients of list ORACLE-L > Subject: RE: Oracle DBA with TS SCI Clearance Needed in Dayton, > Ohio.. > > I would suggest we take this thread off > line as it really is irrelevant with what > this list is for. > > Jared, correct me if Im wrong. > > Mike > > -Original Message- > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 3:09 PM > To: Multiple recipients of list ORACLE-L > > > Get a job requiring the clearance, either as a direct government employee > or > as a contractor. > > Scott Shafer > San Antonio, TX > 210-581-6217 > > > > -Original Message- > > From:Freeman, Robert [SMTP:[EMAIL PROTECTED]] > > Sent:Thursday, June 27, 2002 4:39 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Oracle DBA with TS SCI Clearance Needed in Dayton, > > Ohio.. > > > > For the curious around, does anyone know how one would do such a thing? > > > > RF > > > > Robert G. Freeman - Oracle8i OCP > > Oracle Database Architect > > CSX Midtier Database Administration > > Author: Oracle9i New Features > > Mastering Oracle8i > > > > Clark Griswold: Eddie, has anyone ever told you that you're bad luck? > > Cousin Eddie: Those were my mother's dying words. But I > > guess if your body's covered in third degree burns, and > > your foot's caught in a bear trap, you tend to start talkin' > > crazy. > > > > > > > > -Original Message- > > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, June 27, 2002 4:51 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Don't. Its not worth the hassle. > > > > Scott Shafer > > San Antonio, TX > > 210-581-6217 > > > > > > > -Original Message- > > > From: Michael Cupp [SMTP:[EMAIL PROTECTED]] > > > Sent: Thursday, June 27, 2002 1:53 PM > > > To:Multiple recipients of list ORACLE-L > > > Subject: RE: Oracle DBA with TS SCI Clearance Needed in Dayton, > > > Ohio.. > > > > > > How would one begin the process of getting one? Or does it have to be > > > government sponsored? > > > > > > -Original Message- > > > Sent: Thursday, June 27, 2002 2:35 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > It is my understanding that it currently takes 1.5 to 2 years to get > > this > > > clearence mainly due to events of 9/11. So, if you have one, it > behooves > > > you to keep it current. > > > > > > They used to estimate these clearences were worth > > > an additional $10K a year for salary. Im thinking > > > at least $25K now.Alot of my friends that have > > > these clearances , whether they be DBAs, programmers, > > > Sys. Ads. etc, have standing offers for work in many > > > places around the world due to the fact these clearances > > > are very hard to get. > > > > > > Also, the companies will not foot the bill for this > > > delay. The government usually has to approve all hires > > > where the individual is not cleared. From what I have > > > seen the government is in no mood to do this as of > > > late. > > > > > > FWIW ! > > > > > > Mike > > > > > > -Original Message- > > > Sent: Wednesday, June 26, 2002 4:54 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > I don't understand the large number of positions coming out that > require > > > > > a CURRENT Secret or Top Secret clearance. How can all these positions > > > > be filled unless these company/entities start footing the bill for > > > people getting the clearances?!? > > > > > > Johnson, Michael wrote: > > > > > > >That is not my understanding. > > > > > > > >FWIW. Mike > > > > > > > >-Original Message- > > > >Sent: Wednesday, June 26, 2002 1:35 PM > > > >To: Multiple recipients of list ORACLE-L > > > > > > > > > > > >Actually no one who has been holds any SCI tickets can admit to doing > > > > >so :) One can say you have been the subject of a Special Backgroud > > > >Investigation, and Extensive Background Investigation, a Full Field > > > >Investigation even though 99. times out of 100 these > investigations > > > > > >are done for just such access. > > > > > > > >Ian MacGregor > > > >Stanford Linear Accelerator Center > > > >[EMAIL PROTECTED] > > > > > > > > > > > >-Original Message- > > > >Sent: Wednesday, June 26, 2002 9:24 AM > > > >To: Multiple recipients of li
Re: Remove numbers from string
Yes, use regular expressions via the owa_pattern package. Here's an example: declare tstr varchar2(100) := 'this c34ontains s0239everal 2340 numeric 882 dig2its'; begin dbms_output.put_line( tstr); -- remove the digits owa_pattern.change( tstr, '\d', '', 'g'); dbms_output.put_line( tstr); -- remove the extra spaces owa_pattern.change( tstr, '\s+', ' ', 'g'); dbms_output.put_line( tstr); end; / Jared Nils Höglund <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/01/2002 04:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Remove numbers from string Is there any way to remove all numbers from a string? The string might look like this: 'abc123def432' and I wan't it to look like this: 'abcdef'. I'm using Oracle 8. Thanks in advance! -- /Nils Höglund, Naqua KB E-mail: [EMAIL PROTECTED] Web:http://www.naqua.se/ Home Phone: +46 (0)18 30 09 19 Cellular Phone: +46 (0)709 91 97 65 Address:Nya Valsätrav. 26 B SE-756 46 Uppsala, Sweden -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Nils_H=F6glund?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database Hung with all processes waiting on locks
Mary, > We don't plan to use MTS for 11i just during the AUTOUPGRADE > process from 10.7 to 11i. We found that it runs 20% faster > with MTS because the workers logon/off thousands of times. > > And yes MTS is configured with with large pool. Thanks for > the feedback. Did Oracle Support suggest that you use MTS? If not, such problems may not be looked at in case you get stuck with an iTAR during an upgrade. I would look at using 11.5.7 which supposedly has a script that could check which scripts need not run. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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: Frequent ''ORA -1650: unable to extend rollback segment error
Have you checked if someone might be holding space in the rollback segment you're getting the error for? We had a similar problem two weeks ago which we resolved by killing the session that was holding the space (oddly, they weren't holding any locks so I don't know why they were holding RBS space). You can use this script (from the remarkably useful SQL & PL/SQL Annotated Archives) to find out: column rr heading 'RB Segment' format a18 column us heading 'Username' format a15 column os heading 'OS User' format a10 column te heading 'Terminal' format a10 select R.name rr, NVL(S.Username, 'no transaction') us, S.Osuser os, S.Terminal te from v$lock l, v$session s, v$rollname r where l.sid=s.sid(+) and trunc(l.id1/65536)=r.usn and l.type='TX' and l.lmode=6 order by r.name; -Original Message- Sent: Monday, June 24, 2002 6:38 PM To: Multiple recipients of list ORACLE-L errors'' in the Hi All, For the last 10-12 days Database is giving frequent ORA 1650 errors. My Database size is 74 GB and Total No. of Rollback segments are 19, with Initial Extent 60MB, Next extent 60MB, MIN_EXTENTS 2, MAX_EXTENTS 505. There are 2 Tablespaces holding these Rollback segments( 4GB and 1 GB) There is no extra load on the database. I am really worried why this problem has been started all of a sudden. The rollback segment statistics is showing high number of Waits and wrap. For few rollback segments wait statistics it is exceeding even 100 which I have never seen. and now because of this few importants reports are aborted. Mon Jun 24 00:49:48 2002 Thread 1 advanced to log sequence 5416 Current log# 2 seq# 5416 mem# 0: /oracle05/oradata/GASPROD/redo02.log Mon Jun 24 00:49:55 2002 ORA-1650: unable to extend rollback segment RBS12 by 7680 in tablespace RBS Failure to extend rollback segment 12 because of 1650 condition Mon Jun 24 00:52:33 2002 Thread 1 advanced to log sequence 5417 Current log# 1 seq# 5417 mem# 0: /oracle05/oradata/GASPROD/redo01.log Mon Jun 24 00:56:24 2002 Thread 1 advanced to log sequence 5418 Kindly suggest if anybody has some clue. Regards deepender -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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
RE: system event waits
> Depending on the version of the database, timed_statistics > may be dynamic > and > not require a database bounce. True - but the timing values are meaningless unless the counters (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets the counters and switches on timing at the same time I wouldn't recommend using the time values otherwise. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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: system event waits
Depending on the version of the database, timed_statistics may be dynamic and not require a database bounce. Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Monday, July 01, 2002 2:38 PM To: Multiple recipients of list ORACLE-L That TIMED_STATISTICS is defaulted to FALSE... To obtain any meaningful information from Wait stats, this needs to be set to TRUE (followed by a Db bounce). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, July 01, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Hi List , In system_event i find total_waits , total_timeouts , time_waited and avg_wait . If total_waits and total_timeouts are high but there are 0 value for time_waited and avg_wait . What does this indicates ? TIA -Bp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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: Asynchronous Procedure Calls
You need dbms_job(s) Also make sure you have enough background job processes to handle the expected maximum number of concurrent procedure calls. Regards, Waleed -Original Message- Sent: Monday, July 01, 2002 2:20 PM To: Multiple recipients of list ORACLE-L Advanced Queuing will do what you need. There are examples at otn.oracle.com Jared Scott Canaan <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/28/2002 01:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Asynchronous Procedure Calls I have a need to call a procedure repeatedly and asynchronously. I am using dbms_pipe for the communication between the calling procedure and the called procedure and that seems to be working. What I want to do is call the procedure multiple times, asynchronously, from the main procedure. The problem is that Oracle waits for each call to complete before continuing processing. Is there any way to do this in PL/SQL? My environment is: Oracle 8.1.7.0.0, Sun Solaris 2.8. I need to do this in PL/SQL because it has to run through Oracle Warehouse Builder. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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: Perl for Oracle DBAs....wow.
How to Get Free Drinks for DBA's: 1) Place bar tab and carbon paper under title page... 2) Feign adoration of esteemed author... 3) Get "autograph" on title page. :-) -Original Message- Sent: Monday, July 01, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Importance: High The autograph is free. :) Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/28/2002 12:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Perl for Oracle DBAswow. Well I'll be dang...check out what book is now listed on Amazon... http://www.amazon.com/exec/obidos/ASIN/0596002106/qid=1025287397/sr=1-20/ref =sr_1_20/102-7873510-7493740 I wonder how much an autographed copy is... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: Locked rows - finding out
Hi, Vladimir You can made a join between the table in question and v$session: select a.* from table_xx a, v$session s where dbms_rowid.ROWID_ROW_NUMBER(a.rowid)=s.ROW_WAIT_ROW# and dbms_rowid.ROWID_BLOCK_NUMBER(a.rowid)=s.ROW_WAIT_BLOCK# and dbms_rowid.ROWID_RELATIVE_FNO(a.rowid)=s.ROW_WAIT_FILE# and s.sid=&sid ; Mario. Por favor, responda a [EMAIL PROTECTED] Enviado por: [EMAIL PROTECTED] Destinatarios: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> CC: Asunto: Locked rows - finding out Clasificación: Hello listers By quering V$LOCK or V$LOCKED_OBJECT I may find which tables are locked. How do I see rowids of rows that are locked? And how do I see into what rollback segment is being used by transaction that placed locks on those rows? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao 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.telecom.com.ar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mario J Gonzalez 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: Perl for Oracle DBAs....wow.
Jared, Congratulations on getting the book out! Looking forward to getting my copy when it is available! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 01, 2002 2:25 PM To: Multiple recipients of list ORACLE-L The autograph is free. :) Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/28/2002 12:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Perl for Oracle DBAswow. Well I'll be dang...check out what book is now listed on Amazon... http://www.amazon.com/exec/obidos/ASIN/0596002106/qid=1025287397/sr=1-20/ref =sr_1_20/102-7873510-7493740 I wonder how much an autographed copy is... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Perl for Oracle DBAs....wow.
Oh. I was talking about Andy Duncan's autograph...but I guess you can sign it too...on the inside back cover or something(big grin) Just kidding. I'm looking forward to getting the book. -Original Message- Sent: Monday, July 01, 2002 1:18 PM To: [EMAIL PROTECTED] Cc: Grabowy, Chris The autograph is free. :) Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/28/2002 12:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Perl for Oracle DBAswow. Well I'll be dang...check out what book is now listed on Amazon... http://www.amazon.com/exec/obidos/ASIN/0596002106/qid=1025287397/sr=1-20/ref =sr_1_20/102-7873510-7493740 I wonder how much an autographed copy is... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: Grabowy, Chris 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: How to read REDO log
Title: RE: ORA-27101 Error alter system dump logfile will let you decode the contents of a redo logfile to a text file. Remember, by text file, I do not mean it is a verbose text, but much more understandable compared to the encoded redo log file. Please make sure that background_dump_dest points to a directory that has enough space available, I have seen examples of a 5MB redo file creating a trace file about 5 times it size. You may also need to set max_dump_file_size appropriately (to unlimited). I read all this information in an article written by Graham Thornton date 9/26/2000. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]Sent: Monday, July 01, 2002 1:58 PMTo: Multiple recipients of list ORACLE-LSubject: RE: How to read REDO log I think you can do this being in a 8i database. -Original Message-From: Nguyen, David M [mailto:[EMAIL PROTECTED]]Sent: Monday, July 01, 2002 12:29 PMTo: Multiple recipients of list ORACLE-LSubject: How to read REDO log Can I setup LogMiner to read REDO log of Oracle8.0.5? Someone tells me LogMiner only works for Oracle8.1 or above, is it correct? Is there another tool to read REDO log besides LogMiner? Thanks,David *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: system event waits
That TIMED_STATISTICS is defaulted to FALSE... To obtain any meaningful information from Wait stats, this needs to be set to TRUE (followed by a Db bounce). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, July 01, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Hi List , In system_event i find total_waits , total_timeouts , time_waited and avg_wait . If total_waits and total_timeouts are high but there are 0 value for time_waited and avg_wait . What does this indicates ? TIA -Bp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database Hung with all processes waiting on locks
John, We don't plan to use MTS for 11i just during the AUTOUPGRADE process from 10.7 to 11i. We found that it runs 20% faster with MTS because the workers logon/off thousands of times. And yes MTS is configured with with large pool. Thanks for the feedback. -Original Message- Sent: Friday, June 28, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Mary Jo, Are you sure that MTS is supported in 11i (or at least in an upgrade)? My understanding is that it is not - the work required is just too heavy for MTS As a start, you could take out MTS, and try and use IPC if it your APPL_TOP and Oracle DB are on the same server. There is an incredibly _huge_ number of jobs to be run through the workers and tons of SQL is loaded. I wouldn't be surprised by lib cache/row cache related waits. How many workers did you use? The recommendation is # of cpus + 2, although I would bump that number up just a little. Is LARGE_POOL_SIZE configured? More questions than answers, but I hope this shines a light in the right direction! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 The manuals for Oracle are here: http://tahiti.oracle.com The manual for Life is here: http://www.gospelcom.net ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -Original Message- > From: Tortorelli, Mary Jo [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 8:23 AM > To: Multiple recipients of list ORACLE-L > Subject: Database Hung with all processes waiting on locks > > > We were running 11i Autoupgrade (from 10.7) on HP-UX 8.1.7.3 > 64-bit Oracle. > > Yesterday the database hung with every session having a > WAITING status in v$session_wait. The MTS processes were > 'rdbms ipc message', several workers were waiting on 'row > cache lock' and 'library cache pin' and background processes > on 'pmon timer'. > > I flushed the shared pool but it didn't help. I did a trace > level 10 dump and recycled the database. Recycling worked > but now I'm trying to figure out what may have happened. I > don't know how to interpret the trace file to glean a cause. > > Any ideas or advice are welcome. I wonder if the workers > stepped on each other or MTS somehow got hosed. There were > 18 active workers. Some samples from the trace file below. > > Thanks in advance!!! > > > SO: c000e81e8ce0, type: 3, owner: c000ed03f580, > pt: 0, flag: INIT/-/-/0x00 > (session) trans: 0, creator: c000ed03f580, flag: > (8e5) USR/- BSY/-/-/-/-/- > DID: 0001-002B-0ACD, short-term DID: > -- > txn branch: 0 > oct: 0, prv: 0, user: 51/APPS > O/S info: user: applmgr, term: pts/tb, ospid: 11226, > machine: hr03 > program: > client info: >0 > waiting for 'library cache pin' blocking sess=0x0 > seq=38949 wait_time=0 > handle address=c001133639f0, pin > address=c000ed159bf8, 10*mode+namespace=1e > -- > SO: c000e81bcde0, type: 3, owner: c000e815c3a8, > pt: 0, flag: INIT/-/-/0x00 > (session) trans: 0, creator: c000e815c3a8, flag: (51) > USR/- BSY/-/-/-/-/- > DID: 0001-0002-0002, short-term DID: > -- > txn branch: 0 > oct: 0, prv: 0, user: 0/SYS > waiting for 'pmon timer' blocking sess=0x0 seq=7330 wait_time=0 > duration=12c, =0, =0 > > SO: c000e81d10e0, type: 3, owner: c000e815e958, > pt: 0, flag: INIT/-/-/0x00 > (session) trans: 0, creator: c000e815e958, flag: (41) > USR/- BSY/-/-/-/-/- > DID: 0001-000B-1AA1, short-term DID: > -- > txn branch: 0 > oct: 0, prv: 0, user: 0/ > O/S info: user: , term: , ospid: , machine: > program: > waiting for 'row cache lock' blocking sess=0x0 seq=2114 > wait_time=0 > cache id=7, mode=0, request=3 > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tortorelli, Mary Jo > 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 ORA
Re: Perl for Oracle DBAs....wow.
The autograph is free. :) Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/28/2002 12:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Perl for Oracle DBAswow. Well I'll be dang...check out what book is now listed on Amazon... http://www.amazon.com/exec/obidos/ASIN/0596002106/qid=1025287397/sr=1-20/ref =sr_1_20/102-7873510-7493740 I wonder how much an autographed copy is... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-600 during replication
Better look again. I got 4 hits on 'ora-600 ktbdchk1' Jared "Vladimir Barac - posao" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/01/2002 02:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:ORA-600 during replication Good morning / afternoon/ evening (depending on your position)... Alert log has following lines... Tue Jun 25 10:07:30 2002 Errors in file E:\Oracle\admin\vurs\bdump\vursSNP2.TRC: ORA-12012: error on auto execute of job 123 ORA-12008: error in snapshot refresh path ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], [] ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1 What the hell is going on? I tried to do some search on metalink, but to no avail. Hate to say this, but it is kind of urgernt! Regards, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hints being ignored
Lee, Lee, Lee... This is a serious RTFM question. :) It should read: SELECT /*+ INDEX(d CONSUMER_COMM_D2C_PK) */ Jared Robertson Lee - lerobe <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/28/2002 07:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Hints being ignored All Oracle 8.0.5.0.0 Tru64 4.0f Select statement as follows. The hint is being totally ignored. Any ideas ?? Regards Lee SELECT /*+ INDEX(CONSUMER_COMM_D2C CONSUMER_COMM_D2C_PK) */ i.household_id || '|' || 'd' || '|' || d.promotion_item_id || '|' || xp.campaign_id || '|' || xp.document_id || '|' || xp.segment || '|' || xd.contact_type_code || '|' FROM genex_individual i , consumer_comm_d2c d , x_promotion_item xp , x_document xd WHERE i.brief_name = '$brief_name' AND i.individual_id = d.consumer_id AND d.promotion_item_id = xp.promotion_item_id AND xp.document_id = xd.document_id ORDER BY i.household_id ; Table CONSUMER_COMM_D2C is as follows NameNull?Type --- CONSUMER_ID NOT NULL NUMBER(9) PROMOTION_ITEM_ID NOT NULL NUMBER(9) COMMUNICATION_DATE NOT NULL DATE COMMUNICATION_STATUS_CODEVARCHAR2(2) COMMUNICATION_DETAIL VARCHAR2(500) BLOCK_LDT NOT NULL DATE ROW_CHANGE_SOURCE NOT NULL NUMBER(9) ROW_CHANGE_TIME DATE ROW_CHANGE_USERIDVARCHAR2(50) Index CONSUMER_COMM_D2C_PK is built as follows consumer_id promotion_item_id communication_date. The table is partitioned on promotion_item_id and the indexes on the partitions are local Explain plan is as follows Operation Object Name Rows Bytes Cost TQ In/Out PStart PStop SELECT STATEMENT 1440 G 106 G SORT ORDER BY 1440 G 171770G 106 G MERGE JOIN 1440 G 171770G 17 M SORT JOIN 13 M 1G 300284 HASH JOIN 13 M 1G 10271 TABLE ACCESS FULL X_PROMOTION_ITEM 7 K 409 K 10 MERGE JOIN CARTESIAN 2 M 90 M 3206 TABLE ACCESS FULL X_DOCUMENT 1 K 25 K 6 SORT JOIN 1 K 31 K 3200 TABLE ACCESS FULL GENEX_INDIVIDUAL 1 K 31 K 2 SORT JOIN 1 G 39G 17 M PARTITION CONCATENATED 1 26 TABLE ACCESS FULL CONSUMER_COMM_D2C 1 G 39G 1352283 1 26 * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- 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: Asynchronous Procedure Calls
Advanced Queuing will do what you need. There are examples at otn.oracle.com Jared Scott Canaan <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/28/2002 01:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Asynchronous Procedure Calls I have a need to call a procedure repeatedly and asynchronously. I am using dbms_pipe for the communication between the calling procedure and the called procedure and that seems to be working. What I want to do is call the procedure multiple times, asynchronously, from the main procedure. The problem is that Oracle waits for each call to complete before continuing processing. Is there any way to do this in PL/SQL? My environment is: Oracle 8.1.7.0.0, Sun Solaris 2.8. I need to do this in PL/SQL because it has to run through Oracle Warehouse Builder. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: control file I/O significantly changed
Title: RE: control file I/O significantly changed I am using Oracle 8.1.7.3 -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Subject: RE: control file I/O significantly changed Paula, It would help if you told us which version you are using and seeing this change in. I believe that with 9i more is written to the control files. I know that if you are using RMAN this is the case You can also dump the control files to see what is in them. Are they larger than they used to be? Rachel --- [EMAIL PROTECTED] wrote: > Guys, > > It appears to me that control files are being written to continously > versus > only during checkpoints. I.E. the I/O behaviour of control files has > changed significantly. Does anyone have any good doc. on this? Is > it an > intentional architectural change? > > Thanks, > Paula > __ 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: How to read REDO log
Title: RE: ORA-27101 Error I think you can do this being in a 8i database. -Original Message-From: Nguyen, David M [mailto:[EMAIL PROTECTED]]Sent: Monday, July 01, 2002 12:29 PMTo: Multiple recipients of list ORACLE-LSubject: How to read REDO log Can I setup LogMiner to read REDO log of Oracle8.0.5? Someone tells me LogMiner only works for Oracle8.1 or above, is it correct? Is there another tool to read REDO log besides LogMiner? Thanks,David
RE: Oracle8i Upgrade Exam Material
The Oracle8i New Features For Administrators Exam Cram by Robert Freeman (Tours Truly) is available on Amazon. Not that I get a dime of royalty out of it anymore :-( RF Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Monday, July 01, 2002 10:44 AM To: Multiple recipients of list ORACLE-L I am going to be taking the Oracle8i: New Features for Administrators (1Z0-020) exam and am looking for study materials. Can anyone recommend and books for this exam? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams 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).
How to read REDO log
Title: RE: ORA-27101 Error Can I setup LogMiner to read REDO log of Oracle8.0.5? Someone tells me LogMiner only works for Oracle8.1 or above, is it correct? Is there another tool to read REDO log besides LogMiner? Thanks,David
system event waits
Hi List , In system_event i find total_waits , total_timeouts , time_waited and avg_wait . If total_waits and total_timeouts are high but there are 0 value for time_waited and avg_wait . What does this indicates ? TIA -Bp
RE: Hints being ignored
Are you sure? I've seen two very common examples in the past which lead people to think that hints are ignored when in fact they have not been: Example 1: In SQL, select /*+HINT*/ will work, but in PL/SQL, select /*+HINT*/ fails since the space trailing the + is missing. Example 2: select /*+ USE_MERGE(e) */ ... from DEPT d, EMP e can come back with a hash join - but the hint has NOT been ignored, it has been 'avoided'. USE_MERGE simply says if EMP is the *target* in the join, then make sure its a sort-merge. That of course does not stop EMP being the *driver* table in a hash join. hth connor --- "Miller, Jay" <[EMAIL PROTECTED]> wrote: > Do you know in what version this became the case? I > certainly remember some > hints being ignored in version 8.0. > > -Original Message- > Sent: Saturday, June 29, 2002 5:58 AM > To: Multiple recipients of list ORACLE-L > > > A hint is absolutely, positively a DIRECTIVE, not a > suggestion. > > Jonathan can explain if you have doubts. > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > > Upcoming events: > - Hotsos Clinic, Jul 9-11 New York City > - Hotsos Clinic, Jul 23-25 Chicago > - 2003 Hotsos Symposium on OracleR System > Performance, Feb 9-12 Dallas > > > > -Original Message- > Sent: Friday, June 28, 2002 7:08 PM > To: Multiple recipients of list ORACLE-L > > Hints used to be more like that. > > hints are more like "do it" nowadays, their > aggressiveness has gone up. > > joe > > > basher 59 wrote: > > > When putting in hints, remember this bit of > advise. A hint is just a > > > hint. Oracle may choose today to use your hit and > tomorrow it may > > not. I don't like using hints for this reason, > and I usually try and > > > rewrite the query if I can. Have you analyzed > the table lately. If > > the table is not analyzed, it may not use the > indexes. > > > > > >> From: Robertson Lee - lerobe > <[EMAIL PROTECTED]> > >> Reply-To: [EMAIL PROTECTED] > >> To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > >> Subject: Hints being ignored > >> Date: Fri, 28 Jun 2002 06:13:19 -0800 > >> > >> All > >> > >> Oracle 8.0.5.0.0 > >> > >> Tru64 4.0f > >> > >> Select statement as follows. The hint is being > totally ignored. Any > >> ideas ?? > >> > >> Regards > >> > >> Lee > >> > >> SELECT /*+ INDEX(CONSUMER_COMM_D2C > CONSUMER_COMM_D2C_PK) */ > >> i.household_id > >> || '|' || 'd' > >> || '|' || d.promotion_item_id > >> || '|' || xp.campaign_id > >> || '|' || xp.document_id > >> || '|' || xp.segment > >> || '|' || xd.contact_type_code > >> || '|' > >> FROM genex_individual i > >> , consumer_comm_d2c d > >> , x_promotion_item xp > >> , x_document xd > >> WHERE i.brief_name = '$brief_name' > >> AND i.individual_id = d.consumer_id > >> AND d.promotion_item_id = xp.promotion_item_id > >> AND xp.document_id = xd.document_id > >> ORDER > >> BY i.household_id > >> ; > >> > >> Table CONSUMER_COMM_D2C is as follows > >> > >> NameNull?Type > >> --- > >> CONSUMER_ID NOT NULL > NUMBER(9) > >> PROMOTION_ITEM_ID NOT NULL > NUMBER(9) > >> COMMUNICATION_DATE NOT NULL DATE > >> COMMUNICATION_STATUS_CODE > VARCHAR2(2) > >> COMMUNICATION_DETAIL > VARCHAR2(500) > >> BLOCK_LDT NOT NULL DATE > >> ROW_CHANGE_SOURCE NOT NULL > NUMBER(9) > >> ROW_CHANGE_TIME DATE > >> ROW_CHANGE_USERID > VARCHAR2(50) > >> > >> Index CONSUMER_COMM_D2C_PK is built as follows > >> > >> consumer_id > >> promotion_item_id > >> communication_date. > >> > >> The table is partitioned on promotion_item_id and > the indexes on the > >> partitions are local > >> > >> Explain plan is as follows > >> > >> > >> Operation Object Name Rows Bytes Cost TQ > In/Out PStart PStop > >> > >> SELECT STATEMENT 1440 G 106 G > >> > >> SORT ORDER BY 1440 G 171770G 106 G > >> > >> MERGE JOIN 1440 G 171770G 17 M > >> > >> SORT JOIN 13 M 1G 300284 > >> > >> HASH JOIN 13 M 1G 10271 > >> > >> TABLE ACCESS FULL X_PROMOTION_ITEM 7 K 409 K > 10 > >> > >> MERGE JOIN CARTESIAN 2 M 90 M 3206 > >> > >> TABLE ACCESS FULL X_DOCUMENT 1 K 25 K 6 > >> > >> SORT JOIN 1 K 31 K 3200 > >> > >> TABLE ACCESS FULL GENEX_INDIVIDUAL 1 K 31 K 2 > >> > >> SORT JOIN 1 G 39G 17 M > >> > >> PARTITION CONCATENATED 1 26 > >> > >> TABLE ACCESS FULL CONSUMER_COMM_D2C 1 G 39G > 1352283 1 26 > >> > >> > >> > >> > >> > >> > * > >> > >> The information contained in this communication > is > >> confidential, is intended only for the use of the > recipient > >> named above, and may be legally privileged. > >> If the reader of this message is not the intended > >> recipient, you are hereby notified that any > dissemination, >
RE: RE: WebLogic, Oracle JDBC related
understood. :) -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, June 28, 2002 11:58 PM To: Multiple recipients of list ORACLE-L Just a poor choice of words on my part... - Original Message - Date: Friday, June 28, 2002 4:49 pm > Just curious, why recode just to switch drivers? > You can put the jdbc driver class and url in a .properties file > and load it from there. And keep url for both oci and thin in > there and just comment out the one you don't use. > > -Original Message- > Sent: Friday, June 28, 2002 4:38 PM > To: Multiple recipients of list ORACLE-L > > > That is correct, at least as far as 8.1.7 is concerned. We had to > recode our applications to use the jdbc:oci8 driver instead of > jdbc:thin. > > Brian > > -- > | Brian McGraw /* DBA */ Infinity Insurance | > | mailto:[EMAIL PROTECTED] | > -- > > -Original Message- > Gerardo > Sent: Friday, June 28, 2002 3:19 PM > To: Multiple recipients of list ORACLE-L > > I've also heard that thick driver is required for TAF (Transparent > Application Failover). Can someone confirm or refute this? > > Thanks, > Gerardo > > -Original Message- > Sent: Friday, June 28, 2002 12:49 PM > To: Multiple recipients of list ORACLE-L > > > The pure java thin driver is supposed to be faster because it does > not > incur a context switch between the oci and java, while the thick > driver > has better lob support. > > JDBC 3.0 is supposed to have improved lob support as well as > pooling, > but I don't believe the weblogic server can take advantage of it > yet... > Suzy Vordos wrote: > > IIRC, the WebLogic server startup script contains the > path/filename of > > which weblogic.properties file that is used, and it's passed as a > > command-line argument. > > > > At a previous job, one application we had used two properties files > > (Tim's gonna like this one :). One was weblogic.properties config'd > > with connection pooling and JDBC Thin. The other was > > application.properties, no connection pooling and JDBC OCI. The > > developer's reason? JDBC OCI was used to work with LOBs, and all > other > > database calls used JDBC Thin. It never made sense to me, but then > I'm > > not a Java developer either. > > > > "Deshpande, Kirti" wrote: > > > >>Thank you all who responded. I really appreciate it very much. > >>I am learning something new from you. > >> > >>I think I have enough 'ammunition' to ask some good(?) > questions. I > found > >>out that on one of the App servers, they use multiple > programs(Java?)to > >>support the Web traffic. There are multiple weblogic.properties > files.Some > >>have connection pooling setup (initialCapacity=3|1|5 maxCapacity=41 > with > >>increments of 2|1|3 and such) while others don't. The CLASSPATH > seemsto > be > >>a mile long! My hunch is that the App is releasing the entire > connection > >>pool and establishing it again when a new request comes along. That > may be > >>keeping the listener on the database servers very busy all the > times.>> > >>Following is a typical entry for Connection Pooling. No other > properties > are > >>defined for any other pools (related to shrink, refreshes etc), at > least I > >>did not find them in other properties files.. > >> > >>weblogic.jdbc.connectionPool.summaryPool_A=\ > >> url=jdbc:oracle:thin:@rs001-cs1:1541:AS1TRP,\ > >> driver=oracle.jdbc.driver.OracleDriver,\ > >> initialCapacity=3,\ > >> maxCapacity=41,\ > >> capacityIncrement=2,\ > >> props=user=;password= > >> > >>Thank you very much... > >> > >>- Kirti > >>-- > >>Please see the official ORACLE-L FAQ: http://www.orafaq.com > >>-- > >>Author: Deshpande, Kirti > >> INET: [EMAIL PROTECTED] > >> > >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >>San Diego, California-- Public Internet access / Mailing > Lists>> > > >>To REMOVE yourself from this mailing list, send an E-Mail message > >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >>the message BODY, include a line containing: UNSUB ORACLE-L > >>(or the name of mailing list you want to be removed from). You may > >>also send the HELP command for other information (like subscribing). > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Warren Lindsey > 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: UNS
Re: performance
I didn't mean to be so stiff on the reply -- sorry for that... The most common issues in the redo stream are certainly sizing and I/O. Yes, it can be quite cut-and-dried. But Ravi merely mentioned that "performance was slower" after enabling ARCHIVELOG mode and for all we know, it truly may have nothing to do with the redo logging stream whatsoever. It could be something else (i.e. bad SQL that someone recently slammed in at the same time) that neither Ravi (nor we) are aware of. It could be anything at all... So, making changes in the complete absence of information can easily end up with the following scenario: Ravi makes the recommended changes (i.e. add redo log groups, change group sizes, pester SysAdmins to create new file-systems to separate online from archived destinations, etc), all with no impact on performance. Thus, his credibility is harmed, if not totally destroyed. Happens all the time...(8 million stories in the naked city)... Better to look first, understand exactly what is happening, and act on real information. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 7:53 AM > I've assumed, that nothing changed beside ARCHIVE LOG mode. "when Our DB is > non-archive mode that was ok,when we moved to Archive, it is dead slow" > This directs to the question of I/O with archiving redo logs in first turn. > Doesn't it? What may be other direct performance issues of ARCHIVE LOG mode? > I admit that there is not enough information, which may easily make me > mistaken. However, there should be some general setup for archive log mode, > and that's what I gave. General setup should be made before moving to > archivelog mode and taken as basis for further tuning. > > Alexandre > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, July 01, 2002 2:43 PM > > > > Alexandre, > > > > I beg to differ. > > > > You have assumed, in the complete absence of any information, that he has > an > > I/O problem. He might. He also might not. He should look first, before > > leaping. > > > > -Tim > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Monday, July 01, 2002 1:53 AM > > > > > > > Ravi, > > > > > > Make sure you have at least 5-10 redo log groups. That's depends on your > > > workload. You also may need to increase their size. Think how much log > > info > > > your database can generate and size your logs that it would be enough > for > > 10 > > > mins at least. (Of course that would be pretty rough estimation) > > > Also make sure you put redo logs and arcived redo logs on differend > disks! > > > So that's for start. After, you may follow advice given in Tim's reply. > > > > > > hth > > > Alexandre > > > - Original Message - > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > Sent: Saturday, June 29, 2002 9:13 PM > > > > > > > > > > Dear All, > > > > > > > > Can any one please give me some hints or tips when we > > > > move to archive mode? when Our DB is non-archive mode > > > > that was ok,when we moved to Archive, it is dead slow. > > > > > > > > Obviosuly archive mode performance is slow, is there > > > > any other precations to be taken care? > > > > > > > > Thanks for your help. > > > > Cheers, > > > > Ravi > > > > > > > > __ > > > > Do You Yahoo!? > > > > Everything you'll ever need on one web page > > > > from News and Sport to Email and Music Charts > > > > http://uk.my.yahoo.com > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > -- > > > > Author: =?iso-8859-1?q?Nalla=20Ravi?= > > > > 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: Alexandre Gorbatchev > > > 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 containi
RE: ORA-27101 Error
Tom: I believe the problem is the same on Win as Unix. Here are some notes I made on this error. hope they help. Barb > When you start the database, a key for the shared memory segment is > calculated based on the contents of ORACLE_SID and ORACLE_HOME. When you > try to connect to the database, your process needs to find the shared > memory > segment. It does so by matching your oracle_sid and oracle_home against > this hashed key. (In the case of a network connection, it does this by > using > the oracle_sid and oracle_home in the listener.) > > > Check to see how your environment was set when you started the database > versus how it is set when you're trying to connect. In particular, if the > oracle_home path or the oracle_sid is different in any way,you'll get the > messages > > ORA-01034: ORACLE not available > ORA-27101: shared memory realm does not exist > SVR4 Error: 2: No such file or directory > > In my case, I had the sid as lower case for the session that started the > database, and upper case in the listener.ora file. > > Good luck! > > Barb > > > -- > From: Tom Schruefer[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Sunday, June 30, 2002 9:53 AM > To: Multiple recipients of list ORACLE-L > Subject: ORA-27101 Error > > ORA-27101 = Shared Memory Realm is not available > > I have seen references to this error and how to repair it on UNIX systems, > but what is to be done on Win2000 when this thing rears its ugly head? > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tom Schruefer > 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: Baker, Barbara 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: Hints being ignored
Do you know in what version this became the case? I certainly remember some hints being ignored in version 8.0. -Original Message- Sent: Saturday, June 29, 2002 5:58 AM To: Multiple recipients of list ORACLE-L A hint is absolutely, positively a DIRECTIVE, not a suggestion. Jonathan can explain if you have doubts. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 9-11 New York City - Hotsos Clinic, Jul 23-25 Chicago - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- Sent: Friday, June 28, 2002 7:08 PM To: Multiple recipients of list ORACLE-L Hints used to be more like that. hints are more like "do it" nowadays, their aggressiveness has gone up. joe basher 59 wrote: > When putting in hints, remember this bit of advise. A hint is just a > hint. Oracle may choose today to use your hit and tomorrow it may > not. I don't like using hints for this reason, and I usually try and > rewrite the query if I can. Have you analyzed the table lately. If > the table is not analyzed, it may not use the indexes. > > >> From: Robertson Lee - lerobe <[EMAIL PROTECTED]> >> Reply-To: [EMAIL PROTECTED] >> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >> Subject: Hints being ignored >> Date: Fri, 28 Jun 2002 06:13:19 -0800 >> >> All >> >> Oracle 8.0.5.0.0 >> >> Tru64 4.0f >> >> Select statement as follows. The hint is being totally ignored. Any >> ideas ?? >> >> Regards >> >> Lee >> >> SELECT /*+ INDEX(CONSUMER_COMM_D2C CONSUMER_COMM_D2C_PK) */ >> i.household_id >> || '|' || 'd' >> || '|' || d.promotion_item_id >> || '|' || xp.campaign_id >> || '|' || xp.document_id >> || '|' || xp.segment >> || '|' || xd.contact_type_code >> || '|' >> FROM genex_individual i >> , consumer_comm_d2c d >> , x_promotion_item xp >> , x_document xd >> WHERE i.brief_name = '$brief_name' >> AND i.individual_id = d.consumer_id >> AND d.promotion_item_id = xp.promotion_item_id >> AND xp.document_id = xd.document_id >> ORDER >> BY i.household_id >> ; >> >> Table CONSUMER_COMM_D2C is as follows >> >> NameNull?Type >> --- >> CONSUMER_ID NOT NULL NUMBER(9) >> PROMOTION_ITEM_ID NOT NULL NUMBER(9) >> COMMUNICATION_DATE NOT NULL DATE >> COMMUNICATION_STATUS_CODEVARCHAR2(2) >> COMMUNICATION_DETAIL VARCHAR2(500) >> BLOCK_LDT NOT NULL DATE >> ROW_CHANGE_SOURCE NOT NULL NUMBER(9) >> ROW_CHANGE_TIME DATE >> ROW_CHANGE_USERIDVARCHAR2(50) >> >> Index CONSUMER_COMM_D2C_PK is built as follows >> >> consumer_id >> promotion_item_id >> communication_date. >> >> The table is partitioned on promotion_item_id and the indexes on the >> partitions are local >> >> Explain plan is as follows >> >> >> Operation Object Name Rows Bytes Cost TQ In/Out PStart PStop >> >> SELECT STATEMENT 1440 G 106 G >> >> SORT ORDER BY 1440 G 171770G 106 G >> >> MERGE JOIN 1440 G 171770G 17 M >> >> SORT JOIN 13 M 1G 300284 >> >> HASH JOIN 13 M 1G 10271 >> >> TABLE ACCESS FULL X_PROMOTION_ITEM 7 K 409 K 10 >> >> MERGE JOIN CARTESIAN 2 M 90 M 3206 >> >> TABLE ACCESS FULL X_DOCUMENT 1 K 25 K 6 >> >> SORT JOIN 1 K 31 K 3200 >> >> TABLE ACCESS FULL GENEX_INDIVIDUAL 1 K 31 K 2 >> >> SORT JOIN 1 G 39G 17 M >> >> PARTITION CONCATENATED 1 26 >> >> TABLE ACCESS FULL CONSUMER_COMM_D2C 1 G 39G 1352283 1 26 >> >> >> >> >> >> * >> >> The information contained in this communication is >> confidential, is intended only for the use of the recipient >> named above, and may be legally privileged. >> If the reader of this message is not the intended >> recipient, you are hereby notified that any dissemination, >> distribution, or copying of this communication is strictly >> prohibited. >> If you have received this communication in error, >> please re-send this communication to the sender and >> delete the original message or any copy of it from your >> computer system. Thank You. >> > > > > > Over and out Basher 59 > > > _ > MSN Photos is the easiest way to share and print your photos: > http://photos.msn.com/support/worldwide.aspx > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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
Re: Twin City OUG Meeting
Yup. Talking about using STATSPACK with Oracle Apps... - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Monday, July 01, 2002 7:48 AM Subject: Twin City OUG Meeting Is anyone on this list going to attend the TCOUG meeting on July 18th.? Ken Janusz, CPIM
RE: ORA-27101 Error
Title: RE: ORA-27101 Error Tom, initially try typing this at a command prompt c:\>set|more and look for ORACLE_SID and ORACLE_HOME in the list of system variables to make sure these are set correctly. -Original Message- From: Tom Schruefer [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Subject: ORA-27101 Error ORA-27101 = Shared Memory Realm is not available I have seen references to this error and how to repair it on UNIX systems, but what is to be done on Win2000 when this thing rears its ugly head? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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).
Failover
Hi All, I have 11i running on OPS database with two instances. I assigned each instance to group of responsibilities but I have no idea how to configure the FAILOVER. If one instance goes down I want the user who has assigned this instance can transparently connect to the other instance. I'll appreciate any suggestion. Thank you, Kader __ 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: Kader Ben 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: Perl for Oracle DBAs....wow.
Jared, What's the possibility of seeing the Table of Contents, or an abstract of this? The title seems to have grabbed a lot of interest among us all. Rodd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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: Remove numbers from string
Title: RE: Remove numbers from string
select replace(translate('abcdefg123456hijkl12345abcd0','1234567890',' '),' ','')
from dual
/
REPLACE(TRANSLAT
abcdefghijklabcd
First, the numbers are translated into spaces, then the spaces are cleaned up, leaving the string
without numbers.
-Original Message-
From: Nils Höglund [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 7:18 AM
To: Multiple recipients of list ORACLE-L
Subject: Remove numbers from string
Is there any way to remove all numbers from a string?
The string might look like this: 'abc123def432'
and I wan't it to look like this: 'abcdef'.
I'm using Oracle 8.
Thanks in advance!
--
/Nils Höglund, Naqua KB
E-mail: [EMAIL PROTECTED]
Web: http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address: Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
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: How to handle embedded single quotes in procedure
Rick, Actually, it should work fine unless you are using dynamix sql, in which case, you can use the REPLACE function to add an additional single quote. Within the procedure you are calling, you may do the following: loc_quote varchar2(1) := ; REPLACE(value_to_be_inserted,loc_quote,loc_quote || loc_quote) I just had the exact same issued and the above solved the problem. You could use the REPLACE statment in an Insert or Update statement. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 01, 2002 11:35 AM To: Multiple recipients of list ORACLE-L Hi DBAs, I have strings that are being passed into parameters that contain embedded single quotes. Obviously this fails the insert and update statements. How can I handle these inside stored procedure? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: How to handle embedded single quotes in procedure
double up the quotes: 'string string string '' string string strin' will give you a string with one single quote within. p. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 01 July 2002 16:35 > To: Multiple recipients of list ORACLE-L > Subject: How to handle embedded single quotes in procedure > > > Hi DBAs, > > I have strings that are being passed into parameters that > contain embedded > single quotes. Obviously this fails the insert and > update statements. How can I handle these inside stored procedure? > > Thanks > Rick > > > -- > 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). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter 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: How to handle embedded single quotes in procedure
[EMAIL PROTECTED] wrote: > > Hi DBAs, > > I have strings that are being passed into parameters that contain embedded > single quotes. Obviously this fails the insert and > update statements. How can I handle these inside stored procedure? > > Thanks > Rick > replace(my_parameter, , '') -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to handle embedded single quotes in procedure
Hi DBAs, I have strings that are being passed into parameters that contain embedded single quotes. Obviously this fails the insert and update statements. How can I handle these inside stored procedure? Thanks Rick -- 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: Activating replication
Well, I was thinking about replicatin related sys-owned procedures only!!! Actual data replication is on behalf of my own planning, of course! I don't expect catrep.sql to quess my thoughts and do job instead of me! Regards, Vladimir Barac - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 4:53 PM > not even close > > read the docs... all that running catrep does is load the stored > procedures you will need to use. > > You need to decide on > > multi-master vs materialized view replication > if materialized view: >read-only, updateable, writeable > > synchronous or asynchronous > > and that's just to determine which kind of replication you want to be > running. Then you actually have to implement it. > > Rachel > > --- Vladimir Barac - posao <[EMAIL PROTECTED]> wrote: > > Hi > > > > Oracle 8.1.7 EE > > > > both Win2000 and Solaris > > > > Is running catrep.sql really, really, really all that is needed to > > activate replication in 8i? > > > > > > > > > __ > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao 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: dblink / global names explanation please
global_names enforcing db_links to be named service_name.domain. The workaround it to change it for your session: alter session set global_names=false. Shaw John-P55297 wrote: > > 8.1.6 on NT > I have java installed and a java email package on instance A on a server. > One the same server on instance B with global names set to false I created a > public database link to instance A, then created a public synonym javamail > for my email routine at A. This worked. On a third instance ( C ) on this > same server with gobal names set to true (do you see where this is going) I > did the same thing as I had done on instance B - but I couldn't use a short > name - I had to use the full A.moto.com. Then I created a public synonym for > the [EMAIL PROTECTED] This kept returning an error - couldn't find class > com/moto/utils/mail - this is a home grown java class in the database A. > I could not find anything different between the two setups other than one > had global names set to false and the other had global names set to true > (after many hours of looking and head banging) - so I just tried setting > global names to false on instance C and bounced the database - went back and > created a new short named public database link and then created the public > synonym. It now worked ? WHY ?? can any one tell why this works or > doesn't as the case may be? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Shaw John-P55297 > 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: Suzy Vordos 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: ORA-600 during replication
Hi. This error signals a potential data corruption, but, examine the other messages for a more complete description of the problem. about the ora-12008 A number of events could cause this problem, among them the following: The master table no longer exists. A column was added to the master table, and the view was not altered. The master is at a remote site and inaccessible. Also suggest you try changing the refresh of the snapshot for FAST or you may need to generate an event 10046 trace so youcan see exactly which statement is failing. Alessandro Guimarães P.S. Brazil is five times world championship (Futebol) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 4:38 AM > Hi, > > Upload your trace file to iOraBugFinder at > http://www.ubtools.com/products/iorabugfinder/iorabugfinder.html . > > regards... > > Vladimir Barac - posao wrote: > > > Good morning / afternoon/ evening (depending on your position)... > > > > Alert log has following lines... > > > > Tue Jun 25 10:07:30 2002 > > Errors in file E:\Oracle\admin\vurs\bdump\vursSNP2.TRC: > > ORA-12012: error on auto execute of job 123 > > ORA-12008: error in snapshot refresh path > > ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], > > [], > > [], [], [] > > ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 > > ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 > > ORA-06512: at "SYS.DBMS_IREFRESH", line 577 > > ORA-06512: at "SYS.DBMS_REFRESH", line 211 > > ORA-06512: at line 1 > > > > What the hell is going on? I tried to do some search on metalink, but to no > > avail. > > > > Hate to say this, but it is kind of urgernt! > > > > Regards, > > Vladimir Barac > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Vladimir Barac - posao > > 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). > > -- > Danisment Gazi Unal > http://www.ubTools.com > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Danisment Gazi Unal (ubTools) > 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: Alessandro Guimaraes 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: Confused: Oracle OCP
Yeah right... and not get the fees for the exams? That was an analogy. Personally, I wish the OCP requirements included at least one class in basic writing skills Oh, and I was incorrect, as of last month, if you had not started the certification process for OCP you are required to take the $2000 class as well --- KENNETH JANUSZ <[EMAIL PROTECTED]> wrote: > Rachel: > > I have an Assoc. EE, B.S. and an MBA. Does this mean Oracle will > automatically give me all three certificates? > > Thanks, > Ken Janusz, CPIM > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, July 01, 2002 8:58 AM > > > > think of it as > > > > OCA is the Oracle equivalent of getting an Associate's degree from > a > > college > > OCP is the Bachelor's degree > > OCM is the Master's degree > > > > not exact but close enough for Oracle. > > > > The $2000 class is a requirement ONLY for OCM. Most companies do > not > > look for OCM on a resume, at least not yet. > > > > > > --- [EMAIL PROTECTED] wrote: > > > Ok, > > > > > > The current *threads* on the subject have persuaded me to > pursue > > > the OCP.. I remember the thread about the $2000 course. But > I > > > thought that this was for Oracle Masters, NOT OCP... > > > > > > Can anyone clarify this OCA, OCP, Masters thing hey and > what > > > ever happened to DBO? > > > > > > Guess the main question is do I need that $2000 course JUST > to > > > get my OCP.. the vanilla version:> > > > > > > Agh! > > > > > > Regardless, I feel I am going to have to do it. > > > > > > > > > Hannah > > > > > > > > > __ > > 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). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: KENNETH JANUSZ > 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: Activating replication
No, caprep.sql simply builds the data dictionary views for Replication. For the schemas you want to replicate, there is a mountain of planning and configuration to do after that. Implementing replication isn't something you can approach casually, so check out the following admin guides: http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76959/toc.htm http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76958/toc.htm > Vladimir Barac - posao wrote: > > Hi > > Oracle 8.1.7 EE > > both Win2000 and Solaris > > Is running catrep.sql really, really, really all that is needed to > activate replication in 8i? > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos 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: Activating replication
Hi, Yes. But just the catalog tables o replication are created Alessandro - Original Message - From: Vladimir Barac - posao To: Multiple recipients of list ORACLE-L Sent: Monday, July 01, 2002 7:13 AM Subject: Activating replication Hi Oracle 8.1.7 EE both Win2000 and Solaris Is running catrep.sql really, really, really all that is needed to activate replication in 8i?
RE: Confused: Oracle OCP
Thank you Rachel! > -Original Message- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Rachel Carmichael ><[EMAIL PROTECTED]> > Sent: Monday, July 01, 2002 9:58 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Confused: Oracle OCP > > think of it as > > OCA is the Oracle equivalent of getting an Associate's degree from a > college > OCP is the Bachelor's degree > OCM is the Master's degree > > not exact but close enough for Oracle. > > The $2000 class is a requirement ONLY for OCM. Most companies do not > look for OCM on a resume, at least not yet. > -- 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: Activating replication
not even close read the docs... all that running catrep does is load the stored procedures you will need to use. You need to decide on multi-master vs materialized view replication if materialized view: read-only, updateable, writeable synchronous or asynchronous and that's just to determine which kind of replication you want to be running. Then you actually have to implement it. Rachel --- Vladimir Barac - posao <[EMAIL PROTECTED]> wrote: > Hi > > Oracle 8.1.7 EE > > both Win2000 and Solaris > > Is running catrep.sql really, really, really all that is needed to > activate replication in 8i? > > > __ 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).
Peopletools upgrade
Hi All, Has anybody upgraded people tools 7.5 to 8 already? If so, have you found a solution for the high amount of parsing the app does (a lot of statements are parsed twice and executed once.) Also I see that a lot of almost identical statements in the sql area (username difference) which indicated no use of bind variables for this query. How is your experience with cursor_sharing=force (hear a lot about bugs) Any other thing you found that might improve things .mind you performance is not considered to be dramatic (apart from certain app generated sql) but before people start asking for performance imrovements I thought I'd be prepared. any input apreciated. TIA === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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: Confused: Oracle OCP
Rachel: I have an Assoc. EE, B.S. and an MBA. Does this mean Oracle will automatically give me all three certificates? Thanks, Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 8:58 AM > think of it as > > OCA is the Oracle equivalent of getting an Associate's degree from a > college > OCP is the Bachelor's degree > OCM is the Master's degree > > not exact but close enough for Oracle. > > The $2000 class is a requirement ONLY for OCM. Most companies do not > look for OCM on a resume, at least not yet. > > > --- [EMAIL PROTECTED] wrote: > > Ok, > > > > The current *threads* on the subject have persuaded me to pursue > > the OCP.. I remember the thread about the $2000 course. But I > > thought that this was for Oracle Masters, NOT OCP... > > > > Can anyone clarify this OCA, OCP, Masters thing hey and what > > ever happened to DBO? > > > > Guess the main question is do I need that $2000 course JUST to > > get my OCP.. the vanilla version:> > > > > Agh! > > > > Regardless, I feel I am going to have to do it. > > > > > > Hannah > > > > > __ > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KENNETH JANUSZ 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).
Oracle8i Upgrade Exam Material
I am going to be taking the Oracle8i: New Features for Administrators (1Z0-020) exam and am looking for study materials. Can anyone recommend and books for this exam? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams 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: Remove numbers from string
Instead of "#" character, replace with an unprintable character such as
"CHR(1)"?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 01, 2002 6:43 AM
On Monday 01 July 2002 14:09, Nils Höglund wrote:
> > You may have to
> > use an intermediate stage, first replacing all numbers by say '#', then
> > replacing '#' by ''.
>
> This is something I would like to avoid, since my string-fields may
contain
> any characters.
>
> Any ideas?
SELECT TRANSLATE('abc123def432'
,'A0123456789','A') "replaced" FROM DUAL;
JP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
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: Tim Gorman
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: exp73 dumpparam for unlimited extents?
LMTs came with 8i (8.1.5 afaik) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 3:18 PM > I don't believe LMTs are supported in 7.3.x... > > > --- Don Granaman <[EMAIL PROTECTED]> wrote: > > With compress=N, you will get essentially the same mish-mash of > > extents you > > had previously - unless you are importing into a LMT. > > > > You have basically two options: > > > > 1) Pre-create the objects with a storage clause specifying the extent > > sizes > > you want - with initial and next the same size. Then import with > > ignore=Y. > > Of course, if you drop the users, you will have to recreate them > > before > > pre-creating the objects. This is the only option for > > dictionary-managed > > tablespaces to get uniform extents. (Hint: imp ... > > indexfile=somefilename.sql ..., edit somefilename.sql to (1) > > uncomment the > > create table statements and (2) modify storage clauses, then run > > somefilename.sql. If the export is large, you may wish to split this > > into > > two parts - one for the tables and one for the indexes and > > constraints. (It > > is a little more complicated than it might seem at first, but isn't > > too bad. > > One possible approach is to perform one export with rows=Y indexes=N > > constraints=N and another with rows=N indexes=Y constraints=Y. > > Details left > > as an exercise for the reader ;-) > > > > 2) Convert the tablespace(s) to LMT(s) with uniform extents - or drop > > and > > recreate them as such - prior to the import. > > > > In the vast majority of cases, (2) is preferred. > > > > Don Granaman > > [certifiable OraSaurus] > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Saturday, June 29, 2002 11:53 PM > > > > > > Hello, > > > > Running Oracle 7.3.4.4 on Win2k. > > Trying to implement unlimited extents of the same size. (Same size > > works > > for us). > > Set the tablespace defaults > > Dumped the users > > Dropped the users > > Imported the users > > > > Tables still had the same mish-mash of extents and max extents 121 > > > > Here are my dump params > > USERID = system/@** > > FILE = c:\dumps\test.dmp > > LOG = c:\dumps\test.log > > FULL = Y > > buffer=100 > > consistent=y > > compress=n > > > > That did not work so I tried dumping an individual user > > USERID = system/*@*** > > FILE = c:\dumps\test.dmp > > LOG = c:\dumps\test.log > > FULL = N > > COMPRESS = N > > owner=restek > > > > Still get mish-mash extents on import. > > > > The load was always: > > USERID = system/**@* > > FILE = c:\dumps\test.dmp > > LOG = c:\dumps\test.dmprs.implog > > FROMUSER = restek > > TOUSER = restek > > > > My quick test of create table tmp_xyz as select * from xyz gives me > > the > > result I want. > > > > Any suggestions? Do I have to wait until I upgrade to 8i or 9i? > > > > TIA > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Robert Monical > > 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: Don Granaman > > 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 PR
Activating replication
Hi Oracle 8.1.7 EE both Win2000 and Solaris Is running catrep.sql really, really, really all that is needed to activate replication in 8i?
Re: Confused: Oracle OCP
think of it as OCA is the Oracle equivalent of getting an Associate's degree from a college OCP is the Bachelor's degree OCM is the Master's degree not exact but close enough for Oracle. The $2000 class is a requirement ONLY for OCM. Most companies do not look for OCM on a resume, at least not yet. --- [EMAIL PROTECTED] wrote: > Ok, > > The current *threads* on the subject have persuaded me to pursue > the OCP.. I remember the thread about the $2000 course. But I > thought that this was for Oracle Masters, NOT OCP... > > Can anyone clarify this OCA, OCP, Masters thing hey and what > ever happened to DBO? > > Guess the main question is do I need that $2000 course JUST to > get my OCP.. the vanilla version:> > > Agh! > > Regardless, I feel I am going to have to do it. > > > Hannah > __ 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: performance
I've assumed, that nothing changed beside ARCHIVE LOG mode. "when Our DB is non-archive mode that was ok,when we moved to Archive, it is dead slow" This directs to the question of I/O with archiving redo logs in first turn. Doesn't it? What may be other direct performance issues of ARCHIVE LOG mode? I admit that there is not enough information, which may easily make me mistaken. However, there should be some general setup for archive log mode, and that's what I gave. General setup should be made before moving to archivelog mode and taken as basis for further tuning. Alexandre - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 2:43 PM > Alexandre, > > I beg to differ. > > You have assumed, in the complete absence of any information, that he has an > I/O problem. He might. He also might not. He should look first, before > leaping. > > -Tim > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, July 01, 2002 1:53 AM > > > > Ravi, > > > > Make sure you have at least 5-10 redo log groups. That's depends on your > > workload. You also may need to increase their size. Think how much log > info > > your database can generate and size your logs that it would be enough for > 10 > > mins at least. (Of course that would be pretty rough estimation) > > Also make sure you put redo logs and arcived redo logs on differend disks! > > So that's for start. After, you may follow advice given in Tim's reply. > > > > hth > > Alexandre > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Saturday, June 29, 2002 9:13 PM > > > > > > > Dear All, > > > > > > Can any one please give me some hints or tips when we > > > move to archive mode? when Our DB is non-archive mode > > > that was ok,when we moved to Archive, it is dead slow. > > > > > > Obviosuly archive mode performance is slow, is there > > > any other precations to be taken care? > > > > > > Thanks for your help. > > > Cheers, > > > Ravi > > > > > > __ > > > Do You Yahoo!? > > > Everything you'll ever need on one web page > > > from News and Sport to Email and Music Charts > > > http://uk.my.yahoo.com > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: =?iso-8859-1?q?Nalla=20Ravi?= > > > 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: Alexandre Gorbatchev > > 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: Tim Gorman > 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: Alexandre Gorbatchev 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
RE: control file I/O significantly changed
Paula, It would help if you told us which version you are using and seeing this change in. I believe that with 9i more is written to the control files. I know that if you are using RMAN this is the case You can also dump the control files to see what is in them. Are they larger than they used to be? Rachel --- [EMAIL PROTECTED] wrote: > Guys, > > It appears to me that control files are being written to continously > versus > only during checkpoints. I.E. the I/O behaviour of control files has > changed significantly. Does anyone have any good doc. on this? Is > it an > intentional architectural change? > > Thanks, > Paula > __ 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: Rollback OPTIMAL setting
rule 4 ALWAYS applies.. no matter what version of the database :) --- Don Granaman <[EMAIL PROTECTED]> wrote: > As far as I know, the jury is still out - I haven't had a chance yet > to see > if (a) the problems Dan found in 9.0.1.1 are fixed and (2) I like the > way it > works. Also, it does require 9i and I'm not yet ready to go there > with > everything. Even with 9i and system managed undo, rule #4 will still > be in > effect! > > Don Granaman > [certifiable OraSaurus] > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Saturday, June 29, 2002 9:38 PM > > > Don, > > 9i has system managed undo -- you don't think it works yet? > > Rachel > > --- Don Granaman <[EMAIL PROTECTED]> wrote: > > I prefer to have OPTIMAL set and deal with "long running large > > transactions" > > another way - setting "OPTIMAL" on the developers! Granted, this > > doesn't > > work for 3rd party products, but I usually deal with in-house > > applications. > > Getting this to work requires: (1) having enough rollback segments, > > (2) > > large enough rollback segments that extends almost never occur, and > > (3) NOT > > having the "one giant rollback segment for large jobs", and, most > > importantly, (4) all "batch-lookin' thingies" have to be reviewed > by > > the DBA > > and optimized, by either the DBA or the developer - or both, until > > they pass > > muster. Using this, I rarely seen an ORA-01555 or a rollback > shrink > > (over > > six months on the systems I'm working with now) - and when I do, I > > know that > > it (usually) means that somebody broke rule #(4). When that > happens, > > I > > track it down and work with the developer to fix it. My experience > > is that > > the vast majority of developers are receptive - they actually like > to > > have > > their code run without problems. > > > > Of course, this assumes that the "wasted" disk space for (1) and > (2) > > is not > > a significant issue. It rarely is, but I work almost exclusively > > with > > (essentially) OLTP systems where space is typically less critical > > than I/O > > throughput capability and reliability. Usually, we have to add > disks > > for > > performance rather than space. The database datafile drives are > > typically > > 36 GB (less often 18 GB) and are rarely "full", so a GB or two more > > for > > rollback tablespace is OK. If I had to operate under the space > > constraints > > that many seem to have, I might not set OPTIMAL either. > > > > I am looking forward to the day that this "no OPTIMAL" suggestion > > fades into > > the "myths and folklore" category. Either because of basic policy > > changes > > (e.g. the extents myth), a better Oracle algorithm (e.g. 10i system > > managed > > undo???), more intelligently designed batch processes in > > applications, or > > the trend towards ever-increasing drive size. > > > > Note: All this doesn't mean that I don't understand why so many use > > the > > "manual shrink" method. My philosophy differs in that not setting > > OPTIMAL > > should be a last resort, not a blanket policy. > > > > Don Granaman > > [OraSaurus] > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Thursday, June 27, 2002 10:13 AM > > > > > > One of the constant comments regarding rollback segments is not to > > set > > optimal. I am wondering why this setting is often discouraged. I > have > > my own > > ideas, but I want to gather more opinions and experiences. > > > > Daniel W. Fink > > Sr. Oracle DBA > > MICROMEDEX > > 303.486.6456 > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Don Granaman > > 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 messag
Re: Confused: Oracle OCP
Hannah, Main answer - Yes, you do. You need this practice "hands-on" 2000$ exam for OCP if you are not OCP for any older versions. like 7, 8, 8i. For OCM you need even more... 2 classes from Oracle (which are costly) plus 2-days (not sure how many days) "hands-on" exam. Too expensive. (hope Oracle will smash up on OCM :-) Alexandre - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, July 01, 2002 2:28 PM Subject: Confused: Oracle OCP Ok, The current *threads* on the subject have persuaded me to pursue the OCP.. I remember the thread about the $2000 course. But I thought that this was for Oracle Masters, NOT OCP... Can anyone clarify this OCA, OCP, Masters thing hey and what ever happened to DBO? Guess the main question is do I need that $2000 course JUST to get my OCP.. the vanilla version:> Agh! Regardless, I feel I am going to have to do it. Hannah
Twin City OUG Meeting
Is anyone on this list going to attend the TCOUG meeting on July 18th.? Ken Janusz, CPIM
Re: Confused: Oracle OCP
Hanna: You can review this on Oracles web site. I believe that the Masters certificate is the last in the line. First there is OCA, then OCP and then OCP Masters (I believe). So I think what you end up with is three OCP certifications. My $0.02 worth, Ken Janusz, CPIM - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, July 01, 2002 7:28 AM Subject: Confused: Oracle OCP Ok, The current *threads* on the subject have persuaded me to pursue the OCP.. I remember the thread about the $2000 course. But I thought that this was for Oracle Masters, NOT OCP... Can anyone clarify this OCA, OCP, Masters thing hey and what ever happened to DBO? Guess the main question is do I need that $2000 course JUST to get my OCP.. the vanilla version:> Agh! Regardless, I feel I am going to have to do it. Hannah
