Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: put the table in upper case

Re: put the table in upper case

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Mon, 7 Nov 2005 22:36:21 +0100
Message-ID: <023601c5e3e3$4cd165c0$b400a8c0@IBME1D11967173>


But .... ,in *this example* the elapsed is the same ( I know, I know, 51 calls vs. 53, without "cat" is more scalable :)).

$ rm TEST.txt
$ truss -c cat test.txt | tr "[:lower:]" "[:upper:]" > TEST.txt

syscall              seconds   calls  errors
_exit                    .00       1
read                     .00       1
write                    .00       1
open                     .00       4
close                    .00       6
brk                      .00       2
stat                     .00       9      6
fstat                    .00       4
execve                   .00       1
mmap                     .00      10
munmap                   .00       3
memcntl                  .00       2
llseek                   .00       4
resolvepath              .00       1
mmap64                   .00       1
fstat64                  .00       2
open64                   .00       1
                     -------  ------   ----
sys totals:              .00      53      6
usr time:                .00
elapsed:                 .02


$ rm TEST.txt

$ truss -c tr "[:lower:]" "[:upper:]" < test.txt > TEST.txt

syscall              seconds   calls  errors
_exit                    .00       1
read                     .00       2
write                    .00       1
open                     .00       4
close                    .00       4
brk                      .00       6
stat                     .00       9      6
fstat                    .00       4
ioctl                    .00       2      2
execve                   .00       1
mmap                     .00      10
munmap                   .00       2
memcntl                  .00       1
llseek                   .00       1
resolvepath              .00       1
fstat64                  .00       2
                     -------  ------   ----
sys totals:              .00      51      8
usr time:                .00
elapsed:                 .02





Regards,
Dimitre Radoulov

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 07 2005 - 15:39:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US