Database – Page 15 – DBA Paradise

What Type Of Stats To Gather (Bonus Script)

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

By dianarobete September 14, 2017 Off

Ever found yourself in a situation when you had to pretend you understand and know everything that is going on… Continue Reading

By dianarobete August 30, 2017 Off

What happens when things change and all of a sudden don’t work the same as they used to? Do you… Continue Reading

By dianarobete August 23, 2017 Off

Previous post I introduced you to Selectivity and Cardinality, and asked a question at the end. Thanks to all the… Continue Reading