RE: UNION ALL Query: Riddle

2004-01-29 Thread Wendry
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, January 29, 2004 2:24 AM To: Multiple

RE: Strange Query Result,... urgent please

2004-01-18 Thread Wendry
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 some problems

Strange Query Result,... urgent please

2004-01-17 Thread Wendry
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, Wendry. -- Please see

RE: What is Hash Join?

2004-01-16 Thread Wendry
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 proven

What is hash join?

2004-01-15 Thread Wendry
on 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

Setting up Windows 2000 for Oracle Parallel Server

2004-01-14 Thread Wendry
is I dont 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: Table access

2004-01-14 Thread 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, California-- Mailing list

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

2004-01-13 Thread Wendry
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 I do

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

2004-01-12 Thread Wendry
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 PM

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

2004-01-09 Thread Wendry
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 ORACLE

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

2004-01-09 Thread Wendry
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 ORACLE

RE: Can't connect MTS from remote.

2003-12-31 Thread Wendry
the 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

Can't connect MTS from remote.

2003-12-30 Thread Wendry
? 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, California-- Mailing list