DBA – Page 7 – DBA Paradise

What Can You Use DBMS_UTILITY.EXPAND_SQL_TEXT For?

By dianarobete October 3, 2018 Off

Have you ever worked through a tuning exercise (I’d like to call them exercises instead of problems), where the SQL… Continue Reading

By dianarobete September 26, 2018 Off

Last week I asked the question: “What do you do with the AWR data?” Here are some of the responses… Continue Reading

By dianarobete September 19, 2018 Off

How do you use your AWR data or Statspack data? Do you retain it longer than the default retention? Do… Continue Reading

By dianarobete September 5, 2018 Off

While investigating a performance problem, have you ever wondered why a parent cursor has many child cursors associated with it?… Continue Reading

By dianarobete April 11, 2018 Off

Ever wondered how to display the execution plan of a SQL Statement quickly? Are you dreading the question “What is… 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 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 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 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