Hi,
how can I write a small script to run the following statement and output the result into check_result.txt
select /*+RULE*/ tapname from typetbl where tapname like 'AA%' and rejectcode=9;
Normally, I just type sql and get into SQL> (2 Replies)
Hi All,
I have a file abc.txt with 3 fileds. Field 3 contains amount. Also at the end of file there is a Footer record, which contains total amount.
I need to calculate total sum of these fields & need to compare it with footer record. I have serched in thi site, many has asked this... (7 Replies)
Hi every body
i have a problem need help urgently
file 1 (approx 200K entries)
aaaaa
bbbb
cccccc
dddd
ffff
file 2 (approx 2 million entries)
aaaaa,1,ee,44,5t,6y,
bbbb,3,ff,66,5u,8r,
cccccc, .....
dddd, .....
eeeeee, .....
ffff, ...... (5 Replies)
output of Unix & sql in same file
hi all,
am working on shell script, i need to format data in such a way
that both my Unix commands output & my sql output should be in a same file.
I am able to redirect both output in separate files.
for sql output: sqlplus -s... (6 Replies)
hi,
Could anyone tell me how to pass the output values of the PL/SQL procedure to Shell script and how to store that values in a shell script variable...
Thanks in advance... (5 Replies)
Hi all
I am trying to scan a file that has 3 columns:
red blue 123351
red blue 848655
red blue 126354
red blue 023158
black white 654896
red blue 650884
I want an output that sums the rows that have matching columns 1 and 2 :wall:
red blue has 5 entries
black white has 1 entry
... (4 Replies)
- I have two files (File 1 and File 2) and the contents of the files are mentioned below.
- I am trying to compare the values of Column1 of File1 with Column1 of File2. If a match is found, print the corresponding value from Column2 of File1 in Column5 of File2.
- I tried to modify and use... (10 Replies)
Hi All,
I have a requirement where I need to compare 2 files & if the values in the files match, it should proceed, else exit the script without proceeding further.
For e.g : Scenario 1
In this case, the script should exit without proceeding further.
Scenario 2
In this case, the script... (7 Replies)
hey i am using this code to connect to sql , store the value in variable and then
compare it with another variable after some time by executing the same query
but the desired result is not coming
#!/bin/bash
val=$(sqlplus -s rte/rted2@rel76d2 <<ENDOFSQL
set heading off
set feedback off... (11 Replies)
Discussion started by: ramsavi
11 Replies
LEARN ABOUT CENTOS
papi_flops
PAPI_flops(3) PAPI PAPI_flops(3)NAME
PAPI_flops -
Simplified call to get Mflops/s (floating point operation rate), real and processor time.
SYNOPSIS Detailed Description
C Interface:
#include <papi.h>
int PAPI_flops( float *rtime, float *ptime, long long *flpops, float *mflops );
Parameters:
*rtime total realtime since the first call
*ptime total process time since the first call
*flpops total floating point operations since the first call
*mflops incremental (Mega) floating point operations per seconds since the last call
Return values:
PAPI_EINVAL The counters were already started by something other than PAPI_flops().
PAPI_ENOEVNT The floating point operations event does not exist.
PAPI_ENOMEM Insufficient memory to complete the operation.
The first call to PAPI_flops() will initialize the PAPI High Level interface, set up the counters to monitor the PAPI_FP_OPS event and
start the counters.
Subsequent calls will read the counters and return total real time, total process time, total floating point operations since the start of
the measurement and the Mflop/s rate since latest call to PAPI_flops(). A call to PAPI_stop_counters() will stop the counters from running
and then calls such as PAPI_start_counters() or other rate calls can safely be used.
PAPI_flops returns information related to theoretical floating point operations rather than simple instructions. It uses the PAPI_FP_OPS
event which attempts to 'correctly' account for, e.g., FMA undercounts and FP Store overcounts, etc.
See Also:
PAPI_flips()
PAPI_ipc()
PAPI_epc()
PAPI_stop_counters()
Author
Generated automatically by Doxygen for PAPI from the source code.
Version 5.2.0.0 Tue Jun 17 2014 PAPI_flops(3)