Oracle – Page 10 – DBA Paradise

Intro To Execution Plans

By dianarobete April 4, 2018 Off

When there is a performance problem in the database, what is the most important thing that you need to know?… Continue Reading

By dianarobete March 14, 2018 Off

Last week we looked at SQL Plan Directives, what they are, when do they get created, how they are used… Continue Reading

By dianarobete March 7, 2018 Off

If you ever looked at an execution plan in Oracle 12c, most likely you noticed the following line, at the… Continue Reading

By dianarobete February 7, 2018 Off

I don’t like clutter, whether it is in my home or database. So when a project manager (PM) came to… Continue Reading

By dianarobete January 24, 2018 Off

Have you ever checked the value of the SCN number – System Change Number in your databases? Were you surprised… Continue Reading

By dianarobete January 17, 2018 Off

There are things you don’t learn in school. There are things you hear about in school, that are not explored… Continue Reading

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 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 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