DB Startup Founder

Friday, March 4, 2011

tidbit:Oracle:ITL Deadlock troubleshooting and analysis

How to identify ITL deadlock:

1. Pick slot number (0x40021) at the top

2. Search for it in a deadlock trace file

3. See if wait event is ITL related.

Resolution: Increase INI_TRANS on table or on index.

---------Blocker(s)-------- ---------Waiter(s)---------

Resource Name process session holds waits process session holds waits

TX-00040021-00001409 66 2515 X 65 1253 S

TX-0005001b-000014d8 65 1253 X 66 2515 S

Dumping one waiter:

inst: 1, sid: 2513, ser: 41

wait event: 'enq: TX - allocate ITL entry'

p1: 'name|mode'=0x54580004

p2: 'usn<<16 | slot'=0x40021

p3: 'sequence'=0x1409

row_wait_obj#: 4294967295, block#: 0, row#: 0, file# 0

min_blocked_time: 0 secs, waiter_cache_ver: 31817

Sunday, February 20, 2011

Books:Book about Oracle Founder Larry Ellison

This book absolutely must read! If you are DBA or start up founder - this book opens really shocking insight how business was and is made in Silicon Valley.

Have you knew that Larry Ellison was not employee #1 of Oracle?

Have you knew that Oracle put on IPO papers that it has mainframe solution while it was not even functional?

Have you knew how exectly Oracle crush the competitors and grew sales?

Read the book!

Tidbit:Oracle:Exadata:Flash Disks Information

Use below commands to get information on Exadata Cell Flash Disks

CellCLI> list celldisk where diskType = FlashDisk

         FD_00_cell      normal
         FD_01_cell      normal
         FD_02_cell      normal
         FD_03_cell      normal

CellCLI> list celldisk where diskType = FlashDisk DETAIL

         name:                   FD_00_cell
         comment:
         creationTime:           2010-10-21T14:52:28-07:00
         deviceName:             /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH01
         devicePartition:        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH01
         diskType:               FlashDisk
         errorCount:             0
         freeSpace:              0
         id:                     0000012b-d0c7-42f2-0000-000000000000
         interleaving:           none
         lun:                    /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH01
         raidLevel:              "RAID 0"
         size:                   496M
         status:                 normal

         name:                   FD_01_cell
         comment:
         creationTime:           2010-10-21T14:52:30-07:00
         deviceName:             /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH02
         devicePartition:        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH02
         diskType:               FlashDisk
         errorCount:             0
         freeSpace:              0
         id:                     0000012b-d0c7-61d3-0000-000000000000
         interleaving:           none
         lun:                    /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH02
         raidLevel:              "RAID 0"
         size:                   496M
         status:                 normal

         name:                   FD_02_cell
         comment:
         creationTime:           2010-10-21T14:52:31-07:00
         deviceName:             /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH03
         devicePartition:        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH03
         diskType:               FlashDisk
         errorCount:             0
         freeSpace:              0
         id:                     0000012b-d0c7-695e-0000-000000000000
         interleaving:           none
         lun:                    /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH03
         raidLevel:              "RAID 0"
         size:                   496M
         status:                 normal

         name:                   FD_03_cell
         comment:
         creationTime:           2010-10-21T14:52:32-07:00
         deviceName:             /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH04
         devicePartition:        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH04
         diskType:               FlashDisk
         errorCount:             0
         freeSpace:              0
         id:                     0000012b-d0c7-6cdc-0000-000000000000
         interleaving:           none
         lun:                    /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH04
         raidLevel:              "RAID 0"
         size:                   496M
         status:                 normal

Saturday, February 19, 2011

blog:design:monetization

Nice article on blog monetization:

http://www.infobarrel.com/Blogger_Template_Design_For_Monetization

And this one on ad's placement:

http://www.buzzle.com/articles/maximize-your-advertising-revenue-with-your-blog.html

Thursday, February 17, 2011

Books: Exadata Books Coming!

Looks like couple oracle exadata books are in cooking already!

Achieving Extreme Performance with Oracle Exadata (Osborne ORACLE Press Series)

Expert Oracle Exadata