Abdul Hafeez Kalsekar -- Oracle database tuning case studies

   Data can be modified as it loads into the Oracle Database. One can also populate columns with static or derived values. However, this only applies for the conventional load path (and not for direct path loads SQL*Loader provides the following methods to load data: Conventional path loads – construct INSERT statements from the contents of the input datafile based on the predefined specification and execute the inserts. Direct path loads – creates data blocks in Oracle database block format from the datafile and directly writes the data block to the database. This way is much faster than the conventional path but subject to some restrictions. External table loads – create an external table for the data stored in the datafile and execute INSERT statements to insert the data from the datafile into the target table. The external table loads support parallel loading if datafile is big enough. To execute the SQL*Load tool, you need at least three files: The input data file stores ...

  >>>>>>>>>>  Tablespace Growth >>>>>>>>>>   col ts_mb for 999,999,999,999.90  col max_mb for 999,999,999,999.90  col used_mb for 999,999,999,999.90  col last_mb for 999,999,999,999.90  col incr for 999,999.90     select * from (   select v.name  , v.ts#  , s.instance_number  , h.tablespace_size   * p.value/1024/1024 ts_mb  , h.tablespace_maxsize   * p.value/1024/1024 max_mb  , h.tablespace_usedsize   * p.value/1024/1024 used_mb  , to_date(h.rtime, 'MM/DD/YYYY HH24:MI:SS') resize_time  , lag(h.tablespace_usedsize * p.value/1024/1024, 1, h.tablespace_usedsize * p.value/1024/1024)   over (partition by v.ts# order by h.snap_id) last_mb  , (h.tablespace_usedsize * p.value/1024/1024)   - lag(h.tablespace_usedsize * p.value/1024/1024, 1, h.tablespace_usedsize * p.value/1024/1024)   over (partition by v.ts# orde...

  SET LINES 999 SET PAGES 300 COL "PARAMETER" FOR A40  COL "IS_DEFAULT" FOR A10 COL "SESSION" FOR A10 COL "INSTANCE" FOR A10 COL "IS_SESSION_MODIFIABLE" FOR A21 COL "IS_SYSTEM_MODIFIABLE" FOR A20 SELECT a.KSPPINM "PARAMETER",         b.KSPPSTDF "IS_DEFAULT",        b.KSPPSTVL "SESSION",         c.KSPPSTVL "INSTANCE",        DECODE(BITAND(a.KSPPIFLG/256,1),1,'TRUE','FALSE') IS_SESSION_MODIFIABLE,         DECODE(BITAND(a.KSPPIFLG/65536,3),1,'IMMEDIATE',2,'DEFERRED',3,'IMMEDIATE','FALSE') IS_SYSTEM_MODIFIABLE FROM   X$KSPPI  a,        X$KSPPCV b,        X$KSPPSV c WHERE  a.INDX = b.INDX AND    a.INDX = c.INDX AND    a.KSPPINM LIKE '/_%' escape '/' AND    a.KSPPINM LIKE NVL('%&hidden_parameter%','') / SELECT a.ksppinm "Parameter", b.KSPPSTDF "Default Value",     ...

  In this Document Goal Solution   Storage summary   Find out which segments to move from a tablespace   TABLE PARTITION   Example   TABLE / LOB SUBPARTITION   DEFAULT TABLESPACES   INDEX PARTITION and INDEX SUBPARTITION   Restrictions on INDEX REBUILD    Notes on nested tables References Applies to: Oracle Database - Enterprise Edition - Version 11.2.0.1 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Information in this document applies to any platform. Goal NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product.  Any similarity to actual persons, living or dea...