1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
[22] TOTO_SQL.master.1> select top 10 object_name(ObjectID, DBID), IndexID, LastUsedDate from monOpenObjectActivity order by 3 ;
IndexID LastUsedDate
------------------------------ ----------- -------------------
map 0 NULL
format 0 NULL
sector 0 NULL
address 0 NULL
archive 0 NULL
deposit 0 NULL
notepad 0 NULL
printer 0 NULL
synonym 0 NULL
ud_list 0 NULL
(10 rows affected)
[23] TOTO_SQL.master.1> select top 10 object_name(ObjectID, DBID), IndexID, LastUsedDate from monOpenObjectActivity order by 3 desc;
IndexID LastUsedDate
------------------------------ ----------- -------------------
CUS_FR_FI_VALO 0 Aug 31 2007 3:44PM
monOpenObjectActivity 0 Aug 31 2007 3:44PM
appl_user 2 Aug 31 2007 3:44PM
portfolio 2 Aug 31 2007 3:44PM
ud_portfolio 2 Aug 31 2007 3:44PM
dict_function 2 Aug 31 2007 3:44PM
strategy_element 2 Aug 31 2007 3:44PM
strategy 3 Aug 31 2007 3:44PM
data_prof_compo 3 Aug 31 2007 3:44PM
strategy_history 3 Aug 31 2007 3:44PM
(10 rows affected)
[24] TOTO_SQL.master.1> |
Partager