Profile cover photo
Profile photo
Maria Colgan (SQLMaria)
931 followers -
Revolutionize Data Management by Adopting Transformational Technologies
Revolutionize Data Management by Adopting Transformational Technologies

931 followers
About
Posts

Post has attachment
Automatic Collection of Fixed Objects Statistics in 12c #12c #optimizer #statistics

In my previous life as the Optimizer Lady, I wrote a blog on the importance of gathering fixed object statistics, since they were not originally gathered as part of the automatic statistics gather task. Starting with Oracle Database 12c Release 1,…
Add a comment...

Post has attachment
Should I gather System Statistics? #optimizer #statistics #systemstatistics

While at the HotSOS Symposium, last month, I caused quite a stir when I recommended that folks should never gather system statistics. Why such a stir? It turns out this goes against what we recommend in the Oracle SQL Tuning Guide, which says “Oracle…
Add a comment...

Post has attachment
Oracle RAC now available on Docker! #Docker #OracleDatabase12c #RAC

I began my love affair with Docker a year ago when @GeraldVenzl got me started with my very first 12.2 Multitenant container database on Docker and I have to say I absolutely love the convenience of having an Oracle Database directly on my MAC for demos…
Add a comment...

Post has attachment
How to determine which view to use #DBMS_UTILITY #OracleDatabase12c #PLSQL #SQLDev

Often times DBAs or application architects create views to conceal complex joins or aggregations in order to help simplify the SQL queries developers need to write.  However, as an application evolves, and the number of views grow, it can often be…
Add a comment...

Post has attachment
Can GPUs speed up Database workloads? #Analytics #CPU #GPU #SIMD

Recently there has been a lot of interest or hope that Graphics processing units or GPUs would be able to transparently accelerate database workloads. So, I thought it was worth investigating what Oracle is up to regarding getting transparent performance…
Add a comment...

Post has attachment
Oracle OpenWorld 2018 Call for Papers is Open! #OOW

Believe it or not, it’s time to start thinking about Oracle OpenWorld 2018! The Oracle OpenWorld 2018 call for papers is now opens! Oracle customers and partners are encouraged to submit proposals to present at this year’s Oracle OpenWorld conference,…
Add a comment...

Post has attachment
Oracle Database 18c Released #18c #Database

Today Oracle officially released Oracle Database 18c on the Oracle Public Cloud and Oracle Engineered Systems. This is the first version of the database to follow the new yearly release model and you can find more details on the release model change in…
Add a comment...

Post has attachment
SQL Plan Management – Selective Automatic Plan Capture Now Available! #12c #ExecutionPlans #optimizer #PlanStability

Over the years, Oracle has provided a number of techniques to help you control the execution plan for a SQL statement, such as Store Outlines and SQL Profiles but for me the only feature to truly give you plan stability is SQL Plan Management (SPM). It’s…
Add a comment...

Post has attachment
Does the Explain Plan command really show the execution plan that will be used? #beginners #ExecutionPlans #optimizer

When it comes to SQL tuning we often need to look at the execution plan for a SQL statement to determine where the majority of the time is spent. But how we generate that execution plan can have a big impact on whether or not the plan we are looking at is…
Add a comment...

Post has attachment
Oracle Autonomous Database #Autonomous #DBA #OOW

At OpenWorld, Larry Ellison announced  an Autonomous Database cloud (service), which is self-driving, self-securing, and self-repairing. Although there was a lot of excitement surrounding the announcement, there were also a lot of questions. How does it…
Add a comment...
Wait while more posts are being loaded