Home » RDBMS Server » Server Administration » log switch and instance monitoring
log switch and instance monitoring [message #552695] Fri, 27 April 2012 06:34 Go to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
how can i monitor the instance status and log switch summary.

regards
pritesh ranjan
Re: log switch and instance monitoring [message #552697 is a reply to message #552695] Fri, 27 April 2012 06:59 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
instance status can be check by v$instace but how log switch?
Re: log switch and instance monitoring [message #552699 is a reply to message #552697] Fri, 27 April 2012 07:18 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$loghist, v$log_history, v$archived_log.

Regards
Michel
icon7.gif  Re: log switch and instance monitoring [message #552742 is a reply to message #552699] Fri, 27 April 2012 13:20 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
actually i want to know to monitor the number of redo log switches per hour in a day.

regards
pritesh ranjan

Re: log switch and instance monitoring [message #552743 is a reply to message #552742] Fri, 27 April 2012 13:24 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And you can do it with any of the views I posted.

Regards
Michel
Re: log switch and instance monitoring [message #552745 is a reply to message #552743] Fri, 27 April 2012 13:26 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
thanks
Re: log switch and instance monitoring [message #552746 is a reply to message #552742] Fri, 27 April 2012 13:27 Go to previous messageGo to next message
BlackSwan
Messages: 26763
Registered: January 2009
Location: SoCal
Senior Member
SELECT To_char(first_time, 'YYYY-MM-DD HH24') BY_HOUR, 
       COUNT(*) 
FROM   V$LOG_HISTORY 
GROUP  BY To_char(first_time, 'YYYY-MM-DD HH24') 
/ 
Re: log switch and instance monitoring [message #552819 is a reply to message #552746] Sun, 29 April 2012 00:43 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member

SQL> select to_char(first_time,'yyyy-mm-dd hh24') by_hour, count(*) from v$log_h
istory group by to_char(first_time,'yyyy-mm-dd hh24') order by by_hour;

BY_HOUR COUNT(*)
------------- ----------
2012-04-27 03 2
2012-04-27 11 2
2012-04-27 17 1
2012-04-27 20 1
2012-04-27 22 1
2012-04-27 23 4
2012-04-28 03 1
i cant understand here the output by_hour what is here 03,11,17,20,22 etc is it represent the time or hour? if it represent the hour then which manner it represent the the hour.

thanks & regards
pritesh ranjan
Re: log switch and instance monitoring [message #552821 is a reply to message #552819] Sun, 29 April 2012 00:56 Go to previous message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
HH24

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

[Updated on: Sun, 29 April 2012 00:56]

Report message to a moderator

Previous Topic: Upgrade 10.2.0.5 to 11.2.0.3
Next Topic: which initializaion parameter cant be change
Goto Forum:
  


Current Time: Wed Apr 14 18:24:33 CDT 2021