User Tools

Site Tools


oracle:oracle_sql_querys:status_and_configuration

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
oracle:oracle_sql_querys:status_and_configuration [2019/08/28 09:39]
dodger [Parametros]
oracle:oracle_sql_querys:status_and_configuration [2019/08/28 09:44] (current)
dodger
Line 225: Line 225:
 <code sql> <code sql>
 ALTER SYSTEM RESET <​PARAMETER_NAME>​ ; ALTER SYSTEM RESET <​PARAMETER_NAME>​ ;
 +</​code>​
 +
 +
 +===== Standby redo logs =====
 +This query  will show ''​ORL''​ for //ONLINE redo logs// and ''​SRL''​ for //STANDBY redo logs//
 +
 +<code sql>
 +COL member format 150
 +select lf.group#,​l_type.log_type as type, lf.member
 +from v$logfile lf
 +join (
 +   ​select group#,'​ORL'​ as log_type from v$log
 +   union
 +   ​select group#,'​SRL'​ as log_type from v$standby_log) l_type
 +on lf.group#​=l_type.group#​
 +order by lf.group#
 +/
 </​code>​ </​code>​
  
oracle/oracle_sql_querys/status_and_configuration.txt · Last modified: 2019/08/28 09:44 by dodger