Oracle11g Data Guard: Database Rolling Upgrade Shell Script
Found a nice script to be used for rolling upgrades on Oracle Support. Please check it out here Oracle11g Data Guard: Database Rolling Upgrade Shell Script
Virtualbox automation scripts
As I’m trying to speed up things while I’m creating my ORACLE environments I started to build up some scripts to help me on doing it faster. 1. Adapt the network and the hosts file Note: I’m running this script from my local server and not from VM, like this: # root>ssh r[email protected] < $script_location/adapt_network.sh…
Grab stats for partitions
Useful scripts to grab stats for partitions: set serveroutput on DECLARE LV_SQL VARCHAR2(1000); CURSOR C1 IS SELECT TABLE_NAME T , PARTITION_NAME P , LAST_ANALYZED L FROM USER_TAB_PARTITIONS WHERE LAST_ANALYZED is null AND TABLE_NAME = ‘&TABLE_NAME’ and partition_name like (‘&PART_NAME’); BEGIN FOR I IN C1 LOOP dbms_output.put_line(‘Gathering stats for :’||I.P); LV_SQL:= ‘BEGIN ‘;…
