Technical Blog

High water mark is the maximum amount of database blocks used so far by a segment. This mark cannot be reset by delete operations. When ...

CREATE TABLE t1 (c1 NUMBER); CREATE INDEX t1_idx ON t1(c1); ALTER INDEX t1_idx MONITORING USAGE ; SELECT table_name, index_name, monitor...

Try to avoid using  following in triggers 1) UTL_ packages .  They do not roll back 2) Pragma autonomous_transaction only use if it is ...

In B tree index single column indexes do not include entries for null values ; but bitmap and function based index can store all null entri...