Re:CBO and cartesian product

...' part of your paper is great. It will take me a little while to read whole paper but still I got the story. (Difficult to attend whole day trainings and then work)... Thanks a lot again, ~Dilip [EMAIL PROTECTED] wrote: Tim/Dilip, Unfortunately, as this is an 'Apps' instance

CBO and cartesian product

Merge Join. After running the same report under RBO, it is using Nested loops and report is completing in just 5 minutes. The stats were collected last week-end. I couldn't find any reason for this CBO's behavior ? Has anybody experienced this before ? Thanks, ~Dilip Get Your Private

Discoverer and Informix

in buying oracle database. Can we connect discoverer directly to informix ? In that case, where the EUL will be created ? Regards, ~Dilip Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid

Hey Jared

). _ Enter for your chance to IM with Bon Jovi, Seal, Bow Wow, or Mary J Blige using MSN Messenger http://entertainment.msn.com/imastar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dilip Patel INET: [EMAIL

Re: What books recommended for Data Modeling ?

Hi All, Need some suggestions/Input. My application database is 8.1.7, NOARCHIVELOG, WIN200, total size 4 GB, more of single user OLTP client-server application. Now the customer wants to give training on this application to hundred trainees at a time. For this he wants to install hundred

statpack v$sysstat - stat# 140

? If yes, what is the statistic# name ? Thanks, ~Dilip Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid for for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http

Re: 100 instances on same server !!!

lace. Fiddling with Ghost is NOT a DBA job, but any sysadmin type should pull it with ease (and gratitude, if I may say so ;-). Branimir -----Original Message-From: Dilip Patel [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 6:54 PMTo: Mult

Re: 100 instances on same server !!!

is the maximum number of instances anyone has ever worked/heard being installedwith in same server? Thanks again. Dilip. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Thursday, August 07, 2003 11:54 AM Subject: Re: What books recommended

Re:unix shell script question

Hi Pete, Garry and Stephan, Thanx a lot for the solution. It is working for me. Thanx once again, Regards, ~Dilip Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid for for Air Tickets @ Re.1

OT: unix shell script question

, how ? I tried some ways but couldn't find any way. Regards, ~Dilip Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid for for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http

strange ORA- 00980 - synonym translation is no longer valid

dropped and recreated the synonym in APPS schema. But no use. I can create the same snapshot in that same CRPHR database. There is no problem with database link. I was able to create around 60 snapshots but failing only on 2 snapshots. Hasanybody encounered this before ? Any idea ?? Regards, Dilip Get

Re: ODBC through server side sql

hope somebody will understand microsoft-oracle). Cheers ~Dilip [EMAIL PROTECTED] wrote: Dilip - I think you are on the right track. I saw your post to Justin, and that is what what we often run into -- we give the users a report tool and hope they'll go away, but they come back

RE: Teradata baned from IOUG???

on to a href=http://airsahara.indiatimes.com;http://airsahara.indiatimes.com/a and Bid Now !/font --=_MAILER_ATTACH_BOUNDARY1_200321341313191957747793-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dilip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: Re: ODBC through server side sql

will not be ready to pay lots of money for this. And many other things. So better I keep myself away and do my DBA work. Thankx, ~Dilip Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy the best in Movies at http://www.videos.indiatimes.com Bid for Air

Re: ODBC through server side sql

to access database full day. Now I am suggesting them that we should create views in the database. Views definition will take care of report logic. And then through ODBC, they will just do 'select * from view_name' and get data in excel and carry on. Any better ideas Thanks, ~Dilip