Configure a schema to support a star transformation query

warehouse
data

#1

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;