To keep an overview about my Exadata related postings
Exadata Part II: Storage Index
Exadata Part V: Monitoring with Database Control
Exadata Part VI: Cell Administration with dcli
CELL_PARTITION_LARGE_EXTENTS now obsolete
No DISK_REPAIR_TIME on Exadata Cells
Exadata Part VII: Meaning of the various Disk Layers
Important Statistics & Wait Events on Exadata
Replacing a damaged Hard Disk on Exadata Cells
Exadata Quarter Rack Architecture Picture
Oracle University Training:
Exadata and Database Machine Administration Workshop
#1 by Eric Y on July 23, 2011 - 04:21
Thank you for sharing your knowledge and helping everybody get better at Exadata.
#2 by Uwe Hesse on July 29, 2011 - 16:18
You’re welcome, Eric
#3 by Andrés on August 30, 2011 - 23:18
HI,
Is there anyway to install exadata on VM, i just want to learn and improve on it?.
What do u recommend me to learn exadata.
ty,
Andrés
#4 by Uwe Hesse on September 1, 2011 - 18:33
Andrés,
we have indeed an Exadata VM, but it is restricted for internal use only at this time, sorry.
Learning Exadata: Additionally to the OU class
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D67016GC20
there are some good sources in the web. Look at my LINKS list on the right, for example.
Look at Jonathan Lewis’ collection of Exadata Links here:
http://jonathanlewis.wordpress.com/?s=exadata
#5 by Andrés on September 2, 2011 - 00:10
Hi, for Oracle employees still this Vm restricted?
#6 by Uwe Hesse on September 2, 2011 - 02:48
No. If you are an Intern, write me an email and I give you the intranet-link where to download it.
#7 by Andrés on September 2, 2011 - 21:50
Hi Uwe, i already send you the email.
regards,
Andrés
#8 by alexandruneda on February 24, 2012 - 20:31
You made Exadata too simple for us!
Thanks for having this course in Bucharest and keep this blog going because it’s very useful!
#9 by Uwe Hesse on February 27, 2012 - 15:38
Thank you, Alexandru, for the nice feedback and the good company during the last week! It was a pleasure for me to deliver that course
#10 by robin chatterjee on February 28, 2012 - 11:12
Hi uwe,
I am trying to figure out how updates to HCC compressed data work. I assume that the whole cu is locked,the required row is marekd as deleted from the cu and then a normal block with the updated row is added to the table ?
otherwise if the whole cu has to be decompressed and recompressed then there wouln’t be a need to reorganise the hcc tables periodically in order to fix this issue. is there any way to empirically test this ( maybe by using rowids ?)
Thanks
#11 by Uwe Hesse on February 28, 2012 - 12:01
Hi Robin, indeed, during an update of a row inside a HCC compressed table, the whole Compression Unit (CU) is locked and the row will be migrated outside of that CU into a Block with OLTP compression. It is therefore not recommended to use HCC for tables that will get many updates.