[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dectrace_v20

Title:DECtrace V2.0 and All-in-1 Perf Rpts conf.
Notice:Kits+Doc, 2 | Patches, 3
Moderator:OMYGOD::LAVASH
Created:Mon Apr 26 1993
Last Modified:Mon Jun 02 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:467
Total number of notes:2058

449.0. "? on /ELAPSED_TIME" by BROKE::BASTINE () Fri Mar 07 1997 12:02

And one more...

They noticed there is a /ELAPSED_TIME on the collect format command.  They
have read the on-line help for it and think they might use it.  However, if
they do, where is this information put?  What tables contain additional 
data to signify this qualifier was used?  

I have tried to find the answers in our database and didn't find anything.

Thanks,
Renee
T.RTitleUserPersonal
Name		DateLines
449.1Event RecordOOTOOL::CRAIGMon Mar 10 1997 12:5910
 	Hi Renee,

	It adds a new column to the Event Table when
	you use this qualifier. They can then query the Event Table
	directly to get the elapsed time.

	Have them try it and do a query to verify.
 
	Thanks,
	Sheri
449.2Do you know the column name by any chance?BROKE::BASTINEMon Mar 10 1997 13:0210
>	It adds a new column to the Event Table when
>	you use this qualifier. They can then query the Event Table
>	directly to get the elapsed time.

What is the new column name?  Probably something really obvious, but thought
I would ask in case you knew off the top of your head!

:)

Renee
449.3OMYGOD::LAVASHSame as it ever was...Mon Mar 10 1997 13:107
I think it is elapsed_time?

SQL> show table x 

will show you all the fields in a table.

George
449.4Not sureOOTOOL::CRAIGMon Mar 10 1997 13:1728
	Hi Renee,

	I was trying to test it for you so that I could give you
	more complete information, but I'm having a problem with my
	Trace environment. I reinstalled everything and had George
	help me with it but I'm not having much luck. I've 
	been working on it for awhile, and I just gave up and entered the
	note.

	It should be something obvious when they get it. The documentation
	shows these fields:

	RECORD TYPE
	FACILITY NUMBER
	EVENT NUMBER
	EVENT NAME
	EVENT HEADER
	EVENT TYPE
	ITEM DESCRIPTOR LIST COUNT
	ITEM DESCRIPTOR LIST

	So it would be one added to this list.

	Let me know if you want to give them specifics and I'll continue
	to get my environment fixed.

	Thanks,
	Sheri
449.5Thank you!BROKE::BASTINEMon Mar 10 1997 13:406
That's ok Sheri... if they ask, I'll let you know.

Thanks!!

Renee
Renee
449.6ELAPSED_TIMEOMYGOD::LAVASHSame as it ever was...Mon Mar 10 1997 13:4213
$COLL FORMAT EPC$EXAMPLES:DEMO_DATA.DAT d /ELAPSE

$SQL
SQL>DECLARE SCHEMA FILE d;
SQL>SHOW TABLE EPC$1_221_TRANSACTION

Shows 
ELAPSED_TIME                    INTEGER

added to the table...

George
449.7Thanks!BROKE::BASTINEMon Mar 10 1997 14:573
Thanks George!!  I thought it might be pretty obvious!

Renee