RE: Interesting!

2003-06-04 Thread Jacques Kilchoer
Title: RE: Interesting! > -Original Message- > From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] > > > I've just discovered this, never thought if it was possible or not. > Just wanted to share it with you, so forgive me if you know > it already. >

Re: Interesting!

2003-06-04 Thread AK
we use it quite often to make logic looks simple like .. Procedure create_oe_line procedure add_order procedure make_adjustment procedute create_delivery Begin add_order; make_adjustment; create_delivery; End create_oe_li

RE: Interesting!

2003-06-04 Thread Steve McClure
My first real PL/SQL program used this technique. Of course since it was my first program I ran into a very annoying variable scope issue. Of course after spending hours debugging the code, I realized I should have taken the advice of our DBA, the infamous Jared Still, and just used a package. I

RE: Interesting!

2003-06-04 Thread Jamadagni, Rajendra
Title: RE: Interesting! Yup ... called as local procedures and functions ... we use it all the time. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal

RE: Interesting!

2003-06-05 Thread Khedr, Waleed
I think it's good to have (forgive me Jared :)). It reminds me with Pascal language. Waleed -Original Message- Sent: Tuesday, June 03, 2003 9:40 PM To: Multiple recipients of list ORACLE-L My first real PL/SQL program used this technique. Of course since it was my first program I ran

RE: Interesting!

2003-06-05 Thread Igor Neyman
n the scope of the proc/func you define them in. Otherwise you would end up with duplicate code. Did I miss anything ? Stefan -Ursprüngliche Nachricht- Von: Khedr, Waleed [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 4. Juni 2003 16:20 An: Multiple recipients of list ORACLE-L Betreff: RE: Int

RE: Interesting!

2003-06-05 Thread Pardee, Roy E
sprüngliche Nachricht- Von: Khedr, Waleed [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 4. Juni 2003 16:20 An: Multiple recipients of list ORACLE-L Betreff: RE: Interesting! I think it's good to have (forgive me Jared :)). It reminds me with Pascal language. Waleed -Original Messag

RE: Interesting!

2003-06-05 Thread Niall Litchfield
f list ORACLE-L > Subject: RE: Interesting! > > > I think it's good to have (forgive me Jared :)). > It reminds me with Pascal language. > > Waleed > > -Original Message- > Sent: Tuesday, June 03, 2003 9:40 PM > To: Multiple recipients of list OR

RE: Interesting!

2003-06-05 Thread Jared . Still
AIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/04/2003 10:40 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Interesting! I think, you did. Using packages you still can "hide" proced

Re: interesting article...

2003-10-08 Thread Mladen Gogala
At the moment, I'm more interested in the new governator of California then Larry Ellison. Even if oracle is out, I'll be able to do other things. As a former VAX/VMS system administrator, believe me, I know. On Wed, 2003-10-08 at 11:29, Chris Stephens wrote: > http://www.eweek.com/article2/0,414

RE: interesting article...

2003-10-08 Thread Mercadante, Thomas F
Title: RE: RE: Cary's Book - new topic it is interesting.  but who knows if this person's opinions are correct.  should we start "shorting" Oracle stock?   -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 08, 2003 11:29 AMTo: Multiple re

RE: interesting article...

2003-10-08 Thread Thomas Day
I'm just hoping that Larry won't loose interest in the next 10 years. After that, he can sell out to CA anytime. "Mercadante,

RE: interesting article...

2003-10-08 Thread Orr, Steve
recipients of list ORACLE-LSubject: RE: interesting article... it is interesting.  but who knows if this person's opinions are correct.  should we start "shorting" Oracle stock?   -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]Sent: Wednes

Re: Interesting Problem

2001-08-25 Thread A. Bardeen
Srikanth, What is the NLS_LANG setting of the clients using the front-end app? Sounds like they're set to US7ASCII so they would automatically replace any extended ascii characters with a '?'. I know at one point the default NLS_LANG setting for Windows clients was US7ASCII, but I can't remembe

RE: Interesting News..

2001-09-04 Thread Robertson Lee - lerobe
You bet your arse its interesting considering we are 100% Compaq Tru64 Sent ructions across the UNIX S.As here this morning I can tell you. I did HP-UX admin training a year or so ago... now where did I put my course manuals ?? Lee -Original Message- Sent: 04 September 2001 15:02

Re: Interesting News..

2001-09-04 Thread Jared Still
HP Acquiring Compaq? Yow! That's big news! Anyone see this coming? I would have never guessed. Jared On Tuesday 04 September 2001 07:02, Mark Leith wrote: > Thought this would interest you guys.. > > http://www.theitportal.com/ITPFrameSetBottom.asp?Path=http%3A%2F%2Fwww%2Ema >c > world%2Eco%

RE: Interesting News..

2001-09-04 Thread Christopher Spence
I think there were a few hints, but the biggest thing with this merger is now HP has 87 billion in income, compared to IBM's 90 billion. Ibm is gaining market share and becoming a giant, now they have a decent size competitor. "Do not criticize someone until you walked a mile in their shoes, tha

RE: Interesting News..

2001-09-04 Thread Walthour, Jon (GEAE, Compaq)
Jared: It's the buzz of the office this morning. No one here seems to have seen it coming. Jon Walthour Oracle Database Administrator COMPAQ DBA Team Cincinnati, Ohio -Original Message- Sent: Tuesday, September 04, 2001 12:33 PM To: Multiple recipients of list ORACLE-L HP Acquiring C

Re: Interesting News..

2001-09-04 Thread Ruth Gramolini
Many years ago, when I was a system manager on an HP-3000 system, Compac was using the HP3000 database. This relationship goes back a long way. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 04, 2001 12:32 PM > > HP Acq

RE: Interesting News..

2001-09-04 Thread Kevin Kostyszyn
I certainly didn't!! Is this going to be like a merge? What I mean is, is there still going to be Compaq machines and HP machines? Or will it be like Hewlett Compaqerd? Just wondering? -Original Message- Sent: Tuesday, September 04, 2001 12:33 PM To: Multiple recipients of list ORACLE

RE: Interesting News..

2001-09-04 Thread Farnsworth, Dave
Jon, You got your resume ready?? I hope all goes well for you and your co-workers. Dave -Original Message- Sent: Tuesday, September 04, 2001 12:07 PM To: Multiple recipients of list ORACLE-L Jared: It's the buzz of the office this morning. No one here seems to have seen it coming.

RE: Interesting News..

2001-09-04 Thread Christopher Spence
HP is the top one, from what I understand from what I have heard, they are going to rebrand the compaq hardware. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone

RE: Interesting News..

2001-09-04 Thread mohammed bhatti
I'm curious. What happens to Tru64 or HP-UX? One of them's got to go, would'nt you think? How about their Unix servers? I know they're both going to 64-bit Itanium eventually, but can they support both product lines? Wonder how VAX/VMS is going to fare? How does this effect Sun? I'd say thi

RE: Interesting News..

2001-09-04 Thread Boivin, Patrice J
Now every part in the alphas is going to have three ID numbers: one Digital, one Compaq, and one HP number. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat Cit

RE: Interesting News..

2001-09-04 Thread Vergara, Michael (TEM)
My 2-cent's worth... I was (and still am) a big fan of the VMS operating system. I used it on a VAXcluster where we hosted our Oracle v5, v6 and early v7 development environments. (clusters! what a concept!) I'm just not sure how long it will take to get used to "HP-VMS". ---

RE: Interesting News..

2001-09-04 Thread Jon Baker
Title: RE: Interesting News.. That's  HP-OpenVMS to you, buddy!!! ;-) I miss VMS.  Ah, the days. Jon -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 4:16 PM To: Multiple recipients of list ORACLE-L Subjec

RE: Interesting News..

2001-09-05 Thread Guy Hammond
On the contrary, I'd say this is a godsend for Sun. Compaq made a mess of truly epic proportions when they tried to integrate DEC and Tandem into their operations. HP did just as badly with Apollo. There are going to be bitter turf wars between the HP/UX and Tru64 (or Ultrix or whatever it's calle

Re: Interesting News..

2001-09-05 Thread Stephane Faroult
I agree. First of all there is no certainty that the marriage will ever be consummed (there has been a lot of corporate engagement break-ups in the past years. Remember GE/Honeywell, Jack Welch's apotheosis? German and French banks? Pharmacy?). There's too much overlap between the two (all those s

RE: Interesting News..

2001-09-05 Thread Miller, Jay
More agreement. How many companies did AT&T buy only to drive them into the ground? How much advantage did Compaq take of the impressive Alpha technology? These mega mergers rarely produce anything much. Unless the HP strategy is to run Compaq's product line into the ground so more people turn t

RE: Interesting News..

2001-09-05 Thread Hand, Michael T
Interesting to say the least. We have a meeting with our Compaq reps tomorrow to discuss the Alpha processor move to Intel. I'll put money down that a discussion of the HP/Compaq merger will eclipse Alpha/Intel. If anything worthwhile comes up, I'll let you all know. Mike Hand Polaroid Corp.

RE: Interesting News..

2001-09-05 Thread Stephen Andert
In fact today's Wall Street Journal quotes HP's CEO as saying the Compaq name will go away.  I guess running it into the ground would take too much time so she is just going to abandon the Compaq name.  They did say they plan to keep some of the "valuable sub-brands" like Presario.    We cu

RE: Interesting News..

2001-09-05 Thread Steven Lembark
-- "Miller, Jay" <[EMAIL PROTECTED]> > More agreement. How many companies did AT&T buy only to drive them into > the ground? How much advantage did Compaq take of the impressive Alpha > technology? These mega mergers rarely produce anything much. > Unless the HP strategy is to run Compaq's pr

RE: Interesting News..

2001-09-05 Thread Arich Henneman
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -

RE: Interesting News..

2001-09-05 Thread Arich Henneman
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -

Re: Interesting query

2001-06-27 Thread Connor McDonald
select count(*) from table where a_column = ( select cdk(123) from dual where rownum = 1 ) or you can use DISTINCT or a NO_MERGE hint - anything to force the subquery to be evaluated in isolation hth connor --- David Turner <[EMAIL PROTECTED]> wrote: > My users are writing many of their own

Re: Interesting query

2001-06-27 Thread Rocky Welch
Hi David, Can you have them write the query with a variable then populate the variable with the function? -Rocky --- David Turner <[EMAIL PROTECTED]> wrote: > My users are writing many of their own functions and it is causing > performance to suffer > on a few simple queries. For example, I have

RE: Interesting query

2001-06-27 Thread Khedr, Waleed
select count(*) from a_table where a_column = (select cdk(1234567890) from dual); Regards, Waleed -Original Message- Sent: Wednesday, June 27, 2001 3:01 PM To: Multiple recipients of list ORACLE-L My users are writing many of their own functions and it is causing performance to suffer

RE: Interesting News..

2001-09-06 Thread Eric D. Pierce
According to our hardware resalescritter: especially for anything below large enterprise level, both HP and Compaq services suck. so, I guess the objective is to create a new company who services suck even more than either individually? Synergy!!! > Guy Hammond wrote: > > > > On

RE: Interesting News..

2001-09-06 Thread Ken Janusz
And then Computer Associates can buy the new company and it will suck X 3. -Original Message- Sent: Thursday, September 06, 2001 3:22 PM To: Multiple recipients of list ORACLE-L According to our hardware resalescritter: especially for anything below large enterprise level, both HP and

RE: Interesting News..

2001-09-07 Thread Walthour, Jon (GEAE, Compaq)
Eric: While I can appreciate that your opinion of the Compaq Services division might be less than positive, would you please, for the sake of those who actually work for these companies, be a little less dramatic in your expression of that opinion. Jon Walthour Oracle Database Administrator COMP

RE: Interesting News..

2001-09-07 Thread Kimberly Smith
Jon, you need to get some thick skin. My company is destroyed quite often in this list (although it has been a while). -Original Message- Sent: Friday, September 07, 2001 4:50 AM To: Multiple recipients of list ORACLE-L Eric: While I can appreciate that your opinion of the Compaq Serv

RE: Interesting News..

2001-09-07 Thread Christopher Spence
I refrained to mention the problems I had with compaq. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princ

RE: Interesting News..

2001-09-10 Thread Eric D. Pierce
No. I'm more interested in what happens to the customer. [via ORACLE-L Digest -- Volume 2001, Number 251] > -- > > From: "Walthour, Jon (GEAE, Compaq)" <[EMAIL PROTECTED]> > Date: Fri, 7 Sep 2001 06:50:52 -0400 > Subje

RE: Interesting News..

2001-09-10 Thread Mohan, Ross
t; > From: "Walthour, Jon (GEAE, Compaq)" <[EMAIL PROTECTED]> > Date: Fri, 7 Sep 2001 06:50:52 -0400 > Subject: RE: Interesting News.. > > Eric: > > While I can appreciate that your opinion of the Compaq Services division > might be less than positive, would yo

RE: Interesting News..

2001-09-10 Thread Eric D. Pierce
Jon, Believe it or not, some people *DO* know they are getting screwed even if the person doing it is being superficially "polite". regards, ep On 10 Sep 2001, at 19:19, Walthour, Jon (GEAE, Compaq) <[EMAIL PROTECTED]> wrote: To: [EMAIL PROTECTED] Date sent: M

RE: Interesting News..

2001-09-10 Thread Walthour, Jon (GEAE, Compaq)
After thinking about this whole thing further, I realize I've made a terrible mistake. I've stooped to his level rather than stay mature about the whole thing and let it go. It won't happen again. To all of you who've had to receive these messages, I'm sorry. I'm done with this thread. Jon Waltho

RE: Interesting News..

2001-09-11 Thread Mohan, Ross
So, as you devote the extra minutes to your job, does this mean COMPAQ customer service will get better or worse? -Original Message- Sent: Monday, September 10, 2001 10:50 PM To: Multiple recipients of list ORACLE-L After thinking about this whole thing further, I realize I've made a

Re: Interesting News..

2001-09-11 Thread Jared Still
OK, folks, let's stop this thread now. It's well gone beyond the bounds of good taste, and has turned into a cesspool of vitriol. Let's confine discussion to Oracle topics. If you want to go off topic, please take it offline. Jared ( list owner ) -- Please see the official ORACLE-L FAQ: http

RE: Interesting News..

2001-09-11 Thread Walthour, Jon (GEAE, Compaq)
Well, I can't speak for all of Compaq. But my part (supporting GE Aircraft Engines) is now and will continue to be receiving great service from Compaq. Jon Walthour -Original Message- Sent: Tuesday, September 11, 2001 10:40 AM To: Multiple recipients of list ORACLE-L So, as you devote

RE: interesting sql question

2003-09-29 Thread Mercadante, Thomas F
Ralph, Assuming that there is no history in the BIDS table (meaning that there are no "old" records indicating a bid recorded last year), I think the following would work just fine. select name from person, (select distinct sid, count(*) bid_count from bids group by sid) bids where person.s

RE: interesting sql question

2003-09-29 Thread Stephane Faroult
>- --- Original Message --- - >From: <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Mon, 29 Sep 2003 05:19:39 > >Im taking a database theory class(no I dont need >help with my homework). There is an interesting >query in the book that I h

RE: interesting sql question

2003-09-29 Thread Khedr, Waleed
select pn.name from (select /*+ no_merge */ count(*) boat_cnt from boat) bt, bid bd, person pn where bd.sid = pn.sid group by pn.name, boat_cnt having count(bd.boat_id) = boat_cnt Waleed -Original Message- Sent: Monday, September 29, 2003 9:20 AM To: Multiple recipients of list

RE: interesting sql question

2003-09-29 Thread Chelur, Jayadas {PBSG}
This would eliminate duplicate bids on the same boat by the same person SELECT p.* FROMPERSON p, ( SELECT COUNT(*) boat_count FROMBOAT ) c, ( SELECT sid, COUNT(DISTINCT boat_id) bid_count FROMBIDS GROUP BY sid

RE: Interesting Locking Problem

2003-08-01 Thread John Kanagaraj
Interesting indeed... I didn't see a version number in your note, but I am assuming that it is 8.1.7.x. We have also had some _very_ strange occurrences of 'library cache lock' / 'library cache pin' problems - sessions en-masse went into this state during high activity times on a Solaris based 8.1.

RE: Interesting Locking Problem

2003-08-01 Thread Jared Still
Sorry for omitting that info. Version: 8.1.7.4.1 ( maybe patched to 8.1.7.4.6, would have to get on the server to check ) OS: Windows 2000 Server Thanks for the insights John, I hadn't considered that it might actually be a bug, given that this app often has similar issues. There are snapsh

Re: RE: Interesting News..

2001-09-10 Thread Eric D. Pierce
From: Kimberly Smith <[EMAIL PROTECTED]> > Date: Fri, 7 Sep 2001 08:16:35 -0700 > Subject: RE: Interesting News.. > > Jon, you need to get some thick skin. My company is destroyed quite often > in this list (although it has been a while). > > -Original Message--

OT RE: Interesting News..

2001-09-10 Thread Mohan, Ross
olume 2001, Number 251] > > ---------- > > From: Kimberly Smith <[EMAIL PROTECTED]> > Date: Fri, 7 Sep 2001 08:16:35 -0700 > Subject: RE: Interesting News.. > > Jon, you need to get some thick skin. My company is destroyed quite often >

RE: RE: Interesting News..

2001-09-10 Thread Baker, Barbara
[EMAIL PROTECTED] > Sent: Monday, September 10, 2001 3:17 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: Interesting News.. > > K- > > I apparently made the mistake of thinking that the US constitution > says that there is a right to FREE SPEECH

RE: RE: Interesting News..

2001-09-10 Thread Kimberly Smith
o many a$$holes in the Compaq world. brgrds, ep [ via ORACLE-L Digest -- Volume 2001, Number 251] > > -- > > From: Kimberly Smith <[EMAIL PROTECTED]> > Date: Fri, 7 Sep 2001 08:16:35 -0700 > Subject: RE: Interesting News.. > >

RE: RE: Interesting News..

2001-09-10 Thread Kevin Kostyszyn
Oohhh storm clouds are on the horizon:) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing List

Re: RE: interesting sql question

2003-09-29 Thread rgaffuri
> > From: "Stephane Faroult" <[EMAIL PROTECTED]> > Date: 2003/09/29 Mon AM 09:59:39 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: interesting sql question > > > > >- --- Original Message --

RE: RE: interesting sql question

2003-09-29 Thread Jamadagni, Rajendra
Title: RE: RE: interesting sql question Here is an attempt ... select p.* from persons p where sid in (select sid, count(bid)     from bids    group by sid   having count(sid) = (select count(boad_id) from boats)) / You wanted to find all persons who have booked all

RE: RE: interesting sql question

2003-09-29 Thread rgaffuri
a user may request the same boat more than once. not sure that work. > > From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]> > Date: 2003/09/29 Mon AM 10:34:53 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: interesting

RE: RE: interesting sql question

2003-09-29 Thread Jamadagni, Rajendra
Title: RE: RE: interesting sql question Hey ... the question wasn't complete ... give us the full statement of the question ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in

Re: RE: interesting sql question

2003-09-29 Thread rgaffuri
t ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: interesting sql question > > Ralph, > > Assuming that there is no history in the BIDS table (meaning that there are > no "old" records indicating a bid recorded last year), I think the following > would work just

RE: RE: interesting sql question

2003-09-29 Thread Mercadante, Thomas F
Title: RE: RE: interesting sql question yeah!  I think it *is* homework  :)   Tom      -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 2003 12:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RE: interesting sql question

RE: RE: interesting sql question

2003-09-29 Thread rgaffuri
rom: "Mercadante, Thomas F" <[EMAIL PROTECTED]> > Date: 2003/09/29 Mon PM 12:29:40 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: interesting sql question > > yeah! I think it *is* homework :) > > Tom >

RE: Interesting PL/SQL Puzzle

2003-11-08 Thread Jamadagni, Rajendra
Without knowing the actual code, I'd use dbms_profiler and run this test say a thousand time. Analysis of collected data will help you find the problem spots. -Original Message- Sent: Saturday, November 08, 2003 1:09 PM To: Multiple recipients of list ORACLE-L I have a weird problem. It

RE: Interesting PL/SQL Puzzle

2003-11-08 Thread Sami
If you have more string manipulations/arithmetic operations java stored procedure would be a better choice compare to PL/SQL. -Original Message- Khedr, Waleed Sent: Saturday, November 08, 2003 1:09 PM To: Multiple recipients of list ORACLE-L I have a weird problem. It seems that execut

RE: Interesting PL/SQL Puzzle

2003-11-08 Thread Sami
Also did you run DBMS_PROFILER to find out which operations is taking more time to execute. -Original Message- Khedr, Waleed Sent: Saturday, November 08, 2003 1:09 PM To: Multiple recipients of list ORACLE-L I have a weird problem. It seems that execution speed of pl/sql proc can slow d

Re: Interesting PL/SQL Puzzle

2003-11-08 Thread Mladen Gogala
Let me give you a carystic advice: run your app with 10046, lev 8 and see what are you waiting on and how long the waits are. On 2003.11.08 13:09, "Khedr, Waleed" wrote: I have a weird problem. It seems that execution speed of pl/sql proc can slow down dramatically as the size of the proc goes up e

RE: Interesting PL/SQL Puzzle

2003-11-08 Thread Khedr, Waleed
I did, but it did not help. As I explained there is nothing in the code that gets executed as I explained in my code. Two IF statements (IF FALSE THEN) that will be always FALSE. So nothing of the code inside the if gets executed. Interestingly when I start to remove some of the code inside IF THEN

RE: Interesting PL/SQL Puzzle

2003-11-08 Thread Khedr, Waleed
The stored proc does not do any DML/DDL. It does strings search/manipulation. I run it 30 million times in 30 minutes using 32 threads. There is no wait time, it's pure CPU time that simply does not go down except when I remove the code that does not execute. -Original Message- Sent: Satu

Re: Interesting PL/SQL Puzzle

2003-11-08 Thread Vladimir Begun
Khedr, Waleed wrote: I did, but it did not help. As I explained there is nothing in the code that gets executed as I explained in my code. I would suggest to consider some simple things: . data dictionary dependencies . standard Oracle and your application's package(s) dependencies . proper dataty

Re: Interesting PL/SQL Puzzle

2003-11-09 Thread Yechiel Adar
I do not know anything about the way oracle semi compiled the code but I will try a wild guess (anybody who better please correct me): Maybe (a big MAYBE) oracle translate: if then... else as: If cond then do; else go to line 250. And the go to line 250 is counting lines until it arrive to th

RE: Interesting PL/SQL Puzzle

2003-11-09 Thread Khedr, Waleed
I had the same thought, also thought that if you have something like this that does not get executed: if VAR1 like '%abcbdbdbbbfdbfdfdfd%' The compiler (or the semi-compiler) still has to allocate memory for VAR1 and load it. I'm testing and will update the list, if I managed to find anything!

Re: Interesting PL/SQL Puzzle

2003-11-09 Thread Stephane Faroult
Yechiel's idea reminds me of one of that 'tuning tips' of old which said 'avoid calling a routine too far away in the code' (because it could be in another page, etc.). This kind of phenomenon, reference to chunks of code which have been safely parked away on disk may also come into play. SF "Khe

RE: Interesting PL/SQL Puzzle

2003-11-09 Thread Cary Millsap
I agree as Step 1, but I expect that you'll find quickly that the issue is a big c value for the EXEC on the block. If you do find this, then it indicates exactly what's been suggested several times already: use DBMS_PROFILER to dig into the response time of the EXEC. Cary Millsap Hotsos Enterpri

RE: Interesting PL/SQL Puzzle

2003-11-09 Thread Connor McDonald
Is the problem still evident when the parameters are defined as "in" as opposed to "in out". Cheers Connor --- Cary Millsap <[EMAIL PROTECTED]> wrote: > I agree as Step 1, but I expect that you'll find > quickly that the issue > is a big c value for the EXEC on the block. If you > do find this

Re: Interesting PL/SQL Puzzle

2003-11-10 Thread Mladen Gogala
Yes, you are right, of course. Using large PL/SQL tables and string manipulation (INSTR,SUBSTR and alike) are known to be CPU intensive and there is no way around it. The only way to help an application which uses those functions extensively is to add a column which extracts portion of the origina

Re: Interesting PL/SQL Puzzle

2003-11-10 Thread Pete Finnigan
In article <[EMAIL PROTECTED]>, Vladimir Begun <[EMAIL PROTECTED]> writes >Less number of inexpensive instructions is everytime better (I'm not talking >about lines of code). > >Trace it -- 10046/12 + dump instructions using appropriate event. ^^^

RE: Interesting PL/SQL Puzzle

2003-11-10 Thread Khedr, Waleed
Below are two dummy procs that are good enough to explain the issue (Jared forgive me for posting this big code). All the code in proc test_plsql1 is inside an IF clause that will not run. Testing the proc call is done using this: --- declare a varchar2(1000); b varchar2(1000);

RE: Interesting PL/SQL Puzzle

2003-11-10 Thread Jamadagni, Rajendra
hmmm me curious too ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Messa

RE: Interesting PL/SQL Puzzle

2003-11-10 Thread Chelur, Jayadas {PBSG}
If the logic depends on multiple IF statements based on which patterns the input strings match, it might be better to store the patterns in a PL/SQL table and find out the index of the matching pattern and then base the decision on the index value and not by repeatedly using LIKE ... something li

Re: Interesting PL/SQL Puzzle

2003-11-10 Thread Vladimir Begun
Pete Finnigan wrote: Less number of inexpensive instructions is everytime better (I'm not talking about lines of code). Trace it -- 10046/12 + dump instructions using appropriate event. ^ what instructions? and what events do you refe

Re: Interesting PL/SQL Puzzle

2003-11-10 Thread Vladimir Begun
Hi! NAMESHARABLE_MEM --- TEST_PLSQL1 185607 TEST_PLSQL5 9123 A lot of junk, right? :) PL/SQL engine works with interpretive code, it does not have any optimizations -- here I do simplify, so do not consider this statement as an absolute truth -- like, e.

RE: Interesting PL/SQL Puzzle

2003-11-10 Thread Carel-Jan Engel
Hi LIST Thanks Waleed fot the code. I did some extra tests, following Connor's suggestion: I created 4 extra versions of the testplsql5 procedure. So I ended up with 5 versions, each with 4 parameters, the first having 4 in out parameters, the second 1 in parameter and 3 in out parameters and

Re: Interesting PL/SQL Puzzle

2003-11-10 Thread Vladimir Begun
Carel-Jan Engel wrote: > It appears that the overhead caused by a 'call by reference' (in out) > will cost you some extra time. The 'call by value' appears to be cheaper. PL/SQL User's Guide and Reference Release 2 (9.2) 8 PL/SQL Subprograms Summary of Subprogram Parameter Modes IN OUT -- actual pa

RE: Interesting PL/SQL Puzzle

2003-11-10 Thread Khedr, Waleed
The question was not if it's a good or bad code. The question was why? This is not the actual code that runs, just something that explains the issue :) So let's make it more interesting: Let's keep the proc size unchanged while moving the end-if closer to the main if clause, and changing if false

Re: Interesting PL/SQL Puzzle

2003-11-10 Thread Vladimir Begun
Khedr, Waleed wrote: The question was not if it's a good or bad code. The question was why? This is not the actual code that runs, just something that explains the issue :) I've provided a selfexplanatory fix of the 'bad' code, please review it. You code uses standard.like, and a lot "isntances of

RE: Interesting PL/SQL Puzzle

2003-11-11 Thread Khedr, Waleed
You have not provided me with anything (I cannot post these things to public forums because of my email)! The only thing you said bad code, good code! I was not impressed the way the code works, this is why I had to research issue until I found the problem using "LIKE". Of course it was easy fo

Re: Interesting PL/SQL Puzzle

2003-11-11 Thread Vladimir Begun
Khedr, Waleed wrote: You have not provided me with anything (I cannot post these things to public forums because of my email)! Please re-read my posts. The only thing you said bad code, good code! How should it be named? I was not impressed the way the code works, this is why I had to research i

Re[2]: RE: Interesting News..

2001-09-10 Thread dgoulet
> > From: Kimberly Smith <[EMAIL PROTECTED]> > Date: Fri, 7 Sep 2001 08:16:35 -0700 > Subject: RE: Interesting News.. > > Jon, you need to get some thick skin. My company is destroyed quite often > in this list (although it has been a while).

RE: OT RE: Interesting News..

2001-09-10 Thread John Lewis
go around telling people that if they want good services, they should buy IBM since there are so many a$$holes in the Compaq world. brgrds, ep [ via ORACLE-L Digest -- Volume 2001, Number 251] > > ---------- > > From: Kimberly Smith <[EMAIL PROTECTED]

Re: OT RE: Interesting News..

2001-09-10 Thread Scott Shafer
s to kiss their a$$es all the time because > they are some big megacorp. > > Of course the good news is that I can now go around telling people > that if they want good services, they should buy IBM since there are > so many a$$holes in the Compaq world. > > brgrds, > ep

OT RE: RE: Interesting News..

2001-09-10 Thread Mohan, Ross
ka a SATISFIED Compaq customer > -- > From: Eric D. Pierce[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Monday, September 10, 2001 3:17 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: Interesting News.. > >

Re: OT RE: Interesting News..

2001-09-10 Thread Jared . Still
Ross" SMI.com> cc: Sent by: Subject: OT RE: Interesting News.. [EM

Re: OT RE: Interesting News..

2001-09-10 Thread Bill Conner
their employees and the friends of their employees, and having >them expecting the customers to kiss their a$$es all the time because >they are some big megacorp. > >Of course the good news is that I can now go around telling people >that if they want good services, they should buy IBM sin

RE: OT RE: Interesting News..

2001-09-10 Thread Mohan, Ross
Ross" SMI.com> cc: Sent by: Subject: OT RE: Interesting News.. [EMAIL PROTECTED] om 09/10/01 02:36

RE: OT RE: Interesting News..

2001-09-10 Thread Mohan, Ross
if they want good services, they should buy IBM since there are > so many a$$holes in the Compaq world. > > brgrds, > ep > > [ via ORACLE-L Digest -- Volume 2001, Number 251] > > > > > -- > > > > From: Kimberly Smith <[

  1   2   >