Dear Experts,
I am getting following error while exe. the query:-
SQL> select to_date('2021-03-17 03:00:00','yyyy-mm-dd hh24:mi')||','|| event||','||
2 total_waits||','||time_waited||','|| average_wait*10
3 from v$system_event
4 where time_waited > 1
5 and event not like 'rdbms ipc %'
6 and event not like '%timer%'
7 and lower(event) not like '%idle%'
8 and lower(event) not like 'sql%net%'
9 and event not like 'Streams AQ:%'
10 and event not like 'ges%'
11 order by time_waited desc;
select to_date('2021-03-17 03:00:00','yyyy-mm-dd hh24:mi')||','|| event||','||
*
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string