Sponsored Content
Full Discussion: which is better?
Top Forums UNIX for Advanced & Expert Users which is better? Post 302240610 by risk_sly on Friday 26th of September 2008 06:22:26 AM
Old 09-26-2008
which is better?

Hi,

I would like to know which works better in this scenario:

I have a file which contains about 300K to 400K records. This file will be loaded into an oracle table but will be filtered first. I have two ways of doing this.

1st, I filtered the original file and created a new file that contains only the selected records (using awk)

2nd, I included a WHERE clause in the sqlloader control file to filter the records

with these two options, which do you think is more efficient. (some explanations will be much appreciated) thank you.
 
TRSP(8c)																  TRSP(8c)

NAME
trsp - transliterate sequenced packet protocol trace SYNOPSIS
trsp [ -a ] [ -s ] [ -t ] [ -j ] [ -p hex-address ] [ system [ core ] ] DESCRIPTION
Trpt interrogates the buffer of SPP trace records created when a socket is marked for "debugging" (see setsockopt(2)), and prints a read- able description of these records. When no options are supplied, trsp prints all the trace records found in the system grouped according to SPP connection protocol control block (PCB). The following options may be used to alter this behavior. -s in addition to the normal output, print a detailed description of the packet sequencing information, -t in addition to the normal output, print the values for all timers at each point in the trace, -j just give a list of the protocol control block addresses for which there are trace records, -p show only trace records associated with the protocol control block who's address follows, -a in addition to the normal output, print the values of the source and destination addresses for each packet recorded. The recommended use of trsp is as follows. Isolate the problem and enable debugging on the socket(s) involved in the connection. Find the address of the protocol control blocks associated with the sockets using the -A option to netstat(1). Then run trsp with the -p option, supplying the associated protocol control block addresses. If there are many sockets using the debugging option, the -j option may be use- ful in checking to see if any trace records are present for the socket in question. If debugging is being performed on a system or core file other than the default, the last two arguments may be used to supplant the defaults. FILES
/vmunix /dev/kmem SEE ALSO
setsockopt(2), netstat(1) DIAGNOSTICS
``no namelist'' when the system image doesn't contain the proper symbols to find the trace buffer; others which should be self explanatory. BUGS
Should also print the data for each input or output, but this is not saved in the race record. The output format is inscrutable and should be described here. 4.2 Berkeley Distribution October 8, 1985 TRSP(8c)
All times are GMT -4. The time now is 06:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy