Running Swingbench oewizard in lights-out mode and connecting as SYSDBA

It seemed a simple enough thing to need to do;

Use the Swingbench oewizard tool to generate 1TB of data in my test database on DSSD, using the lights-out mode.

I am guessing everyone else knows how to do this, but it wasn’t obvious to me! And after spending nearly thirty minutes online trying to figure out how to connect through JDBC thin drivers as a SYSDBA privileged account, I finally realized that you specify the SYS password, but you DON’T specify the SYS username

So for any other DBAs as dense as me; here is how to create a 1TB Swingbench SOE schema using the oewizard in lights-out mode:

./oewizard -cl -create -scale 1000 -u soe -p soe -ts soe -tc 96 -df +DATA -cs //localhost:1521/dssd04 -dt thin -part -allindexes -bigfile -dbap oracle

After indexes are added, the SOE tablespace will be about 2.2TB.

Creating Oracle ASM disks on EMC DSSD flash storage

EMC recently announced the availability of its DSSD rack scale flash storage appliance.

DSSD’s specs are impressive:

  • 10 Million IOPs
  • 100GB/S bandwidth
  • 144TB capacity
  • 100uS latency

The DSSD D5 takes a different approach to flash storage, by eliminating the latency prone networking layer typically handled by Fibre Channel, Infiniband or iSCSI. DSSD replaces this with a PCI extension through a proprietary PCIe Isley Card that connects servers to the D5.

DSSD also replaces conventional SSDs that package NAND technology and makes them look like fast spinning disks, with Flash Modules that eliminate much of the latency of mimicking spinning disks.

There’s a lot more to the D5 that just that, but I am taking a DBA centric approach, and all I want to know is, how do I consume this fast storage in my database?

Continue reading