Search

Top 60 Oracle Blogs

Recent comments

February 2011

Graham Wood's Hidden Features Presentation

Just a super-quick post to highlight the availability of Graham Wood's Hidden Features presentation that I enjoyed at UKOUG 2010. I felt it was one that lots of people could pick up one or two tips or reminders from, just from the slides, but couldn't track it down. Graham's been kind enough to let me host the RMOUG version.

Hopefully more stats posts to come now I'm free of the stats paper and (hopefully) a few support nightmares.

Hadoop/HiveでTPC-H

「Peta Byteを超えるデータ量をスキャンする」のに1台のサーバでは無理がある。
だから、Hadoopということになる。でも「100台のサーバを揃えてテストをする」なんて趣味の範囲を超えてしまうのでできない。
取りあえず、以下の構成4台で、データ量も32GBにしてOracleと比較してみる。

OSもCentOS 5.5 (x86-64)にして、今回使っているAMD Phenom II X6 1100T Black Edition BOX(3.3 GHz/6 core)1台でDOP=6のOracleのパフォーマンスを見てみると:

Interesting Read Followup…

Two days ago I wrote about an interesting security fiasco and said I’d follow up on it in a day or two – so here we are.

Just to recap – I wrote previously:

As a quick test - see if you can

Distinctly Odd

I recently got involved with a performance investigation for an Oracle 9.2 database. The process of investigation threw up some interesting information for me regarding the accuracy of statistics collection in Oracle. It also highlights how different defaults in different versions of Oracle can lead to remarkably different statistics and hence execution plans.  Finally, it [...]

For Vienna and Tallinn...

If you are near Vienna or Tallinn - you have an opportunity to attend an excellent two day seminar hosted by Oracle University - but delivered by Richard Foote. If you really want to know all about indexing in Oracle - this seminar will deliver.

I know Richard really knows his stuff - and I've seen him present many times before. This will be a seriously good event. The linked to page has linked to the registration pages.

The Social Network…

I’m not really a fan of social network sites. I use them from time to time, but if they dropped of the face of the earth tomorrow it wouldn’t make much difference to my life. I have email addresses and phone number of everyone I want to talk to. Nuff said.

With that in mind I really didn’t give a crap about watching The Social Network when it was at the cinema. I was visiting friends last night and they both wanted to watch it, so I was forced into a corner. As it turned out it was a good film. If it had been about some company other than Facebook I would have enjoyed it even more. The film portrayal of the characters is as follows:

  • Mark Zuckerberg: A socially retarded, completely untrustworthy and annoying uber-geek thief. If he’s like this in real life I would definitely not want to meet him and putting a single penny in his pocket is bottom of my list of desires.
  • Sean Parker: A serial screw-up, style over substance, paranoid and incredibly annoying wannabe uber-geek. Once again, if he is like this in real life he’s not on my list of people I would like to meet.
  • Eduardo Saverin: An honest, if a little naive, guy who was surrounded by prize-winning sh*ts who were all out to screw him.

The fact the film is based on a book whose content is mostly drawn from interviews with Eduardo Saverin prior to the completion of his court case against Mark Zuckerberg suggests that maybe the view of the characters is “a little bit biased”. :)

Anyway, get it out on DVD and try to forget it is about Facebook and I think you will like it.

Cheers

Tim…

Last Notice For Seminars Scheduled For Vienna and Tallinn Next Month

Just received an email from Oracle University stating that numbers are very tight for my Index Internals and Best Practices Seminars scheduled next month for Vienna and Tallinn. Unfortunately, due to the travel time, it will be a case of them both running or neither of them going ahead. With cancelled events in the past, it’s [...]

Exadata Serial Numbers

Just a quick post (mostly so I can find the info quickly myself when I want it). Here’s how to get the master serial number for an Exadata Rack:

ipmitool sunoem cli ‘show /SP system_identifier’

Apparently by convention the Exadata Rack serial number is appended to the end of ILOM system identifier string. Here’s an example:

[enkdb01:root] /root 
> ipmitool sunoem cli 'show /SP system_identifier'
Connected. Use ^D to exit.
-> show /SP system_identifier
 
  /SP
    Properties:
        system_identifier = Sun Oracle Database Machine _YOUR_SERIAL_NUMBER_HERE_
 
 
-> Session closed
Disconnected

Thanks to Dan Norris for that bit of info.

You can also get the individual serial numbers for each component in an Exadata Rack like this:

/opt/oracle.SupportTools/CheckHWnFWProfile -S

So you would log on to each machine and run this. Here’s the output from one of the DB Servers in our system:

 
> /opt/oracle.SupportTools/CheckHWnFWProfile -S
 
====START SERIAL NUMBERS====
==Motherboard, from dmidecode==
--System serial--
1019XF5059            
--Motherboard serial--
0328MSL-10144H0XE2    
--Chassis serial--
1019XF5059            
==Infiniband HCA==
ID: qFalcon QDR
PN: 375-3606-02          
EC: 50
SN: 1388FMH-1005500316      
V0: PCIe Gen2 x8    
==InfiniBand Switch==
 Use the /opt/oracle.SupportTools/CheckSWProfile.sh -S option to get the switch serial numbers
==Disk Controller==
Product Name    : LSI MegaRAID SAS 9261-8i
Serial No       : SV00800405
==Disks==
Enclosure:Slot Type Make Model Serial
252:0 SAS HITACHI H103014SCSUN146G 1017FAJW9E
252:1 SAS HITACHI H103014SCSUN146G 1017FBAY8E
252:2 SAS HITACHI H103014SCSUN146G 1017FAK0BE
252:3 SAS HITACHI H103014SCSUN146G 1017FB8PHE
==Motherboard, RAM etc from ipmitool==
FRU Device Description : Builtin FRU Device (LUN 0, ID 0)
 Product Manufacturer  : SUN MICROSYSTEMS
 Product Name          : ILOM INTEGRATED SP  
 
FRU Device Description : /SYS (LUN 0, ID 3)
 Board Product         : ASSY,MOTHERBOARD,X4170/X4270/X4275  
 Board Serial          : 0328MSL-10144H0XE2
 Board Part Number     : 501-7917-11
 Board Extra           : 54
 Board Extra           : X4170/4270/4275
 Product Manufacturer  : SUN MICROSYSTEMS
 Product Name          : SUN FIRE X4170 SERVER   
 Product Part Number   : 602-4927-02
 Product Serial        : 1019XF5059
 Product Extra         : 080020FFFFFFFFFFFFFF00212883E184
 
FRU Device Description : MB (LUN 0, ID 4)
 Board Product         : ASSY,MOTHERBOARD,X4170/X4270/X4275  
 Board Serial          : 0328MSL-10144H0XE2
 Board Part Number     : 501-7917-11
 Board Extra           : 54
 Board Extra           : X4170/4270/4275
 Product Manufacturer  : SUN MICROSYSTEMS
 Product Name          : SUN FIRE X4170 SERVER   
 Product Part Number   : 602-4927-02
 Product Serial        : 1019XF5059
 Product Extra         : 080020FFFFFFFFFFFFFF00212883E184
 
FRU Device Description : MB/BIOS (LUN 0, ID 5)
 Product Manufacturer  : AMERICAN MEGATRENDS 
 Product Name          : SYSTEM BIOS 
 Product Part Number   : AMIBIOS8
 Product Version       : 07060223
 
FRU Device Description : MB/NET0 (LUN 0, ID 43)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:80
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:80
 
FRU Device Description : mb.net0.fru (LUN 0, ID 43)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:80
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:80
 
FRU Device Description : MB/NET1 (LUN 0, ID 44)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:81
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:81
 
FRU Device Description : mb.net1.fru (LUN 0, ID 44)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:81
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:81
 
FRU Device Description : MB/NET2 (LUN 0, ID 45)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:82
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:82
 
FRU Device Description : mb.net2.fru (LUN 0, ID 45)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:82
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:82
 
FRU Device Description : MB/NET3 (LUN 0, ID 46)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:83
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:83
 
FRU Device Description : mb.net3.fru (LUN 0, ID 46)
 Product Manufacturer  : INTEL   
 Product Name          : GIGABIT ETHERNET CONTROLLERS
 Product Part Number   : 82575EB
 Product Serial        : 00:21:28:83:E1:83
 Product Extra         : 01
 Product Extra         : 00:21:28:83:E1:83
 
FRU Device Description : /UUID (LUN 0, ID 6)
 Product Extra         : 080020FFFFFFFFFFFFFF00212883E184
 
FRU Device Description : SP/NET0 (LUN 0, ID 1)
 Product Manufacturer  : ASPEED  
 Product Name          : ETHERNET CONTROLLER 
 Product Part Number   : AST2100
 Product Serial        : 00:21:28:83:e1:84
 Product Extra         : 01
 Product Extra         : 00:21:28:83:e1:84
 
FRU Device Description : SP/NET1 (LUN 0, ID 2)
 Product Manufacturer  : ASPEED  
 Product Name          : ETHERNET CONTROLLER 
 Product Part Number   : AST2100
 Product Serial        : 00:21:28:83:e1:85
 Product Extra         : 01
 Product Extra         : 00:21:28:83:e1:85
 
FRU Device Description : MB/P0 (LUN 0, ID 16)
 Product Manufacturer  : INTEL   
 Product Name          : INTEL(R) XEON(R) CPU           E5540  @ 2.53GHZ 
 Product Part Number   : 060A
 Product Version       : 05
 
FRU Device Description : MB/P1 (LUN 0, ID 17)
 Product Manufacturer  : INTEL   
 Product Name          : INTEL(R) XEON(R) CPU           E5540  @ 2.53GHZ 
 Product Part Number   : 060A
 Product Version       : 05
 
FRU Device Description : MB/P0/D0 (LUN 0, ID 24)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 1A86965A
 
FRU Device Description : MB/P0/D1 (LUN 0, ID 25)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 04B25956
 
FRU Device Description : MB/P0/D2 (LUN 0, ID 26)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 0462594F
 
FRU Device Description : MB/P0/D3 (LUN 0, ID 27)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 04125951
 
FRU Device Description : MB/P0/D4 (LUN 0, ID 28)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 04525976
 
FRU Device Description : MB/P0/D5 (LUN 0, ID 29)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 04525964
 
FRU Device Description : MB/P0/D6 (LUN 0, ID 30)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 0432597B
 
FRU Device Description : MB/P0/D7 (LUN 0, ID 31)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 0422595A
 
FRU Device Description : MB/P0/D8 (LUN 0, ID 32)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 0432595A
 
FRU Device Description : MB/P1/D0 (LUN 0, ID 33)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 2D634EE4
 
FRU Device Description : MB/P1/D1 (LUN 0, ID 34)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 2DC34EA7
 
FRU Device Description : MB/P1/D2 (LUN 0, ID 35)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 2D234E9F
 
FRU Device Description : MB/P1/D3 (LUN 0, ID 36)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 2D634E94
 
FRU Device Description : MB/P1/D4 (LUN 0, ID 37)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 2D534EE1
 
FRU Device Description : MB/P1/D5 (LUN 0, ID 38)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 2D334EE3
 
FRU Device Description : MB/P1/D6 (LUN 0, ID 39)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 1A76965D
 
FRU Device Description : MB/P1/D7 (LUN 0, ID 40)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 1AB6965B
 
FRU Device Description : MB/P1/D8 (LUN 0, ID 41)
 Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
 Product Name          : 4GB DDR3 SDRAM 666  
 Product Part Number   : HMT151R7BFR4C-H9  
 Product Version       : 4437
 Product Serial        : 04625970
 
FRU Device Description : PCIE1/F20CARD (LUN 0, ID 225)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : PCIE2/F20CARD (LUN 0, ID 226)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : PS0 (LUN 0, ID 63)
 Board Mfg             : EMERSON
 Board Product         : A237
 Board Serial          : 1357ZHO-1012BF1NLY
 Board Part Number     : 300-2143-04
 Power Supply Record
  Capacity                   : 760 W
  Peak VA                    : 880 VA
  Inrush Current             : 25 A
  Inrush Interval            : 200 ms
  Input Voltage Range 1      : 90-264 V
  Input Voltage Range 2      : 0-0 V
  Input Frequency Range      : 47-63 Hz
  A/C Dropout Tolerance      : 12 ms
  Flags                      : 'Predictive fail' 'Power factor correction' 'Hot swap' 'Failure on pin de-assertion'
  Peak capacity              : 760 W
  Peak capacity holdup       : 15 s
  Combined capacity          : not specified
  Fan lower threshold        : 0 RPS
 DC Output Record
  Output Number              : 2
  Standby power              : No
  Nominal voltage            : 12.00 V
  Max negative deviation     : 11.88 V
  Max positive deviation     : 12.12 V
  Ripple and noise pk-pk     : 100 mV
  Minimum current draw       : 0.050 A
  Maximum current draw       : 6.230 A
 DC Output Record
  Output Number              : 2
  Standby power              : Yes
  Nominal voltage            : 3.30 V
  Max negative deviation     : 3.20 V
  Max positive deviation     : 3.40 V
  Ripple and noise pk-pk     : 100 mV
  Minimum current draw       : 0.000 A
  Maximum current draw       : 0.360 A
 
FRU Device Description : PS1 (LUN 0, ID 64)
 Board Mfg             : EMERSON
 Board Product         : A237
 Board Serial          : 1357ZHO-1010BF1LGG
 Board Part Number     : 300-2143-04
 Power Supply Record
  Capacity                   : 760 W
  Peak VA                    : 880 VA
  Inrush Current             : 25 A
  Inrush Interval            : 200 ms
  Input Voltage Range 1      : 90-264 V
  Input Voltage Range 2      : 0-0 V
  Input Frequency Range      : 47-63 Hz
  A/C Dropout Tolerance      : 12 ms
  Flags                      : 'Predictive fail' 'Power factor correction' 'Hot swap' 'Failure on pin de-assertion'
  Peak capacity              : 760 W
  Peak capacity holdup       : 15 s
  Combined capacity          : not specified
  Fan lower threshold        : 0 RPS
 DC Output Record
  Output Number              : 2
  Standby power              : No
  Nominal voltage            : 12.00 V
  Max negative deviation     : 11.88 V
  Max positive deviation     : 12.12 V
  Ripple and noise pk-pk     : 100 mV
  Minimum current draw       : 0.050 A
  Maximum current draw       : 6.230 A
 DC Output Record
  Output Number              : 2
  Standby power              : Yes
  Nominal voltage            : 3.30 V
  Max negative deviation     : 3.20 V
  Max positive deviation     : 3.40 V
  Ripple and noise pk-pk     : 100 mV
  Minimum current draw       : 0.000 A
  Maximum current draw       : 0.360 A
 
FRU Device Description : DBP (LUN 0, ID 210)
 Board Product         : BD,ASY,1U,8DSK BKPL,SATA
 Board Serial          : C00UHC
 Board Part Number     : 511-1283-03
 Board Extra           : 50
 Board Extra           : SASBP
 
FRU Device Description : PDB (LUN 0, ID 211)
 Board Product         : ASY,PDB,H1M1G1  
 Board Serial          : F06TJC
 Board Part Number     : 501-7696-10
 Board Extra           : 50
 Board Extra           : PDB
 Product Part Number   : 602-4927-02
 Product Serial        : 1019XF5059
 
FRU Device Description : PADCRD (LUN 0, ID 222)
 Board Product         : BD,ASY,PADDLE,1U
 Board Serial          : 0226LHF-101000049B
 Board Part Number     : 541-3512-02
 Board Extra           : 51
 Board Extra           : 1U Paddle
 
FRU Device Description : FB0 (LUN 0, ID 212)
 Board Product         : ASY,FAN,BOARD,H1M1G1
 Board Serial          : 0226LHF-1010A402TW
 Board Part Number     : 541-2112-04
 Board Extra           : 52
 Board Extra           : FANBD
 
FRU Device Description : FB1 (LUN 0, ID 213)
 Board Product         : ASY,FAN,BOARD,H1M1G1
 Board Serial          : 0226LHF-1010A402TH
 Board Part Number     : 541-2112-04
 Board Extra           : 52
 Board Extra           : FANBD
 
FRU Device Description : DBP/HDD0 (LUN 0, ID 47)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD1 (LUN 0, ID 48)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD2 (LUN 0, ID 49)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD3 (LUN 0, ID 50)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD4 (LUN 0, ID 51)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD5 (LUN 0, ID 52)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD6 (LUN 0, ID 53)
 Device not present (Requested sensor, data, or record not found)
 
FRU Device Description : DBP/HDD7 (LUN 0, ID 54)
 Device not present (Requested sensor, data, or record not found)
 
====END SERIAL NUMBERS====
 
[enkdb01:root] /root


(UPDATE: the command mentioned by davidr in the comments gives the serial number for the server you are connected to, be it DB or Storage): The command is:

         ipmitool sunoem cli "show /SYS product_serial_number"

VirtualBox 4.0.4 Released…

Oracle VM VirtualBox 4.0.4 has been released, as pointed out here.

Cheers

Tim…

Unlocking Temporary Table Instances from Deleted Process Requests

In a previous blog entry, I discussed how to detect whether an Application Engine process had run out of non-shared Temporary Table instances by querying the message log table for the entries written when this happens.

This can happen because processes that have locked all available non-shared table instances are currently processing. However, if a restartable Application Engine program terminates with an error, the tables remain locked to that process instance so that it can be restarted. If that process instance is neither cancelled nor restarted so that it subsequently runs to success then the tables will remain locked, and in time the Process Scheduler archive process may purge the process request record.