Re: Trace file does not list detailed timings

From: Jared Still <jkstill@xxxxxxxxx>
To: mcgodlewski@xxxxxxxxx
Date: Tue, 31 Jan 2006 07:21:15 -0800

On 1/30/06, M.Godlewski <mcgodlewski@xxxxxxxxx> wrote:
>
> Oracle 9iR2
> Sun Solaris
> Once I add  substr(a.description,1,4000) to my select clause from the
> table, I seem to get page breaks where they are not wanted.
>  ...
> If anyone has ideas or docs I would appreciated the help!  I imagine it is
> a sql limitation of some sort.
>

There are CR/LF line terminators in the data coming from SQL Server.
Modifying the DTS job to filter them would be the easiest method to correct,
especially if the SQL Server DBA is someone other than yourself.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

References:

RE: Trace file does not list detailed timings
From: Cary Millsap

RE: Trace file does not list detailed timings
From: M.Godlewski

Re: Trace file does not list detailed timings

Other related posts: