RE: UNION ALL Query: Riddle

problematic query but it runs slower. I haven't tried intensively, I try to do that tomorrow. Meanwhile if, there's any of the Gurus can give us clearer explanation, please do so... Thank you all in advance. Regards, Wendry. -Original Message- Pillai, Rajesh Sent: Thursday, Ja

RE: Strange Query Result,... urgent please

Thanks for the reply Tim, I will try to look at the index and bad blocks at the datafile or restart the database again. The type column for QTY_SOLD_SO is number. Regards, Wendry. -Original Message- Sent: Saturday, January 17, 2004 9:15 PM To: 'Wendry' I would suspect som

Strange Query Result,... urgent please

orary tablespace and it still has a lot of room to do sorts. Anyone has experience this before? Please give me some light, ideas or suggestion to correct this, since I have a lot of very complex queries. I feel like a bomb is ticking for other complex queries. Thank you all in advance. Regards, Wend

RE: What is Hash Join?

Thanks a lot for the information Kevin :), that's quite a light to me. So... Is it best to try to get hash join on execution plan at all time? Regards, Wendry. -Original Message- Sent: Thursday, January 15, 2004 9:09 PM To: [EMAIL PROTECTED] In my experience, Hash Joins have p

What is hash join?

what does Oracle use hash join for joining tables in the execution plan? If they use hash value, how does Oracle determine the hash value when performing hash join? I really in the dark here, please give me some light…, Thank you all in advance. Regards, Wendry -- Please see the official

RE: Table access

k you." ** == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wendry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailin

Setting up Windows 2000 for Oracle Parallel Server

question is I don’t know what options or additional software to install on Windows 2000 for OPS. I have 2 servers running on windows 2000 and I plan to set multi clustered environment. Can you help me, please? Thank you all in advance.   Regards,   Wendry.    

RE: Problem with archive log when testing recovery..., urgent

Well, I think I forget the alter system switch logfile before shutdown and after restart. I'll try that n let you all know the result. Regards, Wendry. -Original Message- Sent: Tuesday, January 13, 2004 6:07 PM To: Wendry Nothing major amiss there, that is exactly what

RE: Problem with archive log when testing recovery..., urgent

tdown immediate, copy all controlfiles, datafiles and redo log files to backup destination, and then reopen the database. Is there any steps that I left which cause the archive log to be corrupted? Thank you in advance. Regards, Wendry. -Original Message- Sent: Monday, January 12, 2004 12:36

Need info on HP Proliant ML 350, on installing Oracle 8i and 9i, urgent.. please

Hi all, I'd like to ask you about any steps that I should do additionally on installing oracle 8.1.6.0.0 and 9i on server HP proliant ML 350, with os of windows 2000. I need to get this working by 2 days. So I really need help on this, thanks. Regards Wendry. -- Please see the official O

Need info on HP Proliant ML 350, on installing Oracle 8i and 9i, urgent.. please

Hi all, I'd like to ask you about any steps that I should do additionally on installing oracle 8.1.6.0.0 and 9i on server HP proliant ML 350, with os of windows 2000. I need to get this working by 2 days. So I really need help on this, thanks. Regards Wendry. -- Please see the official O

RE: Can't connect MTS from remote.

problem here? Thank you all in advance. Regards Wendry. -Original Message- Karniotis, Stephen Sent: Tuesday, December 30, 2003 9:24 PM To: Multiple recipients of list ORACLE-L Generally, 12545 means that something in the connection string for shared environments is missing, the

Can't connect MTS from remote.

one has experience like I have? Please give me some input here. Thank you all in advance. Regards, Wendry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wendry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Cal