Technical Blog

select table_name, num_rows, blocks, avg_row_len from dba_tables where table_name='EMP'; select table_name, monitoring from dba_...

Step 1: SELECT 1  FROM DUAL WHERE EXISTS (SELECT 1 FROM  scott.experiment_lt   WHERE VERSION IN (SELECT VERSION FROM wmsys.wm$version_hie...

Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple r...

Oracle Baseline ...

All Oracle data is obtained by users from the buffer cache.The basic purpose of the cache is to minimize physical disk I/O by holding (buff...