Press Summary
Using DCLI with Single Quotes in LIST Arguments on Exadata
July 28th, 2011
Written by John Clarke
With Oracle Exadata, CELLCLI is the command-line interface to manage, monitor, and report on storage cell characteristics, configuration, and behavior. While logged on to the storage cell as root, celladmin, or cellmonitor, you can invoke CELLCLI by simply typing “cellcli” at the Linux shell prompt: Once logged in to CELLCLI, you can issue a variety of commands: Output can be limited by using WHERE conditions into the CELLCLI “LIST” commands, as such:...
Can Data Pump Be Used Against Multiple RAC Instances in Parallel?
July 28th, 2011
Written by John Clarke
The simple answer is no, unless you’ve got a shared file-system on which to put your dump and log files. Here’s what happens if not: If we create the same directory name on both servers in a cluster, it’ll work a little bit further but still ultimately fail: Of course, if we had both servers NFS-mounted to a shared file-system with the appropriate mount options, it should work.
Monitoring Exadata Cell Servers with Active Requests
July 27th, 2011
Written by John Clarke
An active request represents a "client" or application-centric view of I/O requests being processed by the cell. Similar to previous sections, the graphic below shows the detail associated with Active Request monitoring. You can use the ioType above to monitor which type of IO is being done, and if run with "detail" it'll show results for all the information in the light-blue color in the graphic above. The output is relatively self-explanatory - I'll generate some load using SwingBench to...
Resizing Exadata Grid Disks and ASM Disk Groups
July 18th, 2011
Written by John Clarke
In this post, we'll show you how to resize your Exadata storage cell Grid Disks and the ASM disk groups that reside on them. We'll assume we've a storage environment comprised of different ASM disk groups for different application and database purposes, and further, different Grid Disks to support these ASM disk group requirements. Let's imagine we want to re-baseline and resize everything. First, we'll "clean up" storage created from our various test case data, drop tablespaces, drop ASM...
Exadata Flash Based Grid Disks
July 18th, 2011
Written by John Clarke
Oracle allows you to configure "Flash-Based Grid Disks" from the PCIe flash cards that reside in each Exadata storage cell. This allows you to create ASM disk groups on flash storage and in theory, should yield solid-state performance gains for the segments residing in these ASM disk groups. In this post we'll perform tests for full-scanning a table when it's stored in an ASM disk group residing entirely on Flash Grid Disks and compare with the same table stored in a tablespace residing on...
