Table Locks are an important part of Oracle Working Mechanism as they provide security from unwanted deletion or modification of table’s data which can sometimes…
View More Enable or Disable Table Locks in Oracle Database
Tag: Oracle 11g
Find password for database link (<= 11.2.0.2)!
when we need to recreate a database link for some reason and we do not happen to have the password handy, weβre usually stuck. However,…
View More Find password for database link (<= 11.2.0.2)!
Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS
DBMS_STATS package was introduced in Oracle 8i and used to gather Database,table,Schema,dictionary and fixed object statistic in Oracle database. Statistic of objects should be up…
View More Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS