Call: 080-42275527 / +91-9916056387

Oracle object management

3-1: ORACLE TABLES, VIEWS AND MATERIALIZED VIEWS

  • Types of Oracle tables (regular, IOT, sorted hash clusters, nested tables)
  • Oracle Views
  • Oracle materialized views

 

3-2: ORACLE INDEXES

  • Types of Oracle indexes (b-tree, bitmap, bitmap join index)
  • Creating B*-Tree, bitmap and function-based Indexes
  • Function-based indexes
  • Finding indexing opportunities
  • Index maintenance

 

3-3: ORACLE CONSTRAINTS

  • Costs & benefits of constraints
  • Types of Oracle indexes constraints (check, not null, unique, PK, FK)
  • Cascading constraints

 

3-4: SCHEMA, FILE & TABLESPACE MANAGEMENT

  • Describing the relationship between data files, tablespaces and table
  • Understanding Oracle segments
  • Creating Tablespaces – using the autoextend option
  • Changing the Size of Tablespaces – alter database datafile command
  • Defining a TEMP tablespace
  • Changing the default storage Settings for a tablespace
  • Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists).
  • Monitoring Chained rows (fetch continued rows)
  • Monitoring Insert and Update performance (pctused, APPEND)

 

3-5: DATABASE MAINTENANCE

  • Reason for reorgs – chained rows, imbalanced freelists
  • Reorganizing Tables using Export and Import
  • Using CTAS to reorganize data
  • Index rebuilding
  • Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking)

 

3-6: ORACLE DBA UTILITIES

  • Data pump (Imp and exp utilities)
  • SQL*Loader
  • LogMiner
  • Flashback
  • DataGuard
  • Oracle DBA utilities – Oracle dbms packages (dbms_redefinition)
  • Replication (Streams, multimaster, materialized views)
Scroll Up