Biju

www.bijoos.com

DBA_TAB_COLUMNS vs DBA_TAB_COLS

by

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?

by

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