OraFAQ Forum: Server Administration » log switch and instance monitoring

Home » RDBMS Server » Server Administration » log switch and instance monitoring

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

log switch and instance monitoring [message #552695]

Fri, 27 April 2012 06:34

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

Report message to a moderator

Re: log switch and instance monitoring [message #552697 is a reply to message #552695]

Fri, 27 April 2012 06:59

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

instance status can be check by v$instace but how log switch?

Report message to a moderator

Re: log switch and instance monitoring [message #552699 is a reply to message #552697]

Fri, 27 April 2012 07:18

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

Report message to a moderator

Re: log switch and instance monitoring [message #552742 is a reply to message #552699]

Fri, 27 April 2012 13:20

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

Report message to a moderator

Re: log switch and instance monitoring [message #552743 is a reply to message #552742]

Fri, 27 April 2012 13:24

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

Report message to a moderator

Re: log switch and instance monitoring [message #552745 is a reply to message #552743]

Fri, 27 April 2012 13:26

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

thanks

Report message to a moderator

Re: log switch and instance monitoring [message #552746 is a reply to message #552742]

Fri, 27 April 2012 13:27

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') 
/

Report message to a moderator

Re: log switch and instance monitoring [message #552819 is a reply to message #552746]

Sun, 29 April 2012 00:43

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

Report message to a moderator

Re: log switch and instance monitoring [message #552821 is a reply to message #552819]

Sun, 29 April 2012 00:56

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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