|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Accessing variables of one shell script in another shell script | rsendhilmani | Shell Programming and Scripting | 2 | 03-17-2009 01:17 AM |
| Accessing variables of one shell script in another shell script | looza | Shell Programming and Scripting | 2 | 06-30-2008 08:13 PM |
| How to pass a parameter from one Shell-script to another Shell-script | subodhbansal | Shell Programming and Scripting | 2 | 09-22-2007 06:19 AM |
| How to Run a shell script from Perl script in Parent shell? | hifake | Shell Programming and Scripting | 16 | 08-28-2007 09:42 PM |
| Have a shell script call another shell script and exit | heprox | Shell Programming and Scripting | 2 | 11-20-2006 08:17 AM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
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 |
|
| Bookmarks |
| Tags |
| difference, oracle, shell script, shell scripting, sqlplus, time, unix scripting, unix scripting basics |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
