Oracle RAC Expert   Independent Voice on Oracle by Charles Kim

Configure your server for Yum (Yellowdog Updater Modified): There’s no more need to look for CDs from your pile of CDs or from the clutter of your desk. Earlier in 2009, Oracle launched their public yum server which offers a free and convenient way to install packages from the Enterprise Linux and Oracle VM. Obviously, [...]

Here’s what I think is an incredible piece of code to generate SQL*Loader control files for any table in the database. cat generate_control.sql def TAB=’&1′ set head off feed off pages 0 trims on serveroutput on size 1000000 lines 2000 ver off var v_tab VARCHAR2(100); spool &TAB..control declare v_col VARCHAR2(255); cursor c1 is select column_name, [...]

cat io_callibrate.sql set serveroutput on size unlimited set time on timing on echo on declare max_iops integer; max_mbps integer; actual_latency integer; begin dbms_resource_manager.calibrate_io ( num_physical_disks => 48, max_latency => 10, max_iops => max_iops, max_mbps => max_mbps, actual_latency => actual_latency); dbms_output.put_line (‘IOPS = ‘|| max_iops); dbms_output.put_line (‘MBPS = ‘|| max_mbps); dbms_output.put_line (‘Latency = ‘|| actual_latency); end; [...]

Earlier we created an ASM Volume and created Cluster File System. Let’s continue where we left off and do some maintenance. From the ASM Cluster File System main screen (Click on the ASM Cluster File System Tab), we will click on the VOL_LOGFILE volume URL to see volume related information: Click on the Edit button [...]