Attended UKOUG Tech13 and Oaktable World UK

In cold, yet dry Manchester’s winter, it was quite thermal to simultaneously relish the meritorious UKOUG Tech13 and elite Oaktable World UK 2013 conferences. Pythian’s presence was overwhelming at both congresses. Paul Vallee, Alex Gorbachev, Elliot Zissman, Luke Davies, Paul Logan, Maris Elsins, Marc Fielding, Christo Kutrovsky and Michael McKee (more...)

Off to UKOUG Manchester UK

I am reserved speaker at the UKOUG this year in Manchester and will be traveling almost full length of globe to reach Manchester next week from Australia. Looking forward for technology-packed, fun-infested event. Pythian will be there again in full force too.

Will keep you posted from there :)

SQL_ID in Auto Trace Explain Plan Only

It would be a great enhancement to the nifty and very helpful set autotrace explain plan only statement if it showed the SQL_ID of the query in its output. Currently it shows the SQL Text and the PLAN_HASH_VALUE, but not SQL_ID.

May be an enhancement in Oracle 12cR2 :)

To Get Serial Number of Exadata Rack or Individual Server in Exadata

For the whole Exadata rack serial number:

ipmitool sunoem cli 'show /SP system_identifier'

For the server serial number you are connected to:

ipmitool sunoem cli "show /SYS product_serial_number"

For each component serial number on a single server:

You can also get the individual serial numbers for each component in an (more...)

Simple Way to Get SQL ID of Large and Similar Queries in Oracle

I frequently get clients' request to tune number of queries related to some application or reports. One of the first things to start the tuning process is to get the SQL_ID of the queries. On a busy system, it can be quite a hassle to find out SQL_ID of a (more...)