Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Server & Storage Systems
This discussion is archived
on Jun 2, 2010 4:32 PM by 807559
Dtrace script to capture time spent executing shell commands
May 14, 2010 2:00 PM
My 1st dtrace script to capture time spent by oracle executing various commands, is this correct? It seems to work...
/usr/sbin/dtrace -n '
#pragma D option quiet
#pragma D option switchrate=10
/uid == 900/
self->t = timestamp;
/uid == 900/
printf("%-20d %s\n", (timestamp - self->t), curpsinfo->pr_psargs);
thanks for any feedback.
This content has been marked as final.
Show 1 reply
Re: Dtrace script to capture time spent executing shell commands
Jun 2, 2010 4:32 PM
in response to
Hi Stuart -
Just to be clear, you wanted to know the time Oracle takes to exec() a command, or to actually run a short-lived process from start to finish? The script accomplishes the former, but I'm curious why you'd want that particular value.