DBA Catalog

Here I'll show you how to calculate blob, clob columns sizes in tables. 1) Find the size of individual rows with the CLOB/BLOB column. ...

In this blog post I will show you how to change initrans on table in Oracle Database without recreate table, for tuning enq: TX – allocate I...

Here I'll show you how to use vi editor in SQL PLUS, It is very easy and comfortable when working with SQLPLUS and writing scripts. vi ...

Here I'll show you how to configure system for automatically start oracle database after server reboot. oracle database 11g --- Oracle ...

Hello, While trying to open database encounter that error : ORA-03113: end-of-file on communication channel [oracle@oel6 admin]$ sqlplus /...