Re: Oracle hangs on select statement on certain computers

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 20 Feb 2006 16:53:05 -0800
Message-ID: <1140483185.153423.188730@g14g2000cwa.googlegroups.com>

Dan, different systems would have different data. Have you looked at the statistics for the problem databases and compared the statistics to the actual data to make sure your application is not running into any type of skewed data accessing problem?

Is the alert log and user trace file directories for each affected database clean?

If these applications use an Oracle client does the version of the client installed match the version of the target database?

HTH -- Mark D Powell -- Received on Mon Feb 20 2006 - 18:53:05 CST