Fews surprises: Oracle 7.3, HP and TPC-C

Just heard on the grape-vine that Oracle is back in business with benchmarking. Oracle achieved a whopping 5,369.68 tpmC (note TX per Minute and it is TPC-C not TPC-A) on a HP T500 12CPU HP/UX-10

The interesting about it is it was with Oracle 7.3! Here I am still playing around with 7.1. Looks like we can look forward to a better performance Oracle 7.x

Seems that there is a vast improvement in their cost base optimiser. It will understand data distribution ie a _real_ statistical optimiser, faster indexing, querying and rebuilds. Also asyn read-ahead of data.

Not sure about this utility called Oracle Trace but it is suppose to be used for performance tuning by capturing data for analysis. It is suppose to be one of the 1st products to originate from the acquisition RDB.

ta
tony

-- 
_____       ________ / ____  |Tony Jambu, Database Consultant
 /_  _        /_ __ /        |Wizard Consulting Pty Ltd
/(_)/ )(_/ \_/(///(/_)/_(    |IOUG's Select Asia-Pacific Tech. Editor
\_______/                    |Victorian OUG - President
---------------------------  |Vic OUG BBS - Sys Op
Compuserve:100250,2003       |PHONE: +61-3-4212905  +61-41-9TJAMBU(9852628)
INTERNET: TJambu_at_wizard.com.au|FAX: +61-3-416 3559  BBS: +61-3-7761598