Author Profile

Maria Colgan

Master Product Manager

Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria’s core responsibility is creating material and lectures on the Oracle Database and the best practices for incorporating it into your environments. She is also responsible for getting the feedback from our customers and partners incorporated into future releases of the product
Prior to this role; she was the product manager for Oracle Database In-Memory and the Oracle Database query optimizer. Maria is the primary author of the SQLMaria blog https://sqlmaria.com and a contributing author to the Oracle Optimizer blog http://blogs.oracle.com/optimizer

Wednesday, February 28, 2018 Maria Colgan

Does GPU hardware help Database workloads?

Graphics processing units or GPUs are dedicated highly parallel hardware accelerators that were originally design to accelerate the creation of images. More...

Tuesday, August 22, 2017 Maria Colgan

How to control where objects are populated into memory on RAC

If you recall from part 1 of our blog series on RAC each RAC node has it’s own In-Memory column store (IM column store). When a table is populated into memory...

Friday, August 19, 2016 Maria Colgan

Time to start planning for Oracle Open World 2016

There is less than 6 weeks to go until Oracle Open World, the largest gathering of Oracle customers, partners, developers, andtechnology enthusiasts, which...

Friday, July 1, 2016 Maria Colgan

Questions You Asked: Where did the other bloom filter go?

A couple of weeks ago at the Spring Conference of the Bulgarian Oracle User Group, Joel Goodman gave a great session on Bloom Filters and how the can improve...

Monday, April 18, 2016 Maria Colgan

Why does BYTES_NOT_POPULATED suddenly show a non-zero value?

I recently got a question from a customer who has just begun adopting Database In-Memory and thought it was worth answering as a blog post in case anyone else...

Tuesday, April 12, 2016 Maria Colgan

Oracle OpenWorld 2016 call for papers has begun!

Believe it or not, it's time to start thinking about Oracle OpenWorld 2016! The Oracle OpenWorld 2016 call for papers is now opens! Oracle customers and...

Friday, March 25, 2016 Maria Colgan

Why didn't Database In-Memory improve the performance of my query?

After I posted last weeks blog post on identifying analytic queries that benefit from Database In-Memory, I got the following question, Why didn't...

Friday, March 18, 2016 Maria Colgan

How do I identify analytic queries that will benefit from Database In-Memory?

Although Database In-Memory can be used in both Enterprise OLTP systems and Data Warehouses, only analytic queries will benefit from accessing data from the...

Friday, February 12, 2016 Maria Colgan

How do I limit the amount of memory each PDB can use in the IM column store?

In case you aren’t familiar with what a PDB is, let me begin by explaining what a Multitenant environment is and how PDBs fit into it. Oracle Multitenant is a...