Exadata

This page lists my Exadata related postings. I’m a certified Oracle Exadata Database Machine X3 Administrator

OCE Exadata Database Machine Administrator

Exadata Part I: Smart Scan

Exadata Part II: Storage Index

Exadata Part III: Compression

Exadata Part IV: Flash Cache

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

Invisible Indexes & Exadata

Exadata Part VII: Meaning of the various Disk Layers

Important Statistics & Wait Events on Exadata

Replacing a damaged Hard Disk on Exadata Cells

DBMS_COMPRESSION Example

Exadata Quarter Rack Architecture Picture

LunchTimeLVC (Smart Scan – What is so smart about it)

Accelerated space reclamation on Exadata Cells

Exadata X3 Key Points

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


Picture of an Exadata X3-2 Full Rack and descriptionPicture of an Exadata X3-2 Storage Server and its internal components

Google by Uwe Hesse

About these ads
  1. #1 by Eric Y on July 23, 2011 - 04:21

    Thank you for sharing your knowledge and helping everybody get better at Exadata.

  2. #2 by Uwe Hesse on July 29, 2011 - 16:18

    You’re welcome, Eric :-)

  3. #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. #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. #5 by Andrés on September 2, 2011 - 00:10

    Hi, for Oracle employees still this Vm restricted?

  6. #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. #7 by Andrés on September 2, 2011 - 21:50

    Hi Uwe, i already send you the email.

    regards,

    Andrés

  8. #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. #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. #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. #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. #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. #13 by raj on June 22, 2012 - 13:47

    Hi ,

    Can i have the syntax of user creation in exadata machine

  14. #14 by robin chatterjee on June 22, 2012 - 19:23

    standard oel commands such as useradd work….

  15. #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. #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. #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. #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. #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

  20. #20 by A K on September 17, 2013 - 07:18

    HI,

    If I have enabled the compression then if any new data will come that automatically will compressed or we have to do something.

    Thanks,
    A K

    http://exadatacertification.blogspot.com/

  21. #21 by Uwe Hesse on September 17, 2013 - 15:34

    It depends on the compression type. With OLTP compression, simple inserts will go optimally compressed. With basic or HCC compression, you need the /*+ append */ hint to get the best compression ratio.

  22. #22 by Mark on November 26, 2013 - 03:00

    Hello Uwe,

    I have been asked to work with an engineering team to design Disaster Recovery and COOP sites.

    Goal: Maximize data through put.
    Environment: several exadata with massive SL6000 tape libraray and massive SAN storage at all sites.

    Question: Can you point me to Oracle or EMC references?
    Mark

  23. #23 by dbaesp on January 18, 2014 - 14:20

    Hi Uwe,
    you cannot share the Exadata VM of Oracle Education, but can I build my virtual exadata test environment for OCE prep ?
    Actually I already did that (waiting for the real Exadata that will be up&running on February), but if needed I’ll erase all the VMs.
    Could you eventually guide me to the official Oracle view on this question ?
    Thanks
    Eugenio /*+ esp */

  24. #24 by Uwe Hesse on January 25, 2014 - 21:04

    Eugenio, I think the official view on this topic is that the Exadata (Storage Server) Software is allowed to use only on Oracle Exadata Database Machine.

  25. #25 by dbaesp on January 26, 2014 - 10:19

    Thanks Uwe.

  26. #26 by karthik on January 29, 2014 - 16:30

    Hello Uwe,

    Can you send me the Oracle Intranet link to download the Exadata vm.

    -Thanks
    Karthik

  27. #27 by Exadata on March 5, 2014 - 15:29

    Which is the best strategy to do compression on OLTP and DW?

    exadatacertification.blogspot.com

  28. #28 by Carlos Anibal Amaral de Carvalho on March 28, 2014 - 03:57

    Hi Uwe,

    Just a quick question, as we are now on Exadata X4 family, what will happen to the 1Z0-027 Certification? Will Oracle provides an Exadata Machine Administrator X4 too?

    Thanks.
    Carlos

  29. #29 by Edgardo on April 15, 2014 - 21:57

    Hi,
    Oracle Certification: This exam, Oracle Exadata X3 Administration, has been updated for Oracle Exadata X4.

    Now: Oracle Exadata X3 and X4 Administration
    Exam Number: 1Z0-027
    Exam Product Version: Exadata,
    Exam Price: US$ 245 More on exam pricing

    Duration: 150 minutes
    Number of Questions: 90
    Passing Score: 60% View passing score policy
    Validated Against:
    This exam has been validated against Oracle Database 11g, Oracle Database 12c, Exadata Database Machine X3 and X4, and cell images 11.2.3.2.0, 11.2.3.3.0 and 12.1.1.1.0.
    format: Multiple Choice

    Edgardo C.

  30. #30 by Venkat on July 13, 2014 - 19:28

    Hello,

    Can you please share Exadata vm, I am just having little knowledge and i want learn more about the Exadata .

    Thanks you very much for sharing.

  31. #31 by Unnat on July 29, 2014 - 08:48

    Hi Uwe,

    I am interested in learning Exadata. is it possible that I can get Exadata machine/vm access ? Please provide if there is any.

    Regards,

    Unnat

  32. #32 by Uwe Hesse on July 31, 2014 - 08:46

    Guys, unless you are Oracle employees, I cannot help you with that, because we are not allowed to give our Exadata VM to externs. Sorry about that!

  1. Top 10 postings in 2012 « The Oracle Instructor

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 2,683 other followers

%d bloggers like this: