As their name implies, locally managed tablespaces do not manage their free and used extents by the data dictionary but are instead managed at the local tablespace level. This local management is acco...
Overview
In typical data warehousing environment existence of huge partitioned tables is very common, gathering statistics on such tables is challenging tasks. For partitioned tables there are two typ...
When monitoring redo logs, instead of direct views for statistics, we must look at statistics based on redo log and log writer process statistics. These views are: V$STATNAME
V$SESSION
V$PROCESS
V$SE...
