|
-
Did not get any performance gains or even reduced logging by switching to nologging mode of table and indexes.
Why. Am I missing a step or parameter.
The process (covering 10 tables) is actually now taking more time to complete earlier was 14 minutes, now 16 minutes
--logging mode
drop table a
create table a as select * from a_view
create indexes
set grants
select value from v$mystat, v$statname where v$mystat.statistic# = v$statname.statistic# and v$statname.name = 'redo size';
before run and after run 'value' = 10254896
-------------------
--nologging mode
truncate table a
alter table a nologging;
insert /*+ APPEND */ into table a as select * from a_view
create indexes parallel 2 NOLOGGING
select value from v$mystat, v$statname where v$mystat.statistic# = v$statname.statistic# and v$statname.name = 'redo size';
before run and after run 'value' = 11657796
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|