Oracle Tidbits – September 2014

“Oracle *daily* TidBits” published at https://www.facebook.com/oraclenotes on all weekdays in September 2014. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… Publish Date TidBit 3-Sep In … Read more

Oracle Tidbits – August 2014

“Oracle *daily* TidBits” published at https://www.facebook.com/oraclenotes on all weekdays in August 2014. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… Date TidBit 1-Aug X$NULL is … Read more

Oracle TidBits – July 2014

“Oracle *daily* TidBits” published at https://www.facebook.com/oraclenotes on all weekdays in July 2014. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use…   Publish Date TidBit … Read more

Oracle Tidbits – June 2014

“Oracle *daily* TidBits” published at https://www.facebook.com/oraclenotes on all weekdays in June 2014. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… TidBit Topic In Oracle Database 12c, the Pre-Upgrade Information Tool script is preupgrd.sql (meaningfully named). Earlier release pre-upgrade tool script is named utluNNNi.sql, … Read more

DBA_TAB_COLUMNS vs DBA_TAB_COLS

Not sure how many DBAs have noticed the difference between DBA_TAB_COLUMNS view and DBA_TAB_COLS view. Both views look pretty identical, if you are not paying too much attention. According to Oracle documentation, DBA_TAB_COLS describes the columns of all tables, views, and clusters in the database. This view differs from “DBA_TAB_COLUMNS” in that system-generated hidden columns … Read more

Is Oracle Enterprise Manager (OEM) Free?

I am pretty sure most DBAs and Architects get this question very often. The information is available in the Oracle Enterprise Manager (OEM) documentation, this is a compilation I thought of sharing, might benefit someone out there without spending too much time searching. When someone says OEM, it could be OEM that comes with database (called … Read more

OracleNotes TidBits – May 2014

According to the dictionary, meaning of “tidbit” is “a small and particularly interesting item of gossip or information“… hope you find the “Oracle TidBits” published at https://www.facebook.com/oraclenotes interesting… Here is a compilation of the tidbits published in May 2014. You will also see these tidbits, one tidbit at a time, for each page refresh on the … Read more

Two Cool Utilities in DBMS_UTILITY

Oracle Database DBMS_UTILITY package has several useful subprograms. GET_DEPENDENCY shows the objects depended on the object. Here is an example (the procedure uses DBMS_OUTPUT to show the result, hence SET SERVEROUTPUT is required in SQL*Plus): SQL> set serveroutput on SQL> exec dbms_utility.get_dependency(‘VIEW’,’HR’,’EMP_DETAILS_VIEW’); – DEPENDENCIES ON HR.EMP_DETAILS_VIEW —————————————————————— *VIEW HR.EMP_DETAILS_VIEW() PL/SQL procedure successfully completed. SQL> exec … Read more