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, [...]
Archive for the ‘Uncategorized’ Category
Public Yum Server
Generate SQL*Loader (sqlldr) Control File Script
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, [...]
Basic RAC configuration
Oracle Real Application Cluster (RAC) is the successor to Oracle Parallel Server (OPS) and allows multiple instances to access the same database (storage) accessing and modifying the same data at the same time. RAC provides fault tolerance, load balancing, and performance benefits by allowing the system to scale out, and at the same time since [...]
Calibrate I/O
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; [...]
Partition Alignment with sfdisk 1 comment
# – # — Partition alignment of OCR / Vote Disks with 1MB offset echo “2048,,” | sfdisk -uS /dev/emcpowera echo “2048,,” | sfdisk -uS /dev/emcpowerb echo “2048,,” | sfdisk -uS /dev/emcpowerc # – # — Partition alignment of Data / FRA disks with 4MB offset echo “8192,,” | sfdisk -uS /dev/emcpowerd echo “8192,,” | [...]
Maintaining ASM Volumes and Cluster File Systems in Oracle Database 11g Release 2
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 [...]