Skip to Main Content
  • Questions
  • Advantages of Exadata for a PL/SQL developer.

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Rupak.

Asked: August 17, 2017 - 4:18 am UTC

Last updated: August 18, 2017 - 12:26 pm UTC

Version: Oracle 11g/12c, Exadata 2

Viewed 1000+ times

You Asked

I'm a PlSql developer currently working on Oracle 12c with Exadata. I came across some of the advantages of exadata as like flash cache and Storage Indexes. However it seems all these concepts are DBA related. Do we have any changes or advantages for PlSql developers(OLAP environment). Is there any place for a developer like me to get the concepts of exadata to use in day to day programming use.

and Connor said...

"Do we have any changes ... for PlSql developers(OLAP environment)"

Not really. That is one of the goals of Exadata - that whatever you have done in the past, continues to work in the same way or better.

You're right that most of the *internals* concerns DBA's but there are benefits for the developer in having a knowledge of those parts of Exadata that pertain to running queries faster, especially analytical or OLAP style queries.

The book below is more of a DBA's resource

http://www.apress.com/us/book/9781430262411

but still there is some great content there in the first couple of hundred pages on the elements that concern developers most, namely, getting the most out of Exadata from a query performance perspective. It provides mainly a good understanding of perhaps re-framing your mindset in terms of getting good performance from queries, namely, its not *always* about indexes.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

hum

A reader, August 18, 2017 - 5:21 am UTC

Not easy to answer such question by y/n
If your are developper you may or may not tune sql queries. Exadata provide different exec plans
So yes developper is concerned by Exadata
Connor McDonald
August 18, 2017 - 12:26 pm UTC

"If your are developper you may or may not tune sql queries"


If you're a developer I certainly *hope* you are tuning queries