24Jan/18

What Is The Relationship Between SCNs and DB Links?

January 24, 2018Database, Oracle, Oracledatabase link, DBA, Oracle, SCNdianarobete

Have you ever checked the value of the SCN number – System Change Number in your databases? Were you surprised to find out that some databases had very close SCN numbers? TheRead More…

17Jan/18

3 Things You Wish You’ve Learned In School About Oracle’s SCN

January 17, 2018Database, Oracle, OracleOracle, SCNdianarobete

There are things you don’t learn in school. There are things you hear about in school, that are not explored in-depth. There are things you learn in school and then you forgetRead More…

10Jan/18

What Skills Are You Going To Master in 2018?

January 10, 2018Oracle, Personal Growth2018, awesome year, goals, questions, skills to masterdianarobete

We are two weeks into 2018. Most likely you are back to work, in full force, ready to fight the new fires! Are you ready for an AWESOME year, full of challenges,Read More…

06Dec/17

So You Think You Can Gather Stats?

December 6, 2017Database, Oracle, OracleDBA, gather stats, Oracledianarobete

I have covered lots of topics on Oracle Optimizer Statistics. I’d like to summarize everything you learned, or reviewed in the past month with me. I love quick summaries that give youRead More…

29Nov/17

How To Compare Current Stats With Stats From History?

November 29, 2017Database, Oracle, Oraclecompare stats, dbms_stats, diff_table_stats_in_historydianarobete

Imagine this. You get a call. A specific SQL statement is running slow today, and the statement was running fine yesterday. You quickly review the SQL statement, apply the steps from myRead More…

22Nov/17

4 Things To Know About Statistics History

November 22, 2017Database, Oracle, Oracledbms_stats, Oracle, statistics historydianarobete

By default, whenever new statistics are gathered in the database, the existing statistics are backed up in the data dictionary. The statistics backups are stored in the SYSAUX tablespace, in the WRI$_OPTSTAT%HISTORYRead More…

15Nov/17

What Type Of Stats To Gather (Bonus Script)

November 15, 2017Database, Oracle, Oracledatabase statistics, dbms_stats, optimizer statisticsdianarobete

How do you gather statistics in your database? Do you gather statistics randomly when you remember, or do you gather statistics when there is a problem? Or Do you gather statistics onRead More…

08Nov/17

How Are Statistics Gathered In The Database?

November 8, 2017Database, Oracle, Oracleauto optimizer stats collection, database statistics, dba_autotask_task, dbms_stats, empty stats, stale statsdianarobete

Do you gather statistics regularly for your databases? Do you gather statistics explicitly, with your own script, or do you let the default job gather statistics? Are you aware that such aRead More…

25Oct/17

3 Things You Must Know About Oracle Optimizer Statistics

October 25, 2017Database, Oracle, OracleColumn Stats, DBA, Index Stats, Optimizer Stats, Oracle, Table Statsdianarobete

You keep hearing that statistics are important for the Oracle database. You keep hearing that you should collect statistics. A DBA tells you that you should gather incremental stats and extended stats.Read More…

11Oct/17

How To Connect To 12c Databases

October 11, 2017Database, OracleCDB, connect 12c, database, multitenant, Oracle, PDBdianarobete

Do you find yourself searching on Google for ways to connect to 12c database, especially PDBs? Do you feel frustrated, that you keep forgetting the views for PDB names? Do you wonderRead More…