Configure a schema to support a star transformation query

[batmunkh (Batmunkh Moltov)]

Oracle STAR Transformations and SQL

---

Datawarehouse идэвхжүүлэхийн тулд дараах параметруудыг ашиглана.

• cursor_space_for_time=TRUE

• db_cache_size=XXX

• db_block_size=32

• db_file_multiblock_read_count=64

• filesystemio_options=ASYNC

• pga_aggregate_target=XXX

• optimizer_index_cost_adj=XXX

• optimizer_index_caching=XXX

• query_rewrite_enabled=TRUE

• shared_pool_size=150M

• star_transformation_enabled=TRUE

• workarea_size_policy=AUTO

• session_cached_cursors=100

• log_buffer=XXX

• bitmap_merge_area_size=XXX

• create_bitmap_area_size=XXX

  SHOW PARAMETER STAR_TRANSFORMATION_ENABLED
  ALTER SYSTEM SET STAR_TRANSFORMATION_ENABLED=TRUE SCOPE=BOTH;