02-09-2006
Quote:
Originally Posted by ranj@chn
Hi,
I cant give the snapshot, but the explanation is here. It is a proC code which declares a cursor for a join between two tables:
table1: 959424 rows, table2: 1892623 rows.
Problem: It is virtually impossible for anyone to snap a guess on this. You need to do some more investigative work. Take your Pro*C SQL and check the execution plan in sqlplus or some other utility or turn tracing on while the application is running and run a TKPROF report. This will give you the answer. Your DBAs should be able to assist you with explain plan, tracing, and tkprof. Look for how the two tables are joined (in the plan). Make sure Oracle is using an index, which it probably isn't. If this is the case, make sure the index is valid and have the DBAs generate fresh statistics. If your problem doesn't go away, post the explain plan (preferably the tkprof report) and the problem should present itself. Database structural problems can cause problems but it's not likely to be the case here.
Quote:
Originally Posted by fidodido
I assume you have some tedious working on the ProC side once the rows are fetched ? because.. one could think you could do this without using ProC and spooling the file directly from SQL*Plus (assuming you're using Oracle), avoiding the ProC overhead.
Problem: Pro*C isn't optimized, I'll give you that *but* it's C code, just like sqlplus was written in. I'm going out on a limb here but I would imagine that if the OP's process was running in 15 minutes with 1mm rows joining 1.8mm rows, without changing anything from the application side...then...Pro*C's poor C optimization is affecting the result set's performance. The same poorly performing SQL is going to run just as poor in sqlplus.
![Roll Eyes (Sarcastic) Smilie](https://www.unix.com/images/smilies/rolleyes.gif)
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I need help with this:
Can any one tell me what does these below mean:
1. "\(.\).*") != '/'
2. sed 's+^\./++;s+/.*++'
3. sed "s+${f}/+ +
Thanks in advance (7 Replies)
Discussion started by: moe2266
7 Replies
2. Shell Programming and Scripting
HI Friends,
My actual requirement is to find out the binary files except txt/gif from parent and subdirectories. so,i have to write unix shell script.
Any one please suggest me on this how to write script for this or any other alternate way is there to find out.
Thanks & Regards,
Srujana (13 Replies)
Discussion started by: srujana
13 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I want to delete older files from ftp server.
(files which are more than 5 days old).
Please advice
Thanks ,
sam (3 Replies)
Discussion started by: sam99
3 Replies
4. Shell Programming and Scripting
Hi ,
I want gzip a folder te55 which has got 3 files test1.test2,test3
the name of the gzipped folder should be te55.gz with the 3 files as test1,test2,test3 itself...
Is it possible...
thanks in advance
sam (5 Replies)
Discussion started by: sam99
5 Replies
5. Shell Programming and Scripting
hi,
I am using this to get previous month
`date -d"1 month ago" "+%m"`
But will it work for january?..will it return 12?
Please advice. (2 Replies)
Discussion started by: vanathi
2 Replies
6. Shell Programming and Scripting
HI
system.sysUpTime.0 : Timeticks: (1519411311) 175 days, 20:35:13.11
From the above output i need only 175days in a perl script..
Please Help (2 Replies)
Discussion started by: Harikrishna
2 Replies
7. UNIX for Dummies Questions & Answers
hi
i wrote a script to run 'C' executable which will create a new file, after that util is completed, i have to change the file ownership to some other user. for that i used "chown" for changing the file permission in Korn script
:confused:but it is throwing error is "operation... (2 Replies)
Discussion started by: ilayans
2 Replies
8. Solaris
HI Friends,
What is the min. Requirement to install Solaris ZONEs, i am using INTEL PC at home and i allready installed Solaris 10 can i configure ZONES in it, and i want to know the basic information of ZONES. Thanks in Advance. (3 Replies)
Discussion started by: kurva
3 Replies
9. Solaris
I copied a file from one host to another using sftp. But after copying the time stamp is not updating . Even though I checked the permission, it looks good. I copied the same file to some temporary location, there it updating the time stamp. Anyone have any idea on this (6 Replies)
Discussion started by: rogerben
6 Replies
10. AIX
HI
in a vg i want to display the lv name & whether the LV is enabled with DS_LVZ parameter?
I used
#lsvg -o | grep vgname | lsvg -il
this gives the output of lv's in the vg.
buti treid with
lsvg -o | grep vgname| lsvg -il | egrep "LOGICAL VOLUME|DS_LVZ"
but No... (5 Replies)
Discussion started by: balumurugesh
5 Replies
LEARN ABOUT CENTOS
anacrontab
ANACRONTAB(5) File Formats ANACRONTAB(5)
NAME
/etc/anacrontab - configuration file for Anacron
DESCRIPTION
The /etc/anacrontab configuration file describes the jobs controlled by anacron(8). It can contain three types of lines: job-description
lines, environment assignments, or empty lines.
Job-description lines can have the following format:
period in days delay in minutes job-identifier command
The period in days variable specifies the frequency of execution of a job in days. This variable can be represented by an integer or a
macro (@daily, @weekly, @monthly), where @daily denotes the same value as the integer 1, @weekly the same as 7, and @monthly specifies that
the job is run once a month, independent on the length of the month.
The delay in minutes variable specifies the number of minutes anacron waits, if necessary, before executing a job. This variable is repre-
sented by an integer where 0 means no delay.
The job-identifier variable specifies a unique name of a job which is used in the log files.
The command variable specifies the command to execute. The command can either be a command such as ls /proc >> /tmp/proc or a command to
execute a custom script.
Environment assignment lines can have the following format:
VAR=VALUE
Any spaces around VAR are removed. No spaces around VALUE are allowed (unless you want them to be part of the value). The specified
assignment takes effect from the next line until the end of the file, or to the next assignment of the same variable.
The START_HOURS_RANGE variable defines an interval (in hours) when scheduled jobs can be run. In case this time interval is missed, for
example, due to a power down, then scheduled jobs are not executed that day.
The RANDOM_DELAY variable denotes the maximum number of minutes that will be added to the delay in minutes variable which is specified for
each job. A RANDOM_DELAY set to 12 would therefore add, randomly, between 0 and 12 minutes to the delay in minutes for each job in that
particular anacrontab. When set to 0, no random delay is added.
Empty lines are either blank lines, line containing white spaces only, or lines with white spaces followed by a '#' followed by an arbi-
trary comment.
You can continue a line onto the next line by adding a '' at the end of it.
In case you want to disable Anacron, add the 0anacron cron job (which is a part of crontab(1)) into the /etc/cron.hourly/jobs.deny direc-
tory.
EXAMPLE
This example shows how to set up an Anacron job similar in functionality to /etc/crontab which starts all regular jobs between 6:00 and
8:00 only. A RANDOM_DELAY which can be 30 minutes at the most is specified. Jobs will run serialized in a queue where each job is started
only after the previous one is finished.
# environment variables
SHELL=/bin/sh
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
RANDOM_DELAY=30
# Anacron jobs will start between 6am and 8am.
START_HOURS_RANGE=6-8
# delay will be 5 minutes + RANDOM_DELAY for cron.daily
1 5 cron.daily nice run-parts /etc/cron.daily
7 0 cron.weekly nice run-parts /etc/cron.weekly
@monthly 0 cron.monthly nice run-parts /etc/cron.monthly
SEE ALSO
anacron(8), crontab(1)
The Anacron README file.
AUTHOR
Itai Tzur <itzur@actcom.co.il>
Currently maintained by Pascal Hakim <pasc@(debian.org|redellipse.net)>.
For Fedora, maintained by Marcela Malaova <mmaslano@redhat.com>.
cronie 2012-11-22 ANACRONTAB(5)