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

933 followers
About
Posts

Post has attachment
JEFF Talks From Kscope18 #events #presentations #syntax #top_tip

The first day of the ODTUG Kscope conference is always symposium Sunday. This year’s Database symposium, organized by @ThatJeffSmith, consisted of multiple, short, rapid  sessions, covering a wide variety of database and database tool topics, similar to…
Add a comment...

Post has attachment
Avoiding reparsing SQL queries due to partition level DDLs - Part 2 #IoT #Partitioning #top_tip

In my pervious post, I promised to provide an alternative solution to avoiding repasing SQL queries due to partition level DDLs. So, what is it? In Oracle Database 18c we implementing a fine-grained cursor invalidation mechanism, so that cursors can…
Add a comment...

Post has attachment
Avoiding reparsing SQL queries due to partition level DDLs - Part 1 #IoT #Partitioning #top_tip

A couple of weeks ago, I published a blog post that said specifying a partition name in the FROM clause of a query would prevent an existing cursor from being hard parsed when a partition is dropped from the same table. This was not correct. It’s actually…
Add a comment...

Post has attachment
Avoid reparsing SQL queries due to partition level DDLs #IoT #Partitioning #top_tip

When you have a busy transaction processing system one of the things you try to avoid most is parsing, as it is a resource intensive and time consuming process. There are tons of tips on what you can do it avoid parsing from using bind variables, to…
Add a comment...

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...
Wait while more posts are being loaded