Home

About Me Contact Me Oracle12cSIG(IOUG)
 
Home  :: Query Log Switch Rate

Query Log Switch Rate

0 Comments

Query Log Switch Rate

col day format a20;
col hour format a6;
col total format 9999;
select to_char(first_time,'yyyy-mm-dd') day,
to_char(first_time,'hh24') hour,
count(*) total
from v$log_history
group by to_char(first_time,'yyyy-mm-dd'),to_char(first_time,'hh24')
order by to_char(first_time,'yyyy-mm-dd'),to_char(first_time,'hh24')
asc;

Posted on : by Anuj
 
Comments
No comment found.
 


Add Your Comments
 
Name :
Email :
Comments :

 

 
 
  Archives
 
  Recent Posts

Open world 2018 is on the corner! Are you attending?
Posted on :   9/7/2018

Step by Step Oracle Database 18c Installation on Oracle Linux 6
Posted on :   9/4/2018

APACOUC Session - Oracle 12cR1 was great Oracle 12c R2 is awesome! by Anuj Mohan
Posted on :   9/4/2018

  Recent Comments
 

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved 2013 Oracle-12c