RE: Timing program execution on Windows

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Fri, 1 Dec 2006 14:08:23 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE088F9@EXCNYSM0A1AJ.nysemail.nyenet>

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_at_gmail.com] 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_at_labor.state.ny.us> 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_at_freelists.org [mailto: oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> ] 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


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 01 2006 - 13:08:23 CST