Re: How do we know that an index need to be rebuilt.

Read ur interesting reply for the query Mladen and learnt a new "rule of thumb" from u today. i sent the doc. to Raju ONLY adn NOT to the list. it's just the body of the mail u r seeing there. Regards, Jp. 22-09-2003 15:49:40, Mladen Gogala <[EMAIL PROTECTED]> wrote: >Attachments are stripped f

Re: oraperf.com is now Veritas

Yeah, I was reading and reading for hours studying the fine print of his presentation :-). Niall Litchfield wrote: All of it? how did you plough through all the detail? Niall -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Jamadagni, R

Re: How do we know that an index need to be rebuilt.

Attachments are stripped from the list messages. On 2003.09.22 02:24, Prem Khanna J wrote: Hi Raju, Check the doc. i have attached. HTH. Jp. 22-09-2003 14:59:35, Veeraraju_Mareddi <[EMAIL PROTECTED]> wrote: >Dear Friends, > >Can somebody tell me how do we that an index needs to be rebuilt.. Di

Re: How do we know that an index need to be rebuilt.

Oracle indexes do not need rebuilding on the regular basis, but only as an exceptional event. The warning sign is when queries that utilize nested loops slow down without any apparent reason. The only case when index needs to be rebuilt is the case of a table with frequent delete operations. You

RE: oraperf.com is now Veritas

Title: Message All of it? how did you plough through all the detail?   Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, RajendraSent: 18 September 2003 17:40To: Multiple recipients of list ORACLE-LSubject: RE: oraperf.com

Re: How do we know that an index need to be rebuilt.

Hi Raju, Check the doc. i have attached. HTH. Jp. 22-09-2003 14:59:35, Veeraraju_Mareddi <[EMAIL PROTECTED]> wrote: >Dear Friends, > >Can somebody tell me how do we that an index needs to be rebuilt.. Different >scenarios / any documents will be helpful. > >Thanks in advance. >Rajuvera -- Pl

How do we know that an index need to be rebuilt.

Dear Friends, Can somebody tell me how do we that an index needs to be rebuilt.. Different scenarios / any documents will be helpful. Thanks in advance. Rajuvera ** This email (including any attachments) is intended for the

RE: minus vs. where not exists, vs. where not in

Yeah, Superman had Super powers. Batman just relied on a bunch of gadgets. Of course my original post was implying the classic "it depends". There are some scenario's where a specific approach is faster than the other and there are some scenario's where it doesn't matter because oracle can rewr

Oracle 9i new features - by Connor McDonald

..a paper presented by Connor at OracleWorld 2003 is here. http://tinyurl.com/o6hp ..thought it may be of interest for many on this list. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 85

Bug in 9.2.0.4 when order by constant desc

Hi all, Got the info' below from www.dba-village.com and thought of sharing it with u guys. If you try "select 'Hello' from dual order by 1 desc;" you may run into the bug. It creates a dump

RE: minus vs. where not exists, vs. where not in

I think Superman is stroger than Batman -Original Message- Sent: 22 September 2003 08:30 To: Multiple recipients of list ORACLE-L I'm not sure that there is a good answer to that question. The question sounds like the dilemma: who's stronger, Batman or Superman? Unfortunately, superheroe

Re: wrapping packages

Tanel Poder wrote: After all, I do have the right to know, which code is executed on my computer (OTOH, I've not read any agreements too thoroughly, when downloading software). "I do have the right to know which code is executed on my computer" or not "execute that code" but not hack it to know wha

Re: wrapping packages

Anyway's Peter is right in some sense as I heard that some Russian guy Those Russians... :) They can do a lot. -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: http://www.

Re: wrapping packages

Tanel Poder wrote: :) I just think you have/had too much time and nothing serious and important to do. That was the case, back at highschool days... I think you're still there... at least according to your posts. :) -- Vladimir Begun The statements and opinions expressed here are my own and do not

Re: sql trace tuning articles

Did you check out www.hotsos.com? Cary Millsap and Jeff Holt have a few (as well as a great book Optimizing Oracle Performance) Thanks/Richard --- Ryan <[EMAIL PROTECTED]> wrote: > did a google search and couldnt find anything worth reading. other than the > ones on hotsos any other good one

sql trace tuning articles

did a google search and couldnt find anything worth reading. other than the ones on hotsos any other good ones? namely ones on traces other than 10053 and 10046?   Ive seen a few others mentioned but no details.

RE: wrapping packages

Jared, That is also my understanding of what wrap does - after all if the wrapped PL/SQL code is encrypted why do string literals appear within the wrapped output. And where do you specify the encryption key - you don't because wrap does not encrypt. I'm not surprised that people think the wrap

Re: minus vs. where not exists, vs. where not in

I'm not sure that there is a good answer to that question. The question sounds like the dilemma: who's stronger, Batman or Superman? Unfortunately, superheroes do not exist, so we cannot have a real life comparison. It is exactly the same with not exists vs. minus. Comparisons make sense only w

Re: Anyone have a copy of DUL ??

Bernard of Oracle Holland made DUL (Direct UnLoader) several years ago. I took the very last internals class conducted by Oracle Support EMEA Vice President Andre Bakker (the only VP to conduct internals classes, I think. I also think he quit Support in disgust some time later :-) ), and we tal

Re: minus vs. where not exists, vs. where not in

I don't have any scientific proof but I imagine the sort_area_size could be different between "not exists" and "minus". When doing "minus" the entire select string would have to be compared for equality, which could be very large depending on your string. Minus is probably an easier way (at leas

RE: log miner views contain object IDs and HEX values

Steve, Did you have set serveroutput on? I have found you need this before you'll get error messages from Logminer. I found this in Metalink note Note:69606.1 HTH in the future, Bruce Reardon -Original Message- Sent: Saturday, 20 September 2003 9:40 AM OK seems I must have fat fingered

Re: wrapping packages

Hi! I think disassembling the code itself wouldn't be that condemnable (is this correct usage of the word?), but if anyone would start disributing the wrapping algorithm or spreading modified Oracle code, that would make Oracle wake up. After all, I do have the right to know, which code is execute

Re: weird

Sorry, I can't help it. But anyway, I will take your advice and keep away from Oracle for a while. There are few DB2 materials I want to go through... (just joking ;) Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, September 21, 20

Re: minus vs. where not exists, vs. where not in

On 2003.09.21 15:24, Wolfgang Breitling wrote: First off, the three are not equivalent, not substitutes for each other. Well not in and minus would be, but they are different from not exists. "not in"/"minus" and "not exists" can return different results. See

Re: wrapping packages

> :) I just think you have/had too much time and nothing serious and important > to do. That was the case, back at highschool days... Tanel. > -- > Vladimir Begun > The statements and opinions expressed here are my own and > do not necessarily represent those of Oracle Corporation. > > -- >

Re: Copying statistics : used a lot ????

wait a second. the CBO takes into consideration your system statistics when you analyze? Is that new in 9i? I thought the export stats and import stats were used if you wanted a 'smaller subset' of data. so you mimic the data stats? - Original Message - To: "Multiple recipients of list ORAC

Re: minus vs. where not exists, vs. where not in

if you handle for nulls with an 'nvl' then 'not exists' appears to return the same answer as not in. or am I wrong? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, September 21, 2003 3:24 PM > First off, the three are not equivalent, not

RE: Copying statistics : used a lot ????

What a timely thread! We've been discussing this very issue back and forth for some time now in our organization. We are getting a new application, which presumably will run on something like lower-end Superdome 16-way, ~30GB RAM type of box. The question is whether 4-way, 4GB RAM Rp5470 (entry-le

RE: Copying statistics : used a lot ????

What a timely thread! We've been discussing this very issue back and forth for some time now in our organization. We are getting a new application, which presumably will run on something like lower-end Superdome 16-way, ~30GB RAM type of box. The question is whether 4-way, 4GB RAM Rp5470 (entry-le

Re: minus vs. where not exists, vs. where not in

First off, the three are not equivalent, not substitutes for each other. Well not in and minus would be, but they are different from not exists. "not in"/"minus" and "not exists" can return different results. See htt

RE: weird

Yeah. What he said. And you make the rest of us look bad. For the record, I replaced my ailing 27-inch color TV with a new 32-inch and started a new game of Final Fantasy VII. No stinkin' Oracle for me this weekend. > -Original Message- > > > Tanel, > > This is above and beyond the

minus vs. where not exists, vs. where not in

Do any of you have any cases when minus is superior in performance? Ive found 'not in' with a hash_aj to be the best option if the sub-query is significantly less 'costly' then the outer query. I dont mean cost in terms of the Explain Plan, I mean the work Oracle has to do to find a result s

Re: wrapping packages

Tanel Poder wrote: Perhaps you're not aware of the way executables compiled on your Solaris and Windows platforms. In detail, not. In general, yes. Ok, I checked, you're correct, wrap isn't only this 40kB executable, uses orancrypt9.dll (100kB) in Windows, this might be the one where encryption is

Re: wrapping packages

Hi Peter, Tanel and Jared, Peter: I meant a public unwrap process not the internal mechanisms in the PL/SQL interpreter / VM. Tanel: I would be more worried about Oracle coming after you in the legally sense if you did reverse engineer the wrap process!! Jared: Are you sure that's how it works?

Re: SGA Max size

> In 9202, DB_BUBBER_CACHE, SHARED_POOL, LARGE_POOL > and JAVA_POOL can be dynamically altered. But in 901, LARGE_POOL > and JAVA POOL are static. If MAX SGA is less than 128MB then Oracle > will use 4MB granule size to allocate/deallocate memory. For SGA greater > than 128M, Oracle granule size is

Re: weird

Tanel, This is above and beyond the call of duty. Now you need to step away from the computer... Jared On Sun, 2003-09-21 at 08:29, Tanel Poder wrote: > Hi! > > After spending half of Saturday and Sunday digging around x$ktcxb and other > interesting views I actually realized that the answer i

Re: wrapping packages

IIRC, 'wrap' does not actually encrypt the code. Rather, it simply does a precompile on it and then stores the pcode in the database. Jared On Sat, 2003-09-20 at 14:29, Peter Gram wrote: > Hi Pete > > I must point out that there must be a unwrap, since the Oracle database > can run the wrapp

RE: SGA Max size

In 9202, DB_BUBBER_CACHE, SHARED_POOL, LARGE_POOL and JAVA_POOL can be dynamically altered. But in 901, LARGE_POOL and JAVA POOL are static. If MAX SGA is less than 128MB then Oracle will use 4MB granule size to allocate/deallocate memory. For SGA greater than 128M, Oracle granule size is 16MB.

Re: weird

Hi! After spending half of Saturday and Sunday digging around x$ktcxb and other interesting views I actually realized that the answer is way simpler :) TADDR column in v$session points to *current* transaction state object, that means if recursive transaction is needed for wrapping or extending r

RE: weird

Just one transaction. Nothing else going on. > -Original Message- > > Stephen, > > Was this the only running transaction? > > No background stuff going on? > > Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat

RE: weird

8.1.7.4 No AUM. Either it was something goofy in the database, or something clobbered some bytes as they were going from the host machine to my telnet session ... which afaik would also be wierd since TCP/IP is supposed to guarantee delivery. The terminal session is on a Windows box ... maybe

Re: wrapping packages

Hi Did a "nm -D wrap" this gave heaps of symbols, so wrap is loading shared libs. This means revers engineering a lot of Oracle code :-( Govindan K wrote: Coming to think of it, is the 3Mb size is for stripped or unstripped executable?. I know 3Mb if stripped is not likely to come to 40K. Nev

Re: wrapping packages

Coming to think of it, is the 3Mb size is for stripped or unstripped executable?. I know 3Mb if stripped is not likely to come to 40K. Nevertheless the memory addressing for UNIX is diff. from Windoz. May be someone else in the list has a better knowledge of it.   GovindanK <-Original Message

Re: wrapping packages

> Tanel Poder wrote: > > I checked, the wrap executable in 8.0.6 dist for solaris is about 3MB, but > > for 9.2 in Windows it's only about 40k. > > Perhaps you're not aware of the way executables compiled on your Solaris and > Windows platforms. In detail, not. In general, yes. Ok, I checked, you'