I don't have answers for you, but I'm looking to (hopefully)
resolve the same problem. I spool portions of tables out to ascii
files to be backed up and purged from the database (I want the data
in ascii format... not Oracle dependent). Anyway, I've noticed that
one table (very large) spools out about 500M in 10-12 hours (very slow).
THEN... the process just sits there for another 10-12 hours doing I don't
know what? The spool file isn't growing, but the SQL spool command has not
returned (as far as I know). I'm running this from a Pro*C app on Solaris 2.5
using Oracle 7.3.3. I need to resolve this since, I don't have the
rollback space to support a transaction taking 24+ hours to complete.
Let me know if this is similar to your problem... I have a call into Oracle
to help.
John.
In article <780b31$hia$1_at_news5.svr.pol.co.uk>,
"Brian + Susan McCracken" <brian_at_susie11.freeserve.co.uk> wrote:
> I have recently upgraded from723 to 7342 and have experienced sqlplus taking
> up to 4 times more processor on 7342 when spooling to flat files from large
> selects resulting in degradation in response.
>
> Has anyone else seen this
>
>
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Jan 25 1999 - 09:34:31 CST
