New Oracle 12c IO Outlier Views
With 12c Oracle provides a couple of new views that report IOs that take over 500ms. That 500ms threshold is […]
With 12c Oracle provides a couple of new views that report IOs that take over 500ms. That 500ms threshold is […]
Show Oracle FRA Fast Recovery Area Usage fraUsage.sql –Show Oracle FRA Fast Recovery Area Usage set wrap on column name
sqlplus / as sysdba … alter system set db_recovery_file_dest_size=25G scope=both; alter system set db_recovery_file_dest=’/oracle/fra’ scope=both; # yes this path better
DBMS_SYSTEM pl/sql package does not seem to be documented and may not be supported by Oracle. Here’s where you can
alter database commit to switchover to standby; Reference Oracle 11g Data Guard Switchover and Switchback – Active Data Guard Part-II
My Environment I used VirtualBox to test Oracle 12c 12.2.0.1 Data Guard setup of one primary and one standby (using
No it is not required to use sqlcl for this. sqlplus or any other sql execution tool of your choice
While using dataguard broker is optional with Dataguard, using it adds some complexity and flexibility – expect a little learning
ALTER SESSION SET CURRENT_SCHEMA = <schema name>;
Concerning Oracle RAC 12c, and 11gR2 Virtual IP (VIP) addresses are IP addresses pair with REAL IP addresses and are