Press Summary
Exadata Storage Indexes, LIKE, BETWEEN, and Wild Cards
July 18th, 2011
Written by John Clarke
What is a Storage Index? Storage Indexes are a feature unique to Oracle Exadata. A storage index is a memory-based structure that reduces the amount of physical IO required by the cell. A storage index keeps track of minimum and maximum values from query predicates and builds storage index regions based on usage. The example above shows that for a given table, T, the values for column B are tracked such that in the example where B<2 is provided, Oracle will know to use...
Exadata Storage Indexes, Bind Variables, and NULLS
July 18th, 2011
Written by John Clarke
What is a Storage Index? Storage Indexes are a feature unique to Oracle Exadata. A storage index is a memory-based structure that reduces the amount of physical IO required by the cell. A storage index keeps track of minimum and maximum values from query predicates and builds storage index regions based on usage. The example above shows that for a given table, T, the values for column B are tracked such that in the example where B<2 is provided, Oracle will know to use the...
Monitoring Exadata with Statistics
June 11th, 2011
Written by John Clarke
In Oracle 11gR2, additional Exadata cell-related system events have been added to the normal system event-based dynamic performance views. There are 58 different cell-related or Flash Cache related wait events available:
SQL> l
1 select name from v$statname
2* where name like '%cell%' or name like '%flash
cache%'
SQL> /
cell physical IO interconnect bytes
cell physical IO bytes pushed back due to
excessive CPU on cell
physical read flash cache hits
flash cache inserts
flash cache...
Exadata: Using cellcli and dcli
June 5th, 2011
Written by John Clarke
Using CELLCLI Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface. To invoke the CLI, simply login to the Exadata cell as cellmonitor, celladmin, or root, and type "cellcli". Within cellcli, a wide range of commands can be invoked to monitor the cell.
Macintosh-7:~ jclarke$ ssh
cellmonitor@cm01cel01
cellmonitor@cm01cel01's password:
Last login: Fri May 6 08:46:08 2011 from
172.16.150.11
[cellmonitor@cm01cel01 ~]$ cellcli...
Exadata: Initial Installation Validation
June 1st, 2011
Written by John Clarke
After our successful implementation of our Exadata Quarter Rack, we wanted to share our configuration details and scripts used to validate the installation. As you probably know, the Exadata Database Machine is a combination of compute nodes (database servers), storage cell nodes, a high-speed InfiniBand interconnect network, an embedded Cisco switch, a KVM switch, all contained in a purpose-built rack with redundant power supplies. In this blog post, I'll show actual information and details...
