Tag Archives: Oracle 11g

Performance Tuning Related queries


Monitoring session: =================== Find total active sessions,inactive sessions & logon time from each machine: =========================================================================== set lines 136 pages 999 col OSUSER for a20 col USERNAME for a20 col MACHINE for a30 col STATUS for a9 col MIN_DATE for a20 col MAX_DATE for a20 col CNT for 999 break on status skip 1 compute sum […]

https://kalyandba.wordpress.com/2015/09/04/performance-tuning-related-queries/

Datagaurd Related queries


Switch To Maximum Availability Protection Mode Switch to the desired “maximum availability” protection mode on the primary database (from the default “maximum performance”): SQL> select value from v$parameter where name = ‘log_archive_dest_2′; — must show LGWR SYNC SQL> shutdown normal SQL> startup mount SQL> alter database set standby database to maximize availability; SQL> alter database […]

https://kalyandba.wordpress.com/2015/09/04/datagaurd-related-queries/

#ACM 11g – Activities


http://t.co/Wh4iNUt9Q8