microseconds to seconds
Hello all,
i have the below sql.... and i wanted to convert the time_waited_micro(which is in micro seconds) to seconds....how can i do that ??? so when i run the query it returns the value in seconds ?
select snap_id, event_name, wait_class, total_waits, time_waited_micro from dba_hist_system_event
where wait_class = 'User I/O';