With Oracle text indexes (or Domain index), we can index text documents and search it based on contents using text patterns with specialized text query operators. Oracle…
View More Oracle Text Index
Category: Oracle
Oracle
Export Import statistics with dbms_stats in Oracle
You can use the Oracle dbms_stats and export utilities to migrate schema statistics from your PROD instance to your TEST instance, so that your developers…
View More Export Import statistics with dbms_stats in Oracle
Oracle Version Numbers
Something that always comes up when discussing Oracle versions is that I am not always sure which number is the Major Database Release and which is the Database…
View More Oracle Version Numbers
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)!
How to check progress of a long running statistics gathering job
If you have a long-running statistics job running, you can check it from v$session_longops: For example, you execute: Check progress with:
View More How to check progress of a long running statistics gathering job
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
convert seconds into mins hours in Oracle
Oracle Standby Redo Logs vs Online Redo Logs:
Redo Logs Conceptually, Oracle Redo Logs are a collection of Redo records. Redo records are a group of change vectors. Each change vector denotes a…
View More Oracle Standby Redo Logs vs Online Redo Logs:
DBA Interview Questions
1-Explain the security practices such as LDAP SSL SSO and certificate management LDAP: Lightweight Directory Access Protocol–LDAP is a tool for extracting and editing data…
View More DBA Interview Questions
Drop Objects in Oracle
The best and most efficient way is to catch the “table not found” exception: this avoids the overhead of checking if the table exists twice;…
View More Drop Objects in Oracle