Oracle-L: RE: Urgent help needed, gurus

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Tue, 24 Dec 2002 02:58:37 -0800
Message-ID: <F001.00521A34.20021224025837@fatcity.com>

What does the session statistics say when you are running the query?

Do an explain plan of both the queries and see the difference. Check the session statistics for both the queries.

Regards
Naveen

-----Original Message-----
Sent: Tuesday, December 24, 2002 2:34 PM To: Multiple recipients of list ORACLE-L

Oracle 817 on W2k:

SELECT FUNCTION(X) FROM TABLE works fine.

SELECT COUNT (*) FROM
(SELECT FUNCTION(X) FROM TABLE) where the function and the table are the same as above, takes hours and hours, without any result, and I have to stop it. There is NO ERROR MESSAGE.
The same story (no result, no error message) it's happening when: INSERT INTO TABLE1 SELECT FUNCTION(X) FROM TABLE I need some help.

Merry Christmas,

Ciprian MAFTEI
Systems Analyst
Telequote Network
Romania
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: mac
INET: mac_at_telequote.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Naveen Nahata
INET: naveen_nahata_at_mindtree.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------