HFM – Web Demo from Oracle

http://oukc.oracle.com/static05/opn/Hyperion/51236_TOI/060308_51236/D2/D2.html

http://oukc.oracle.com/static05/opn/Hyperion/45824//083007_45824_source/45824_demo.html

http://oukc.oracle.com/static05/opn/Hyperion/45945/091907_45945/45945_demo.html

http://oukc.oracle.com/static05/opn/Hyperion/48026//011808_48026/011808_48026_demo.html

http://oukc.oracle.com/static05/opn/Hyperion/48023//122107_48023_source/122107_48023_demo.html

http://oukc.oracle.com/static05/opn/Hyperion/51236_TOI/060308_51236/D3/D3.html

http://oukc.oracle.com/static05/opn/Hyperion/51236_TOI/060308_51236/D1/D1.html

Настраиваем оптимальное использование REDOLOG для HFM


CREATE TABLESPACE HypDWH DATAFILE
SIZE 5120M AUTOEXTEND ON NEXT 100M

MAXSIZE UNLIMITED NOLOGGING ONLINE PERMANENT

EXTENET MANAGEMENT LOCAL UNIFORM SIZE 1M
/*EXTENT MANAGEMENT LOCAL AUTOALLOCATE */
BLOCKSIZE 8Kb
SEGMENT SPACE MANAGEMENT AUTO



CREATE OR REPLACE
PROCEDURE ALT_NOLOGING AS
cursor SqlQuery is select table_name from user_tables ;
TName varchar2(80);
BEGIN

open SqlQuery;

fetch SqlQuery into TName;
while SqlQuery%FOUND loop
EXECUTE IMMEDIATE '
alter table '|| TName ||' nologging ';
fetch SqlQuery into TName;
end loop;
close SqlQuery;
END ALT_NOLOGING;

http://oradbatips.blogspot.com/2007/11/tip-63-direct-load-and-redo-log.html

http://www.adp-gmbh.ch/ora/misc/nologging.html

http://www.dba-oracle.com/t_optimize_insert_sql_performance.htm