Oracle Corp reference one of my test results

Oracle refenrce one of my tests...

http://www.oracle.com/us/corporate/press/497230

On-chip Cryptographic Acceleration – New crypto units support over a dozen industry standard ciphers, enabling security conscious organizations in industries including telecommunications, healthcare, financial services and the public sector to keep their data safe with up to 44 percent faster secure queries than the latest generation of x86 systems when encrypted with Oracle's Advanced Security Products(4), 3x faster Oracle Solaris ZFS file system encryption than the latest generation of x86 systems(5), and 4x faster single-thread OpenSSL security than IBM POWER7(6).

Footnotes:
(6)Comparison is based on internal testing of AES-256-CBC encryption at 8K using OpenSSL against published test results for IBM: http://xmlisnotaprotocol.blogspot.com/2010/10/openssl-098-benchmark-on-power7-35ghz.html.

Sun SPARC Enterprise T3

Sun SPARC Enterprise T3 is out:

16 cores and good Siebel 8.1.1 benchmark results

http://www.oracle.com/us/solutions/performance-scalability/t3-1-siebel-crm-92010-bmark-173392.html


http://blogs.sun.com/BestPerf/entry/20100930_sparct3_2_x86_consolidation

Getting ETL from redo log data

I'm designing an Inmon G.I.F like data warehouse and need to source data from a OLTP CRM like bespke app that I don't want to mess with. I've been investigating tools that can do changed data capture (CDC) from redo logs,no need to use Oracle's CDC. Using some kind of CDC reduces your data warehouse load sizes as you can just grab the deltas, Oracle RDBMS has built in CDC that comes in the Ent.Ed but may need DBMS streams and other configuration
Attunity CDC can be installed where the staging area is (no installation required on the machine where Oracle lives) Access to the redo log is through a SQL*Net connection.

Check out Attunity CDC and GoldenGate(now Oracle), superior to built in Oracle CDC. Still need to set the DB to add a supplemental log destination

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

Attunity Pricing is based on the h/w config of the ETL platform where Attunity is installed; i.e. #cpu's and how many Oracle DB's get connected to from the ETL platform

Oracle Siebel 8 support on IBM AIX6

AIX 6 and Siebel version 8.0.0.10 will play together,AIX 6 and Siebel version 8.0.0.5 or below will not, AIX 5.3 TL12 may be the best option for support longevity.

RAT for all

One of the nice features of Oracle 11g is Real Application testing, basically you can record and playback database loads - and with a bit of opatch'n you can also record loads from older version and playback (with and 11g installation) retro fit that shi7!

http://www.oracle.com/technology/products/manageability/database/pdf/metalink_real_application_testing_for_earlier_releases.pdf

Premier Support for 10gR2 10.2.0.4 Database ends July 31,2010

More here...
http://www.oracle.com/support/lifetime-support-policy.html

Oracle on VMWare

Why do Oracle hate VMWare so? all this proprietary commercial licensed bullshit has to go...Viva la Revolution!


Support Position for Oracle Products Running on VMWare Virtualized Environments [ID 249212.1]

Modified 16-NOV-2007 Type ANNOUNCEMENT Status PUBLISHED

Purpose
---------
Explain to customers how Oracle supports our products when running on VMware

Scope & Application
----------------------
For Customers running Oracle products on VMware virtualized environments.
No limitation on use or distribution.


Support Status for VMware Virtualized Environments
--------------------------------------------------
Oracle has not certified any of its products on VMware virtualized
environments. Oracle Support will assist customers running Oracle products
on VMware in the following manner: Oracle will only provide
support for issues that either are known to occur on the native OS, or
can be demonstrated not to be as a result of running on VMware.

If a problem is a known Oracle issue, Oracle support will recommend the
appropriate solution on the native OS. If that solution does not work in
the VMware virtualized environment, the customer will be referred to VMware
for support. When the customer can demonstrate that the Oracle solution
does not work when running on the native OS, Oracle will resume support,
including logging a bug with Oracle Development for investigation if required.

If the problem is determined not to be a known Oracle issue, we will refer
the customer to VMware for support. When the customer can demonstrate
that the issue occurs when running on the native OS, Oracle will resume
support, including logging a bug with Oracle Development for investigation
if required.

NOTE: Oracle has not certified any of its products on VMWare, and use of
Oracle products in the RAC environment is also not supported.

Oracle to Postgres Conversion

Im not getting a good feeling from what's happening at Sun since Oracle took over,lots of good people seem to have left, Solaris now needs a support contract to use after 90 days(read the download T&Cs)who knows how open MySQL will be? oh well there is always open Solaris and hopefully ZFS will go into more OSs likse it did into freeBSD
I personally get a bad feeling from ALL CLOSED STANDARD COMMERCIAL PROPERTY software.
At the end of the day Oracle's #1 job is to make money, databases ,applications,hardware ,software and services are all tools to achieve this

postgeSQL looks like the likely candidate due to is support in apache hadoop and even a variant in commercial products like Greenplums data warehouse cloud

anyway here is a spot to put Oracle to postgreSQL links, I think downreved ORA to latest PG is a doable migration. Just a straight DB is good, PLSQL makes it harder but there are conversion tools

Oracle to Postgres Conversion - PostgreSQL Wiki
Orafce Project - Oracle functions
Oracle to PostgreSQL

ASM and HDS HDP

A client is looking at moving from Oracle 10g on AIX5.3, all JFS2 file systems to ASM. The SAN is HDS: USP-V fronting USP and AMS arrays. HDS supports Thin provisioning with Oracle ASM based storage so it would be nice to have for migrations,they wont need to have all of the storage up front and according to Oracle its OK http://www.oracle.com/technology/products/database/asm/pdf/hds%20hdp_bestpractice_wp%203-14-2008.pdf Page 22 is a little worrying based on Oracle's testing, there is a potential of 8-25% adverse performance impact when thin provisioning is used. I guess thats when ASM is striping AND HDS is striping in the background too - ASM must be told external RAID is being used basically.

As long as they do as recommended, ie all RAID Groups and Parity Groups in a pool are taken from multiple/different back end adapters, same disk size/speed, same RAID levels they should hit the performance statistics mentioned under "ASM on HDP - Recommended configuration".

RAID Groups and Parity Groups are just terminology for the group of disks configured in a RAID set in HDS Modular(AMS) & Enterprise(USP) arrays respectively.