Try this:
select date(start_time) as start_date, time(start_time) as start_time,
date(end_time) as end_date, time(end_time) as end_time, SUBSTR (CAST(entity AS
char(17)),1,17) as Node_Name, cast((Bytes/1024) as decimal(15,2)) as
KB_Archived, affected, (end_time-start_time)minutes as Mins from summary where
activity='ARCHIVE' order by start_date
result looks like:
START_DATE START_TIME END_DATE END_TIME NODE_NAME
KB_ARCHIVED AFFECTED MINS
---------- ---------- ---------- -------- -----------------
----------------- -------------------- ----------
2010-03-01 11:50:37 2010-03-01 16:44:35 AUCFDW01_FS
376022498.94 120 293
Regards,
Ankur Patel
Snr Enterprise Mgmt Administrator
Sydney.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
William ZHANG
Sent: Thursday, 1 April 2010 12:26 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] how can I know an archive finished
Hi All,
My colleague is archiving some data by gui interface - dsmj ,
how can I know the finish of this archive if I can not see the gui interface
and he does not close gui.
Thanks and regards,
William
************************************************************************************************
DISCLAIMER
Confidential Communication: This email and any attachments are intended for the
addressee(s)
only and are confidential. They may contain legally privileged or copyright
material. If you
are not the intended recipient, please contact the sender immediately by reply
email and
delete this email and any attachments. You must not read, copy, use, distribute
or disclose
the contents of this email without consent and Harvey Norman Holdings Limited
ACN 003 237 545
(and its related subsidiaries) (?Harvey Norman?) does not accept responsibility
for any
unauthorised use or reliance on the contents of this email.
Harvey Norman does not represent or warrant that the integrity of this email
has been maintained
or that it is free from errors, viruses, interceptions or interference. Any
views expressed by
the sender do not necessarily represent the views of Harvey Norman.
This notice should not be removed from this email.
************************************************************************************************
|