RE: Timing program execution on Windows
- From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: "Jared Still" <jkstill@xxxxxxxxx>
- Date: Fri, 1 Dec 2006 14:08:23 -0500
Jared,
Here is something interesting:
RMAN> sql 'insert into absdba.tomtest values(sysdate)';
using target database controlfile instead of recovery catalog
sql statement: insert into absdba.tomtest values(sysdate)
RMAN> exit
So you can include sql statements within the rman script to update a
record in a database table to track your steps within rman. The table
"tomtest" has one column - a date field.
Tom
________________________________
From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Friday, December 01, 2006 1:56 PM
To: Mercadante, Thomas F (LABOR)
Cc: Oracle-L Freelists
Subject: Re: Timing program execution on Windows
On 12/1/06, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote:
Jared,
You can get the times from the Rman repository (if you are using one).
In the RC_BACKUP_SET view there are starttime and endtime columns (date
fields). Other than that, you can "echo time /t" in your NT script to
get start and end times.
Not using a repository, but thanks for the suggestion.
echo time /t would require me to write a script to do the
math myself (don't want to). I'm sure it's been done.
In fact, it has: http://search.cpan.org/dist/ppt/
the 'time' command uses the Benchmark module
Tom
________________________________
This transmission may contain confidential, proprietary, or
privileged information which is intended solely for use by the
individual or entity to whom it is addressed. If you are not the
intended recipient, you are hereby notified that any disclosure,
dissemination, copying or distribution of this transmission or its
attachments is strictly prohibited. In addition, unauthorized access
to this transmission may violate federal or State law, including the
Electronic Communications Privacy Act of 1985. If you have received
this transmission in error, please notify the sender immediately by
return e-mail and delete the transmission and its attachments.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx> ]
On Behalf Of Jared Still
Sent: Friday, December 01, 2006 12:47 PM
To: Oracle-L Freelists
Subject: Timing program execution on Windows
Any suggestions for a unix like 'time' command that
can be used from the command line, just on unix/linux?
I need to time some RMAN operations on Win32 box.
I've already DL'd and looked at Windows SFU (unix services),
but that is a pretty heavy install to just get the 'time'
command.
Thanks,
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
