Re: 4 join methods?
At 22:55 -0800 30/5/01, Rukmini Devi wrote: 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join Outer join is a logical type not an access method. the four types of join that Oracle can use: Nested Loops join Sort Merge join (equi-join only) Cluster join (equi-join on cluster key only) Hash join (equijoin, cost-based only) Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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: 4 join methods?
At 9:07 -0800 31/5/01, Mogens Nørgaard wrote: There is certainly something new called an index join around in 8i. An index join is a hash join on 2 or more indexes which between them contain all the columns required to fulfill the query. It is new to 8i, and is considered to be an access pathl but strangely is not considered to be a join method; probably because it is a hybrid of the hash join using indices only. Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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: Analyze table and locking
At 8:10 -0800 30/5/01, [EMAIL PROTECTED] wrote: In earlier versions (7.3 ?) 'analyze ..compute' used to take table level locks. From 8 onwards, compute or estimate does not take any table level or row level locks at all... Sorry, not true. From at least 7.2.3 (the oldest I have here) there was no table-level locking for any analyze statement. As for the preferment for estimate, Oracle has the last laugh - if you estimate on a percentage greater than 50% or specify rows greater than half the number of rows in the table, Oracle analyzes the entire table. Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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: Fire your DBA's you don't need them anymore...
I've just spent most of today repairing damage left at a site by some of Oracle's 'superior' consultants! At 8:27 -0800 25/5/01, Gary Weber wrote: Far as their superior i-dba team, I sure hope those are different people from the ones you get on first line of Support... Cheers Paul Miller -- - Banned and proud of it! Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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: OFF TOPIC: My Unix mail file is too huge to access
At 13:49 -0800 24/5/01, Jenny Jacobson wrote: How do I get into my old mail so I can 1) delete old messages and 2) access a VERY important email that I need to use. Eudora uses the exact format used for unix mail files, so I recommend that. I don't think my unix account has a pop3 server. Someone suggested I ftp the file to my PC and read it there. When I did a file command, it said the mail file was ASCII text, but my important email has an attached Excel spreadsheet. Do I ftp in ASCII or binary mode? Binary for certain. Eudora can sort out the attachment format as long as the file has not been translated. Not just email, but with everything, use binary only. Even if you need the line terminators translated, ftp is the worst way on earth to do it. I don't have any mail software on my PC (I use a shell account and Yahoo). I don't want to use my Yahoo account to process this huge file via pop3. http://www.eudora.com/ and it is free. Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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 oracle
At 20:35 -0800 20/5/01, Seley, Linda wrote: Oh, Perl gurus, is there a function in perl that will let me do connect internal? $dbh = DBI-connect(DBI:Oracle:, internal,,{ ora_session_mode = 2 }); But before you get carried away, it may not do what you want. If for example you were hoping that this could be used to startup/shutdown, it won't, at least not in the current DBD::Oracle. There was a discussion on this on [EMAIL PROTECTED] recently. Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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: job offer from SAUDI ARABIA
At 11:32 -0800 16/5/01, Jacques Kilchoer wrote: One of my former colleagues worked in Saudi Arabia and said that the life there was very quiet and much different from our western lifestyle. However, in his opinion, if you made the effort to respect the local traditions, you could live there and tour the country with not too many difficulties. The important thing was to be prepared for their customs. I couldn't agree more. I didn't work in Saudi, but in Kuwait where I had about 100 (1/1000 lakh - best use that one before I forget it) staff mostly from the UK and US. Several people had a hard time adjusting, but those that respected local custom and showed an interest in and respect for Kuwaitis enjoyed themselves immensely. Some stayed after their year was up and I know of one woman that is still there 10 years later! For me, I would relish the opportunity to work in that environment again. I found the Kuwaitis and people of the Gulf very friendly, trustworthy, and kind. I got used to leaving my house unlocked, the keys in my car, and my office open. The displays of hospitality I was shown shamed me when I thought of how ex-pats are treated in some other countries. And my clients did something I have never experienced before or since: said what they wanted and when, then left me to do it with no interference! Oh, and Bahrain (with its bars and liberal lifestyle) was only a short and cheap flight away... Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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).