Re: need help with table creation, nologging, and backup

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Mon, 12 May 2003 18:10:23 -0700
Message-ID: <3CXva.39278$MJ5.1144@fed1read03>

Ryan wrote:
>[...snip...] nothing which contributes to actually solving the problem.

Ryan,
You don't know, what you don't know.

You seem to be working on mysteries without any clues.

You seem to be grasping at buzz words de'jure hoping, just hoping that one of them is your Silver Bullet (TM).

If you could/would actually post the output from TKPROF which contains the EXPLAIN PLANs for SQL involved, then maybe somebody here might have a fighting chance to assist in speeding up the batch job.

Rhetorical question -
If you don't know which statement(s) [SQL or PL/SQL] are causing the most delay, then how/why do you expect them to automagiaclly get faster.

Have you even tried using DBMS_PROFILER? I suspect not. Why not? Received on Mon May 12 2003 - 20:10:23 CDT