dianarobete

So You Think You Can Gather Stats?

By dianarobete December 6, 2017 Off

I have covered lots of topics on Oracle Optimizer Statistics. I’d like to summarize everything you learned, or reviewed in… Continue Reading

By dianarobete November 29, 2017 Off

Imagine this. You get a call. A specific SQL statement is running slow today, and the statement was running fine… Continue Reading

By dianarobete November 22, 2017 Off

By default, whenever new statistics are gathered in the database, the existing statistics are backed up in the data dictionary.… Continue Reading

By dianarobete November 15, 2017 Off

How do you gather statistics in your database? Do you gather statistics randomly when you remember, or do you gather… Continue Reading

By dianarobete November 8, 2017 Off

Do you gather statistics regularly for your databases? Do you gather statistics explicitly, with your own script, or do you… Continue Reading

By dianarobete October 25, 2017 Off

You keep hearing that statistics are important for the Oracle database. You keep hearing that you should collect statistics. A… Continue Reading

By dianarobete October 11, 2017 Off

Do you find yourself searching on Google for ways to connect to 12c database, especially PDBs? Do you feel frustrated,… Continue Reading

By dianarobete October 4, 2017 Off

Do you want to write some kick ass reports? Convert some rows into lines very quickly and easily? or Do… Continue Reading

By dianarobete September 27, 2017 Off

Last two weeks, we covered the building blocks of SQL Plan Management, and then we got started with SQL Plan… Continue Reading

By dianarobete September 20, 2017 Off

If you wonder how SQL Plan Baselines work, then this post is for you! If you want to get started… Continue Reading