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)!
Tag: Oracle 11g
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