Follow me on Twitter
My Tweets-
Recent Posts
Search Posts
Comonly used Tags
- 12c
- 18c
- Analytics
- Audio
- Autonomous
- beginners
- Big Data
- birthday
- CPU
- cursor_sharing
- Database
- DBA
- DBMS_XPLAN
- Docker
- events
- Exadata
- Execution Plans
- Github
- GPU
- Hints
- histograms
- In-Memory
- IoT
- JSON
- Multitenant
- My_Activities
- OOW
- optimizer
- Oracle
- Oracle Database 12c
- Partitioning
- Performance
- Plan Stability
- REST
- Security
- Sharding
- SIMD
- SPM
- SQL Monitor
- statistics
- syntax
- top_tip
- UKOUG
- Usergroup
- video
Categories
- AskTom (5)
- Autonomous Database (1)
- Beginners (2)
- Database In-Memory (4)
- Docker (3)
- Events (10)
- Exadata (1)
- GPUs (1)
- IoT (1)
- Multitenant (2)
- New Features (4)
- OOW (9)
- Optimizer (12)
- Oracle Database 12c New Features (18)
- Oracle Database 18c (1)
- Partititoning (1)
- RAC (1)
- Sharding (1)
- SQL Plan Management (1)
- SQLDev (1)
- Statistics (3)
- Syntax (4)
- technical_papers (2)
- Uncategorized (2)
- Whitepapers (2)
Author Archives: Maria Colgan
Automatic Collection of Fixed Objects Statistics in 12c
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 … Continue reading
Should you gather System Statistics?
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 … Continue reading
Oracle RAC now available on Docker!
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 … Continue reading
How to determine which view to use
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 … Continue reading
Posted in Beginners, New Features, Oracle Database 12c New Features, SQLDev
Tagged DBMS_UTILITY, Oracle Database 12c, PLSQL, SQLDev
5 Comments
Can GPUs speed up Database workloads?
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 … Continue reading
Oracle OpenWorld 2018 Call for papers is open!
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, … Continue reading
Oracle Database 18c Released
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 … Continue reading
SQL Plan Management – Selective Automatic Plan Capture Now Available!
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 … Continue reading
Posted in Optimizer, Oracle Database 12c New Features, SQL Plan Management, Uncategorized
Tagged 12c, Execution Plans, optimizer, Plan Stability, SPM
Leave a comment
Does the Explain Plan command really show the execution plan that will be used?
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 … Continue reading
Posted in Beginners, Optimizer
Tagged beginners, cursor_sharing, Execution Plans, optimizer
1 Comment
Oracle Autonomous Database – What you need to know
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. Is Oracle Database 18c the Autonomous Database? How … Continue reading