-
Generate Trace for Cron job
Hi
I hv oracle version of 8.1.6 which runs on HP Tru64. I would be running a cron at a specific time.
I will be giving command something like
$at 0100 query.sh
I wanted to trace the query. How to do it?
rammi
-
Re: Generate Trace for Cron job
Originally posted by rammi65
Hi
I hv oracle version of 8.1.6 which runs on HP Tru64. I would be running a cron at a specific time.
I will be giving command something like
$at 0100 query.sh
I wanted to trace the query. How to do it?
by the way that is an at job, not a cron job.
Anyhoo, the same way you would trace any query, change it to set sql_trace = true or set 10046 event, then get your trace file and run tkprof on it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|