strange sqlplus and oracle connection issues
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Thu, 20 Nov 2008 11:12:32 -0500
Message-ID: <f30139790811200812y1890e352lc037da6a025e79fe@mail.gmail.com>
Date: Thu, 20 Nov 2008 11:12:32 -0500
Message-ID: <f30139790811200812y1890e352lc037da6a025e79fe@mail.gmail.com>
Windows Server 2003
Oracle Standard 10.2.0.1
Development use. No support. So no patches... can't do anything about it. I have an enterprise edition installed with a newer patch set on another server, but i have not moved data over to it yet. They build stuff for other people and the customers have the production support, etc...
- I am trying to describe tables and it hangs on the describe
- I try to describe a large 10gb table and i get an "end of file communication" and i lose connection
- I try to query this 10gb table which I was able to do 3 days ago and get the first 5 rows and it hangs and runs for 1 hour before I kill it. The table should not be fragmented. I have not touched it since the last time I looked at it
- I can get the describe to work on #1 if i run it directly from the server.
any idea where I can look on this?
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 20 2008 - 10:12:32 CST