RE: Timing program execution on Windows

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: