11-30-2008
PL SQL Runtimes different in Shell script log
Hi,
This run times recorded in UX shell script appears peculiar to me. The PL / SQL stored procedure is called through sqlplus from UNIX shell script and then a log is created with run times recorded.
The first set has actually taken 6 Hrs but the recorded time indicates it is only 2 Hrs and 19 mins
STARTED AT: 29-NOV-08 01.36.23.671837000 PM +00:00-
ENDED AT: 29-NOV-08 02.47.08.250187000 PM +00:00
STARTED AT: 29-NOV-08 03.07.19.281072000 PM +00:00-
ENDED AT: 29-NOV-08 04.15.08.122021000 PM +00:00
Below is the second set that has actually taken 7 Hrs but the recorded time indicates it is only 1 Hr 55 mins
STARTED AT: 29-NOV-08 05.52.57.930690000 PM +00:00-
ENDED AT: 29-NOV-08 06.37.50.285460000 PM +00:00
STARTED AT: 29-NOV-08 06.59.09.941000000 PM +00:00-
ENDED AT: 29-NOV-08 09.29.55.689355000 PM +00:00
I may be missing something because it is a huge difference unless there is something that is technically noticed in the past. I know UNIX itself cannot have such anomoly but with PL / SQL and Oracle, not sure. I am sure the experts here can guide me in the right direction.
Regards,
Manjax
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hey I have this shell script that I am trying to run and receive a value from a sql query.Then later use the value in an if stmt... I cannot get this to work for nothing..
Here is the script
(sqlplus -s $usrname/$passwrd <<!
set head off feed off pagesize 0
select b
from table;
set head... (9 Replies)
Discussion started by: devaris22
9 Replies
2. Shell Programming and Scripting
Hi,
I have an issue. There is a file that has got some values seperated by commas. I have to write a shell script that would extrct these values and insert them into a table. How can this be done
Thanx in advance (3 Replies)
Discussion started by: sendhil
3 Replies
3. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
4. Shell Programming and Scripting
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Discussion started by: praka
6 Replies
5. Shell Programming and Scripting
I need help in the following script. I want to grep the sql errors insert into the error table and exit the shell script if there is any error, otherwise keep running the scripts.
Here is my script
#!/bin/csh -f
source .orapass
set user = $USER
set pass = $PASS
cd /opt/data/scripts
echo... (2 Replies)
Discussion started by: allinshell99
2 Replies
6. Shell Programming and Scripting
Hi ,
I need to find runtime of jobs.
I have written below script to get start and end times for a list of jobs.
#!/bin/bash
InputFile_Name=/var/tmp/cgk/pre2_oper_status_7amcheck_jobs
if
then
echo "File: $InputFile_Name doesn't exist , Pls check & run again"
echo "Exiting... (8 Replies)
Discussion started by: cgk1983
8 Replies
7. Shell Programming and Scripting
There are 4 parameters that I have to pass from korn shell to sql script.
1) I have to check if $1 , $2 , $3 and $4 are null values or not .
How can I do that ?
2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
Discussion started by: megha2525
11 Replies
8. Shell Programming and Scripting
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies
9. Shell Programming and Scripting
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
10. Shell Programming and Scripting
SQL*Plus version : 11.2.0.4
OS : Oracle Linux 6.5
SQL*Plus is a client application to connect to oracle database. The log file for this tool is generated via spool command as shown below.
I am trying to append date ( $dateString ) to spool file as shown below.
$ cat test2.sh
#!/bin/bash... (4 Replies)
Discussion started by: kraljic
4 Replies
trbdf(1) User Manuals trbdf(1)
NAME
trbdf - convert BDF-font from one encoding to other
SYNOPSIS
trbdf -C | -l | -h
trbdf [-s] [-f input-codeset ] [-t output-codeset ] [--foundry[=] new-foundry ] BDF-font
DESCRIPTION
trbdf is a program for translation of BDF fonts from one encoding to other. One exciting feature of trbdf is that it tries to approximate
the symbols that miss from the font or from the encoding of the font with existing symbols when possible.
If the option -s or --gen-script is given trbdf will generate an awk(1) script for translation of BDF-fonts for fixed combination of input-
codeset and output-codeset This is useful for faster convertion of many files. This script is used as filter.
If none of -C, -s, -l, -h and their equivalents is given the BDF-font will be read assuming it is coded with codeset input-codeset On stan-
dard output it will be recoded so to use codeset output-codeset Both input-codeset and output-codeset are case insensitive and default to
`cp1251'.
OPTIONS
-C, --copyright
Display copying conditions and warranty information.
-s, --gen-script
Generates conversion script for given input and output encodings instead to convert BDF-font. This option is usefull if you have to
convert many fonts. The generated script expects the input font from its standard input and outputs the converted font.
-l, --list
List all known codesets.
-h, --help
Display this help and exit.
-f input-codeset, --from[=]input-codeset
Codeset of the source font.
-f output-codeset, --to[=]output-codeset
Codeset of the generated font.
--foundry[=]new-foundry
Use this option if you want to change the foundry of the generated fonts.
AUTHOR
Anton Zinoviev <anton@lml.bas.bg>, <zinoviev@fmi.uni-sofia.bg>
SEE ALSO
bdftopcf(1x)
trscripts NOV 2002 trbdf(1)