Oracle – Page 11 – DBA Paradise

4 Things To Know About Statistics History

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

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

By dianarobete August 3, 2017 Off

The last two weeks I’ve been talking about the Central Oracle Inventory and the Local Oracle Inventory. I have mentioned… Continue Reading

By dianarobete July 26, 2017 Off

Most DBAs have heard of the Central Oracle Inventory, even if they don’t know details about it. But, have you… Continue Reading

By dianarobete July 12, 2017 Off

You understand what the Fast Recovery Area aka FRA is, what files are stored there and how to enable it.… Continue Reading

By dianarobete June 28, 2017 Off

Is it Flash Recovery Area or Fast Recovery Area? Well, you are not wrong calling it either or, but better… Continue Reading

By dianarobete May 24, 2017 Off

What? Another tool? Yes! And this one is your friend! Do you know why? Because it makes your job easier!… Continue Reading