August 2022 – DBA Notes

Oracle

Enable or Disable Table Locks in Oracle Database

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…

Oracle

Column Histograms in Oracle 11g

Bulent Soylu August 17, 2022 frequency histograms height-balanced histograms histograms oracle performance

Data skew in a column can make it difficult for the optimizer to accurately estimate the cardinality of an operation. Without a histogram it will…

Oracle

Oracle Text Index

Bulent Soylu August 16, 2022 CTXCAT CTXRULE Indexes oracle Oracle Text Oracle Text Index preferences

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…