Hi,
on 10g R2 how to display the numbers (and not to have #### instead) :
SQL> set lines 120 trimspool on
SQL> col event head "Waited for" format a30
SQL> col total_waits head "Total|Waits" format 999.999
SQL> col tw_ms head "Waited|for (ms)" format 999.999.99
SP2-0246: cha¯ne de FORMAT non autorisÚe "999.999.99"
SQL> col aw_ms head "Average|Wait (ms)" format 999.999.99
SP2-0246: cha¯ne de FORMAT non autorisÚe "999.999.99"
SQL> col mw_ms head "Max|Wait (ms)" format 999.999.99
SP2-0246: cha¯ne de FORMAT non autorisÚe "999.999.99"
SQL> select event, total_waits, time_waited*10 tw_ms,
2 average_wait*10 aw_ms, max_wait*10 mw_ms
3 from v$session_event
4 where sid =152;
Total Waited Average Max
Waited for Waits for (ms) Wait (ms) Wait (ms)
------------------------------ -------- ----------- ----------- -----------
class slave wait 1.000 .00 .10 .00
Streams AQ: waiting for time m ######## ########### ########### ###########
anagement or cleanup tasks
events in waitclass Other 1.000 .00 .00 .00
Thank you