This page lists my Exadata related postings. I’m a certified Oracle Exadata Database Machine X3 Administrator
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
LunchTimeLVC (Smart Scan – What is so smart about it)
Accelerated space reclamation on Exadata Cells
Exadata Smart Scan Introduction – recorded Webinar
Appliance? How #Exadata will impact your IT Organization
Oracle University Training:
Exadata and Database Machine Administration Workshop
Exadata Learning Paths for various Job Roles
Google by Uwe Hesse
#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.
#12 by Satya on June 19, 2012 - 15:32
Hi Uwe,
Thanks for sharing the knowledge…
-Cheers,
Satya,
http://satya-exadata.blogspot.com/2011/07/cellclicommandsexadata.html
#13 by raj on June 22, 2012 - 13:47
Hi ,
Can i have the syntax of user creation in exadata machine
#14 by robin chatterjee on June 22, 2012 - 19:23
standard oel commands such as useradd work….
#15 by raj on June 23, 2012 - 05:03
1)for example…the user creation will be as…create user username identified by password .Am i rite?
2)Could you please list down the administartion tasks that is to be carried from dba perspective in exadata machine apart from normal oracle db activities
#16 by Uwe Hesse on June 23, 2012 - 17:01
The DBA tasks on an Exadata Database Node are the very same as on other Linux platforms. Especially the Database Layer is identically as on other Platforms – it is an ordinary Oracle Database 11.2.0.3
There are some special tasks on the Exadata Storage Server Layer – the question is whether DBAs or SysAdmins /Storage Admins are supposed to do that on your site
#17 by robin chatterjee on June 23, 2012 - 19:37
Not sure what you mean by adding a user to the Exadata machine… If you need to add a user to a specific instance you would use the standard oracle db commands for that instance/database. If you need to add a user to the compute nodes you need to use Oracle Enterprise Linux standard commands. I do not consider creation of a user in a Database to be Exadata specific. If you are just a DBA on Exadata then who does the sysadmin tasks ? I would suggest your looking into the book “Expert Oracle Exadata” to get a good feel of all the aspects specific to Exadata. If you are so inclined there is no reason why you cannot learn the Delta tasks necessary to take complete care of an Exadata machine.
Thanks
#18 by Jesmond on October 24, 2012 - 21:13
With reference to Oracle VM on Exadata, is this available, or are there any plans to release oracle VM on Exadata?
#19 by Rajesh GN on November 21, 2012 - 17:12
Hi ,
Could you please explain me the oracle private cloud that what is it? Does it steal my job?
Many Thanks
Rajesh GN